DBA Data[Home] [Help]

APPS.BEN_EXTRACT_SEED dependencies on HR_LOCATIONS

Line 353: cursor c5 is select location_code from hr_locations

349: cursor c4 is SELECT name from PER_ORGANIZATION_UNITS
350: WHERE internal_external_flag = 'INT'
351: and organization_id = p_val;
352:
353: cursor c5 is select location_code from hr_locations
354: where trunc(sysdate) <=
355: nvl(inactive_date,to_date('31124712','DDMMYYYY'))
356: and location_id = p_val;
357:

Line 1118: cursor c5 is select location_id from hr_locations

1114: and nvl(date_to,trunc(sysdate))
1115: and internal_external_flag = 'INT'
1116: and name = p_meaning;
1117:
1118: cursor c5 is select location_id from hr_locations
1119: where trunc(sysdate) <=
1120: nvl(inactive_date,to_date('31124712','DDMMYYYY'))
1121: and location_code = p_meaning ;
1122: