DBA Data[Home] [Help]

APPS.PJI_AUDIT_RPT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 520: HR_ALL_ORGANIZATION_UNITS all_org

516: p_params_util_flag = 'Y') and
517: org.ORGANIZATION_ID = denorm.ORGANIZATION_ID (+) and
518: denorm.ORGANIZATION_ID is null
519: ) org,
520: HR_ALL_ORGANIZATION_UNITS all_org
521: where
522: org.ORGANIZATION_ID = all_org.ORGANIZATION_ID
523: order by all_org.NAME;
524:

Line 741: hr_all_organization_units org

737:
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;

Line 784: hr_all_organization_units org

780:
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