DBA Data[Home] [Help]

APPS.PQP_GB_PSI_STH_HISTORY dependencies on PAY_EVENT_GROUP_USAGES

Line 137: FROM pay_event_group_usages pegu

133:
134: CURSOR csr_get_element_set_ids
135: IS
136: SELECT element_set_id
137: FROM pay_event_group_usages pegu
138: ,pay_event_groups peg
139: WHERE peg.event_group_name = 'PQP_GB_PSI_STH_ELEMENT_ENTRIES'
140: AND peg.legislation_code = 'GB'
141: AND peg.business_group_id IS NULL

Line 303: ,pay_event_group_usages pegu

299: ,piv.name
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'