DBA Data[Home] [Help]

APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 207: pay_element_classifications pec,

203: SELECT pet.element_type_id, pee.element_entry_id,
204: pee.effective_start_date, pee.effective_end_date
205: FROM pay_element_entries_f pee,
206: pay_element_links_f pel,
207: pay_element_classifications pec,
208: pay_element_types_f pet
209: WHERE pee.assignment_id = c_assignment_id
210: AND pee.entry_type = 'E'
211: AND pee.creation_date BETWEEN c_effective_start_date

Line 245: pay_element_classifications pec,

241: SELECT pet.element_type_id, pee.element_entry_id,
242: pee.effective_start_date, pee.effective_end_date
243: FROM pay_element_entries_f pee,
244: pay_element_links_f pel,
245: pay_element_classifications pec,
246: pay_element_types_f pet
247: WHERE pee.assignment_id = c_assignment_id
248: AND pee.entry_type = 'E'
249: AND ( pee.effective_start_date BETWEEN c_effective_start_date