APPS.PER_ABS_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 104: per_all_assignments_f paa,

100: pev.effective_start_date,
101: pev.effective_end_date
102: from pay_element_entry_values_f pev,
103: pay_element_entries_f pee,
104: per_all_assignments_f paa,
105: per_absence_attendance_types abt
106: where pev.element_entry_id = pee.element_entry_id
107: and pev.input_value_id = abt.input_value_id
108: and pee.assignment_id = paa.assignment_id

Line 973: FROM per_all_assignments_f asg,

969: --
970: cursor c_get_normal_hours (p_assignment_id in number) is
971: select nvl(nvl(asg.time_normal_start, pbg.default_start_time), '00:00'),
972: nvl(nvl(asg.time_normal_finish, pbg.default_end_time), '23:59')
973: FROM per_all_assignments_f asg,
974: per_business_groups pbg
975: WHERE asg.assignment_id = p_assignment_id
976: AND asg.business_group_id = pbg.business_group_id
977: AND p_effective_date between asg.effective_start_date

Line 1138: FROM per_all_assignments_f asg,

1134: --
1135: cursor c_get_normal_hours (p_assignment_id in number) is
1136: select nvl(nvl(asg.time_normal_start, pbg.default_start_time), '00:00'),
1137: nvl(nvl(asg.time_normal_finish, pbg.default_end_time), '23:59')
1138: FROM per_all_assignments_f asg,
1139: per_business_groups pbg
1140: WHERE asg.assignment_id = p_assignment_id
1141: AND asg.business_group_id = pbg.business_group_id
1142: AND p_effective_date between asg.effective_start_date

Line 2308: per_all_assignments_f asg,

2304: from pay_element_entries_f pee,
2305: pay_element_links_f pel,
2306: pay_element_types_f pet,
2307: pay_input_values_f piv,
2308: per_all_assignments_f asg,
2309: per_absence_attendance_types abt,
2310: pay_accrual_plans pap
2311: where abt.absence_attendance_type_id = p_absence_attendance_type_id
2312: and abt.input_value_id = piv.input_value_id