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
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))