APPS.BEN_EXT_UTIL dependencies on PER_ALL_ASSIGNMENTS_F

Line 1051: per_all_assignments_f

1047: l_benefits_dt date;
1048: ---
1049: cursor c_asg_exist is
1050: select 'x' from
1051: per_all_assignments_f
1052: where person_id = ben_ext_person.g_person_id
1053: and primary_flag = 'Y'
1054: and p_effective_Date between effective_start_date
1055: and effective_end_date ;

Line 1060: per_all_assignments_f

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

Line 1070: per_all_assignments_f

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

Line 1079: per_all_assignments_f

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