DBA Data[Home] [Help]

APPS.PQP_GB_PSI_STH_HISTORY dependencies on PAY_EVENT_GROUPS

Line 138: ,pay_event_groups peg

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
142: AND peg.event_group_id = pegu.event_group_id;

Line 302: FROM pay_event_groups peg

298: ,pet.processing_type
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