DBA Data[Home] [Help]

APPS.PAY_ASG_DEBUG_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 158: pay_element_links_f pel,

154: to_char(pev.effective_start_date,'MM/DD/YYYY') effective_start_date,
155: decode(to_char(pev.effective_end_date,'MM/DD/YYYY'),'12/31/4712',
156: NULL, to_char(pev.effective_end_date,'MM/DD/YYYY')) effective_end_date
157: from pay_element_types_f pet,
158: pay_element_links_f pel,
159: pay_element_entries_f pef,
160: pay_element_entry_values_f pev
161: where pet.element_name in ('VERTEX', 'Workers Compensation')
162: and pet.element_type_id = pel.element_type_id