DBA Data[Home] [Help]

APPS.PER_IE_VEHICLE_ALLOC_RULES dependencies on PER_ALL_ASSIGNMENTS_F

Line 24: per_all_assignments_f paa

20: pay_element_links_f pel,
21: pay_payroll_actions ppa,
22: pay_assignment_actions paas,
23: pay_run_results prr,
24: per_all_assignments_f paa
25: WHERE pee.assignment_id = pva.assignment_id
26: AND p_effective_date BETWEEN
27: pee.effective_start_date AND pee.effective_end_date
28: AND pel.element_type_id = pet.element_type_id -- Bug No.3648575

Line 67: per_all_assignments_f paa,

63:
64: CURSOR csr_pay_period(p_max_effective_date in DATE,p_max_date_earned in DATE) IS -- 5872123
65: SELECT min(ptp.end_date)
66: FROM per_time_periods ptp,
67: per_all_assignments_f paa,
68: pqp_vehicle_allocations_f pva
69: WHERE ptp.payroll_id = paa.payroll_id
70: AND paa.assignment_id = pva.assignment_id
71: AND pva.vehicle_allocation_id = p_vehicle_allocation_id