APPS.BEN_EXTRACT_SEED dependencies on PER_ORGANIZATION_UNITS

Line 349: cursor c4 is SELECT name from PER_ORGANIZATION_UNITS

345: cursor c3 is SELECT user_status from PER_ASSIGNMENT_STATUS_TYPES
346: WHERE active_flag ='Y'
347: and assignment_status_type_id = p_val;
348:
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

Line 1109: cursor c4 is SELECT organization_id from PER_ORGANIZATION_UNITS

1105: = nvl(p_business_group_id,-1)
1106: and active_flag ='Y'
1107: and user_status = p_meaning;
1108:
1109: cursor c4 is SELECT organization_id from PER_ORGANIZATION_UNITS
1110: WHERE nvl(business_group_id,nvl(p_business_group_id,-1))
1111: = nvl(p_business_group_id,-1)
1112: and trunc(sysdate)
1113: between nvl(date_from,trunc(sysdate))