DBA Data[Home] [Help]

APPS.PQP_GB_PSI_STH_HISTORY dependencies on PAY_ELEMENT_TYPES_F

Line 158: ,pay_element_types_f pet

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
161: AND pet.element_type_id = piv.element_type_id (+)
162: ORDER BY ELEMENT_NAME;

Line 306: ,pay_element_types_f pet

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
309: AND pegu.element_set_id = pes.element_set_id
310: AND pes.element_type_id = pet.element_type_id

Line 1009: ,pay_element_types_f pet

1005: IS
1006: SELECT peef.element_type_id
1007: ,pet.element_name
1008: FROM pay_element_entries_f peef
1009: ,pay_element_types_f pet
1010: WHERE peef.element_entry_id = p_element_entry_id
1011: AND pet.element_type_id = peef.element_type_id;
1012:
1013: CURSOR csr_get_ee_id