DBA Data[Home] [Help]

APPS.PAY_GB_ENH_RETRO_PAY dependencies on PER_BUSINESS_GROUPS

Line 14: per_business_groups_perf pbg1,

10: SELECT DISTINCT
11: pet.element_type_id
12: FROM
13: pay_element_types_f pet,
14: per_business_groups_perf pbg1,
15: per_business_groups_perf pbg
16: WHERE
17: pbg1.legislation_code = pbg.legislation_code
18: AND

Line 15: per_business_groups_perf pbg

11: pet.element_type_id
12: FROM
13: pay_element_types_f pet,
14: per_business_groups_perf pbg1,
15: per_business_groups_perf pbg
16: WHERE
17: pbg1.legislation_code = pbg.legislation_code
18: AND
19: (

Line 144: per_business_groups

140: IS
141: SELECT
142: legislation_code
143: FROM
144: per_business_groups
145: WHERE
146: business_group_id = cp_business_group_id;
147: CURSOR c_element_set(cp_element_type_id IN NUMBER ,cp_classification_id IN
148: NUMBER ,cp_legislation_code IN VARCHAR2)

Line 287: per_business_groups

283: IS
284: SELECT
285: legislation_code
286: FROM
287: per_business_groups
288: WHERE
289: business_group_id = cp_business_group_id;
290: CURSOR c_retro_info(cp_legislation_code IN VARCHAR2)
291: IS