DBA Data[Home] [Help]

APPS.HR_PTO_VIEWS dependencies on PER_ALL_ASSIGNMENTS_F

Line 9: from per_all_assignments_f

5: --
6: --
7: cursor csr_get_asg_details(cp_assignment_id number, cp_effective_date date) is
8: select business_group_id, payroll_id
9: from per_all_assignments_f
10: where assignment_id = cp_assignment_id
11: and cp_effective_date between effective_start_date and effective_end_date;
12: --
13: cursor csr_get_aaid_details(cp_assignment_action_id number) is

Line 288: ,per_all_assignments_f paf

284: ,ee.element_entry_id, ee.effective_start_date ee_start_date
285: from pay_element_entries_f ee
286: ,pay_element_types_f et
287: ,pay_accrual_plans plan
288: ,per_all_assignments_f paf
289: ,per_all_people_f peo
290: ,hr_lookups lookup
291: where peo.person_id = cp_person_id
292: and cp_effective_date between peo.effective_start_date