DBA Data[Home] [Help]

APPS.PJI_AUDIT_RPT dependencies on PER_ORGANIZATION_LIST

Line 742: ,per_organization_list sec

738: SELECT org.name
739: BULK COLLECT INTO l_org_name_tbl
740: FROM
741: hr_all_organization_units org
742: ,per_organization_list sec
743: WHERE
744: org.organization_id = sec.organization_id
745: AND sec.security_profile_id = l_pji_security_prof;
746:

Line 785: ,per_organization_list sec

781: SELECT org.name
782: BULK COLLECT INTO l_ou_name_tbl
783: FROM
784: hr_all_organization_units org
785: ,per_organization_list sec
786: WHERE
787: org.organization_id = sec.organization_id
788: AND sec.security_profile_id = l_mo_security_prof
789: AND exists