DBA Data[Home] [Help]

APPS.HRI_OPL_ORGH_CT dependencies on PER_ALL_ASSIGNMENTS_F

Line 811: FROM per_all_assignments_f;

807: ,g_user_id last_updated_by
808: ,g_user_id last_update_login
809: ,g_user_id created_by
810: ,g_sysdate creation_date
811: FROM per_all_assignments_f;
812:
813: COMMIT;
814:
815: /* Write timing information to log */

Line 846: FROM per_all_assignments_f asg

842: CURSOR new_orgs_with_worker_csr
843: IS
844: --
845: SELECT DISTINCT asg.organization_id
846: FROM per_all_assignments_f asg
847: WHERE not exists (SELECT null
848: FROM hri_cs_organztn_ct org
849: WHERE org.org_organztn_pk = asg.organization_id);
850: --