APPS.PER_ABS_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 103: per_all_assignments_f paa,

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

Line 969: FROM per_all_assignments_f asg,

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

Line 1966: per_all_assignments_f asg,

1962: from pay_element_entries_f pee,
1963: pay_element_links_f pel,
1964: pay_element_types_f pet,
1965: pay_input_values_f piv,
1966: per_all_assignments_f asg,
1967: per_absence_attendance_types abt,
1968: pay_accrual_plans pap
1969: where abt.absence_attendance_type_id = p_absence_attendance_type_id
1970: and abt.input_value_id = piv.input_value_id