APPS.PQP_PL_VEHICLE_ALLOCATIONS dependencies on PER_ALL_ASSIGNMENTS_F

Line 160: per_all_assignments_f paaf

156: pay_element_entry_values_f peevf,
157: pay_input_values_f pivf,
158: pay_element_entries_f peef,
159: pqp_vehicle_allocations_f pvaf,
160: per_all_assignments_f paaf
161: where
162: peevf.element_entry_id = peef.element_entry_id and
163: peef.element_type_id = petf.element_type_id and
164: petf.element_type_id = peef.element_type_id and

Line 183: per_all_assignments_f paa

179:
180: cursor csr_pay_period(p_assignment_id number) is
181: SELECT max(ptp.end_date)
182: FROM per_time_periods ptp,
183: per_all_assignments_f paa
184: where ptp.payroll_id = paa.payroll_id and
185: paa.assignment_id = p_assignment_id;
186:
187: l_element_entry_id pay_element_entries_f.element_entry_id%type;

Line 188: l_assignment_id per_all_assignments_f.assignment_id%type;

184: where ptp.payroll_id = paa.payroll_id and
185: paa.assignment_id = p_assignment_id;
186:
187: l_element_entry_id pay_element_entries_f.element_entry_id%type;
188: l_assignment_id per_all_assignments_f.assignment_id%type;
189: l_period_end_date per_time_periods.end_date%type;
190: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
191:
192: l_effective_start_date date;