DBA Data[Home] [Help]

APPS.PER_IE_VEHICLE_ALLOC_RULES dependencies on PQP_VEHICLE_ALLOCATIONS_F

Line 19: pqp_vehicle_allocations_f pva,

15: FROM pay_element_types_f pet,
16: pay_element_entry_values_f peev,
17: pay_input_values_f piv,
18: pay_element_entries_f pee,
19: pqp_vehicle_allocations_f pva,
20: pay_element_links_f pel,
21: pay_payroll_actions ppa,
22: pay_assignment_actions paas,
23: pay_run_results prr,

Line 68: pqp_vehicle_allocations_f pva

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
72: -- AND ptp.regular_payment_date>p_max_effective_date; -- 5872123