APPS.PAY_KR_WG_REPORT_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 29: ,pay_element_entry_values_f peev

25: CURSOR csr_processing_type
26: IS
27: select peev.screen_entry_value processing_type
28: from pay_element_entries_f pee
29: ,pay_element_entry_values_f peev
30: ,pay_input_values_f piv
31: where pee.element_entry_id = p_element_entry_id
32: and peev.element_entry_id = pee.element_entry_id
33: and piv.name = 'Processing Type'

Line 58: ,pay_element_entry_values_f peev

54: IS
55: select peev.screen_entry_value obligation_release
56: ,peev.effective_end_date
57: from pay_element_entries_f pee
58: ,pay_element_entry_values_f peev
59: ,pay_input_values_f piv
60: where pee.element_entry_id = p_element_entry_id
61: and peev.element_entry_id = pee.element_entry_id
62: and piv.name ='Obligation Release'

Line 105: ,pay_element_entry_values_f peev

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
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'

Line 147: ,pay_element_entry_values_f peev

143: CURSOR csr_attach_seq
144: IS
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

Line 188: ,pay_element_entry_values_f peev

184: CURSOR csr_attachment_seq_no
185: IS
186: Select peev1.screen_entry_value attachment_seq_no
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

Line 192: ,pay_element_entry_values_f peev1

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
196: and piv.input_value_id = peev.input_value_id

Line 556: ,pay_element_entry_values_f peev

552: CURSOR csr_attachment_base (p_date DATE)
553: IS
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