DBA Data[Home] [Help]

APPS.PAY_EST_BUS dependencies on PAY_ELEMENT_SETS

Line 32: , pay_element_sets_tl est

28: cursor csr_sec_grp is
29: select pbg.security_group_id,
30: pbg.legislation_code
31: from per_business_groups_perf pbg
32: , pay_element_sets_tl est
33: , pay_element_sets pes
34: where est.element_set_id = p_element_set_id
35: and pbg.business_group_id = pes.business_group_id;
36: --

Line 33: , pay_element_sets pes

29: select pbg.security_group_id,
30: pbg.legislation_code
31: from per_business_groups_perf pbg
32: , pay_element_sets_tl est
33: , pay_element_sets pes
34: where est.element_set_id = p_element_set_id
35: and pbg.business_group_id = pes.business_group_id;
36: --
37: -- Declare local variables

Line 105: , pay_element_sets_tl est

101: --
102: cursor csr_leg_code is
103: select pbg.legislation_code
104: from per_business_groups_perf pbg
105: , pay_element_sets_tl est
106: , pay_element_sets pes
107: where est.element_set_id = p_element_set_id
108: and est.language = p_language
109: and pbg.business_group_id = pes.business_group_id;

Line 106: , pay_element_sets pes

102: cursor csr_leg_code is
103: select pbg.legislation_code
104: from per_business_groups_perf pbg
105: , pay_element_sets_tl est
106: , pay_element_sets pes
107: where est.element_set_id = p_element_set_id
108: and est.language = p_language
109: and pbg.business_group_id = pes.business_group_id;
110: --