DBA Data[Home] [Help]

APPS.PQP_GB_PSI_WPS_HISTORY dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 149: FROM pay_element_type_extra_info

145: p_element_type_id IN NUMBER
146: )
147: IS
148: SELECT eei_information1
149: FROM pay_element_type_extra_info
150: WHERE element_type_id = p_element_type_id
151: AND information_type = 'PQP_GB_PENSION_SCHEME_INFO';
152:
153: /* to check if the buy back element is valid */

Line 161: FROM pay_element_type_extra_info

157: ,p_pension_scheme_name IN VARCHAR2
158: )
159: IS
160: SELECT eei_information1
161: FROM pay_element_type_extra_info
162: WHERE element_type_id = p_element_type_id
163: AND information_type = 'PQP_GB_PENSION_SCHEME_INFO'
164: AND eei_information1 = p_pension_scheme_name;
165:

Line 197: ,pay_element_type_extra_info pete

193: IS
194: SELECT peev.screen_entry_value
195: FROM pay_element_types_f pet
196: ,pay_element_entries_f pee
197: ,pay_element_type_extra_info pete
198: ,pay_element_entry_values_f peev
199: ,pay_input_values_f piv
200: WHERE pee.assignment_id = p_assignment_id -- 301168
201: AND pee.element_type_id = pet.element_type_id -- 172156