DBA Data[Home] [Help]

APPS.BEN_EXTRACT_SEED dependencies on PER_ORGANIZATION_UNITS

Line 402: cursor c4 is SELECT name from PER_ORGANIZATION_UNITS

398: cursor c3 is SELECT user_status from PER_ASSIGNMENT_STATUS_TYPES
399: WHERE active_flag ='Y'
400: and assignment_status_type_id = p_val;
401:
402: cursor c4 is SELECT name from PER_ORGANIZATION_UNITS
403: WHERE internal_external_flag = 'INT'
404: and organization_id = p_val;
405:
406: cursor c5 is select location_code from hr_locations

Line 1162: cursor c4 is SELECT organization_id from PER_ORGANIZATION_UNITS

1158: = nvl(p_business_group_id,-1)
1159: and active_flag ='Y'
1160: and user_status = p_meaning;
1161:
1162: cursor c4 is SELECT organization_id from PER_ORGANIZATION_UNITS
1163: WHERE nvl(business_group_id,nvl(p_business_group_id,-1))
1164: = nvl(p_business_group_id,-1)
1165: and trunc(sysdate)
1166: between nvl(date_from,trunc(sysdate))