APPS.BEN_EXTRACT_SEED dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 345: cursor c3 is SELECT user_status from PER_ASSIGNMENT_STATUS_TYPES

341: cursor c2 is select name
342: from ben_benfts_grp
343: where benfts_grp_id = p_val;
344:
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

Line 1100: from PER_ASSIGNMENT_STATUS_TYPES

1096: = nvl(p_business_group_id,-1)
1097: and name = p_meaning;
1098:
1099: cursor c3 is SELECT assignment_status_type_id
1100: from PER_ASSIGNMENT_STATUS_TYPES
1101: WHERE
1102: -- nvl(legislation_code,nvl(p_legislation_code,'~~nvl~~'))
1103: -- = nvl(p_legislation_code,'~~nvl~~') and
1104: nvl(business_group_id,nvl(p_business_group_id,-1))