37: AND H.ORGANIZATION_ID = X_ORGANIZATION_RUN_BY_ID;
38:
39: CURSOR CH3 IS
40: SELECT 1
41: FROM hr_locations l
42: WHERE X_DATE_START <= nvl(l.inactive_date,X_CTL_GLOBALS_END_OF_TIME)
43: AND LOCATION_ID = X_LOCATION_ID;
44: ---
45: --- commented to allow update of organization run by of events.
639: FROM SYS.DUAL;
640:
641: CURSOR LOCATION_CHECK IS
642: select 1
643: from hr_locations l
644: where l.location_id = X_Location_Id
645: and nvl(l.inactive_date,X_ctl_globals_end_of_time) >= X_date_start;
646:
647: cursor csr_get_party_id is
1035: L_DUMMY NUMBER;
1036:
1037: CURSOR LOCATION_CHECK IS
1038: select 1
1039: from hr_locations l
1040: where l.location_id = X_Location_Id
1041: and nvl(l.inactive_date,X_ctl_globals_end_of_time) >= X_Date_Start;
1042:
1043: BEGIN