APPS.PQP_GB_PSI_STH_HISTORY dependencies on PAY_ELEMENT_SET_MEMBERS

Line 146: p_element_set_id pay_element_set_members.element_set_id%TYPE

142: AND peg.event_group_id = pegu.event_group_id;
143:
144: CURSOR csr_get_element_type_details
145: (
146: p_element_set_id pay_element_set_members.element_set_id%TYPE
147: )
148: IS
149: SELECT pet.element_type_id
150: ,pet.element_name

Line 156: FROM pay_element_set_members pes

152: ,piv.input_value_id
153: ,piv.name
154: ,piv.uom
155: ,piv.unit_of_measure
156: FROM pay_element_set_members pes
157: ,pay_input_values_v piv
158: ,pay_element_types_f pet
159: WHERE pes.element_set_id = p_element_set_id
160: AND pes.element_type_id = pet.element_type_id

Line 304: ,pay_element_set_members pes

300: ,piv.uom
301: ,piv.unit_of_measure
302: FROM pay_event_groups peg
303: ,pay_event_group_usages pegu
304: ,pay_element_set_members pes
305: ,pay_input_values_v piv
306: ,pay_element_types_f pet
307: WHERE peg.event_group_name = 'PQP_GB_PSI_STH_ELEMENT_ENTRIES'
308: AND peg.event_group_id = pegu.event_group_id