DBA Data[Home] [Help]

APPS.OE_PC_CONSTRAINTS_ADMIN_PUB dependencies on FND_RESPONSIBILITY_VL

Line 622: FROM FND_RESPONSIBILITY_VL R

618:
619: CURSOR C_ASSIGNED_RESP IS
620: SELECT 'FND_RESP'||R.application_id||':'||R.responsibility_id role_name
621: , R.responsibility_name role_display_name
622: FROM FND_RESPONSIBILITY_VL R
623: WHERE R.responsibility_id NOT IN (SELECT NVL(responsibility_id,R.responsibility_id)
624: FROM OE_PC_ASSIGNMENTS
625: WHERE CONSTRAINT_ID = p_constraint_id
626: )

Line 632: FROM FND_RESPONSIBILITY_VL R

628:
629: CURSOR C_EXCLUDED_RESP IS
630: SELECT 'FND_RESP'||R.application_id||':'||R.responsibility_id role_name
631: , R.responsibility_name role_display_name
632: FROM FND_RESPONSIBILITY_VL R
633: , OE_PC_EXCLUSIONS E
634: WHERE E.assignment_id = (SELECT assignment_id
635: FROM oe_pc_assignments
636: WHERE constraint_id = p_constraint_id