APPS.PQP_PL_VEHICLE_ALLOCATIONS dependencies on PAY_ELEMENT_ENTRIES_F

Line 158: pay_element_entries_f peef,

154: cursor csr_element_entry is select peef.element_entry_id, peef.assignment_id, peef.object_version_number from
155: pay_element_types_f petf,
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

Line 187: l_element_entry_id pay_element_entries_f.element_entry_id%type;

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;
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:

Line 190: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

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;
193: l_effective_end_date date;
194: l_delete_warning boolean;