APPS.PAY_KR_WG_REPORT_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 102: from pay_element_types_f pet

98: IS
99: CURSOR csr_element_entry
100: IS
101: Select pee.element_entry_id
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

Line 149: ,pay_element_types_f pet

145: select peev.screen_entry_value
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

Line 191: ,pay_element_types_f pet

187: from pay_element_entries_f pee
188: ,pay_element_entry_values_f peev
189: ,pay_element_entries_f pee1
190: ,pay_input_values_f piv
191: ,pay_element_types_f pet
192: ,pay_element_entry_values_f peev1
193: ,pay_input_values_f piv1
194: where pee.element_entry_id = p_element_entry_id
195: and peev.screen_entry_value = pee.entry_information21

Line 236: ,pay_element_types_f pet

232: CURSOR csr_wg_exists (p_date date)
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'

Line 502: from pay_element_types_f pet

498: and piv.name = 'Pay Value'
499: and piv.legislation_code = 'KR'
500: and g_effective_date between piv.effective_start_date and piv.effective_end_date
501: and prr.element_type_id in (Select element_type_id
502: from pay_element_types_f pet
503: where element_name in ('Wage Garnishments', 'WG Redistributed Amount')
504: and legislation_code = 'KR'
505: and g_effective_date between pet.effective_start_date and pet.effective_end_date
506: );

Line 558: ,pay_element_types_f pet

554: select sum(nvl(peev.screen_entry_value, 0)) attachment_base
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

Line 711: ,pay_element_types_f pet

707: Select prrv.result_value
708: from pay_run_result_values prrv
709: ,pay_input_values_f piv
710: ,pay_run_results prr
711: ,pay_element_types_f pet
712: where prr.source_id = p_element_entry_id
713: and prr.assignment_action_id = p_assignment_action_id
714: and prr.run_result_id = prrv.run_result_id
715: and prrv.input_value_id = piv.input_value_id