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 */
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: --