PS Row security query manager...getting kicked off from peoplesoft session only for one oprid
Hi Team,
I have created one PS query.Please find the sql below.
SELECT A.ROLEUSER, C.OPRDEFNDESC, C.EMAILID, A.ROLENAME, B.DESCRLONG, D.BUSINESS_UNIT, D.EMPL_RCD,B.ROLENAME
FROM PSROLEUSER A, PSROLEDEFN B, (PSOPRDEFN C LEFT OUTER JOIN (PS_JOB D INNER JOIN PS_EMPLMT_SRCH_QRY D1 ON (D.EMPLID = D1.EMPLID AND D.EMPL_RCD = D1.EMPL_RCD AND D1.OPRID = 'gmurthy' )) ON D.EMPLID = C.EMPLID AND D.EFFDT =
(SELECT MAX(D_ED.EFFDT) FROM PS_JOB D_ED
WHERE D.EMPLID = D_ED.EMPLID
AND D.EMPL_RCD = D_ED.EMPL_RCD
I have created one PS query.Please find the sql below.
SELECT A.ROLEUSER, C.OPRDEFNDESC, C.EMAILID, A.ROLENAME, B.DESCRLONG, D.BUSINESS_UNIT, D.EMPL_RCD,B.ROLENAME
FROM PSROLEUSER A, PSROLEDEFN B, (PSOPRDEFN C LEFT OUTER JOIN (PS_JOB D INNER JOIN PS_EMPLMT_SRCH_QRY D1 ON (D.EMPLID = D1.EMPLID AND D.EMPL_RCD = D1.EMPL_RCD AND D1.OPRID = 'gmurthy' )) ON D.EMPLID = C.EMPLID AND D.EFFDT =
(SELECT MAX(D_ED.EFFDT) FROM PS_JOB D_ED
WHERE D.EMPLID = D_ED.EMPLID
AND D.EMPL_RCD = D_ED.EMPL_RCD
0