APPS.BEN_EXT_UTIL dependencies on PER_ALL_ASSIGNMENTS_F

Line 1055: per_all_assignments_f

1051: l_benefits_dt date;
1052: ---
1053: cursor c_asg_exist is
1054: select 'x' from
1055: per_all_assignments_f
1056: where person_id = ben_ext_person.g_person_id
1057: and primary_flag = 'Y'
1058: and p_effective_Date between effective_start_date
1059: and effective_end_date ;

Line 1064: per_all_assignments_f

1060:
1061:
1062: cursor c_e_asg_exist is
1063: select 'x' from
1064: per_all_assignments_f
1065: where person_id = ben_ext_person.g_person_id
1066: and primary_flag = 'Y'
1067: and assignment_type = 'E' -- added by hmani bug 3629576
1068: and p_effective_Date between effective_start_date

Line 1074: per_all_assignments_f

1070:
1071:
1072: cursor c_A_asg_exist is
1073: select 'x' from
1074: per_all_assignments_f
1075: where person_id = ben_ext_person.g_person_id
1076: and assignment_type = 'A' -- applicatn does not have any primary
1077: and p_effective_Date between effective_start_date
1078: and effective_end_date ;

Line 1083: per_all_assignments_f

1079:
1080:
1081: cursor c_asg_term is
1082: select effective_end_date from
1083: per_all_assignments_f
1084: where person_id = ben_ext_person.g_person_id
1085: and primary_flag = 'Y'
1086: and assignment_type = 'E' -- added by hmani bug 3629576
1087: and effective_start_date < p_effective_Date