APPS.BEN_EXTRACT_SEED dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 398: cursor c3 is SELECT user_status from PER_ASSIGNMENT_STATUS_TYPES

394: cursor c2 is select name
395: from ben_benfts_grp
396: where benfts_grp_id = p_val;
397:
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

Line 1153: from PER_ASSIGNMENT_STATUS_TYPES

1149: = nvl(p_business_group_id,-1)
1150: and name = p_meaning;
1151:
1152: cursor c3 is SELECT assignment_status_type_id
1153: from PER_ASSIGNMENT_STATUS_TYPES
1154: WHERE
1155: -- nvl(legislation_code,nvl(p_legislation_code,'~~nvl~~'))
1156: -- = nvl(p_legislation_code,'~~nvl~~') and
1157: nvl(business_group_id,nvl(p_business_group_id,-1))