Skip to content

Instantly share code, notes, and snippets.

@kbens
Last active August 29, 2015 13:59
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save kbens/10472758 to your computer and use it in GitHub Desktop.
PeopleSoft Process Definition File Dependency
/* Process Sched Parameters */
SELECT prcsinstance,
prcsfilename
FROM psprcsparms
ORDER BY prcsinstance DESC
/* Stored at Process Defn Level */
SELECT prcsname,
prcsfilename
FROM ps_prcsdefn
WHERE prcsname LIKE 'TEST123'
/* Stored at Run Control Level */
SELECT a.prcsfilename,
a.*
FROM ps_prcsruncntldtl a
WHERE a.prcsname LIKE 'TEST123'
/* Update Run Control to match current Process Definition */
UPDATE ps_prcsruncntldtl a
SET a.prcsfilename = (SELECT c.prcsfilename
FROM ps_prcsdefn c
WHERE a.prcstype = c.prcstype
AND a.prcsname = c.prcsname)
WHERE a.prcstype = 'Application Engine'
AND a.prcsname = 'TEST123'
AND EXISTS (SELECT 'X'
FROM ps_prcsdefn b
WHERE a.prcstype = b.prcstype
AND a.prcsname = b.prcsname)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment