DBA Data[Home] [Help]

APPS.PQP_GB_PSI_WPS_HISTORY dependencies on PAY_ELEMENT_TYPES_F

Line 115: SELECT element_name FROM pay_element_types_f

111: CURSOR get_wps_element_name
112: (p_element_type_id IN NUMBER
113: )
114: IS
115: SELECT element_name FROM pay_element_types_f
116: WHERE element_type_id = p_element_type_id
117: AND rownum=1;
118:
119: TYPE t_number IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 195: FROM pay_element_types_f pet

191: ,p_scheme_name IN VARCHAR2
192: )
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