APPS.PAY_KR_WG_REPORT_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 106: ,pay_element_links_f pel

102: from pay_element_types_f pet
103: ,pay_input_values_f piv
104: ,pay_element_entries_f pee
105: ,pay_element_entry_values_f peev
106: ,pay_element_links_f pel
107: where piv.input_value_id = peev.input_value_id
108: and pet.element_type_id = piv.element_type_id
109: and piv.name = 'Attachment Seq No'
110: and pet.element_name = 'Wage Garnishments'

Line 150: ,pay_element_links_f pel

146: from pay_element_entries_f pee
147: ,pay_element_entry_values_f peev
148: ,pay_input_values_f piv
149: ,pay_element_types_f pet
150: ,pay_element_links_f pel
151: where pee.element_entry_id = p_element_entry_id
152: and peev.element_entry_id = pee.element_entry_id
153: and peev.input_value_id = piv.input_value_id
154: and piv.name ='Attachment Seq No'

Line 237: ,pay_element_links_f pel

233: IS
234: select distinct pee.element_entry_id
235: from pay_element_entries_f pee
236: ,pay_element_types_f pet
237: ,pay_element_links_f pel
238: where pee.assignment_id = p_assignment_id
239: and pet.element_name = 'Wage Garnishments'
240: and pet.legislation_code = 'KR'
241: and pee.entry_type = 'E'

Line 559: ,pay_element_links_f pel

555: from pay_element_entries_f pee
556: ,pay_element_entry_values_f peev
557: ,pay_input_values_f piv
558: ,pay_element_types_f pet
559: ,pay_element_links_f pel
560: where pee.element_entry_id = p_element_entry_id
561: and pee.entry_type = 'E'
562: and peev.element_entry_id = pee.element_entry_id
563: and piv.input_value_id = peev.input_value_id