DBA Data[Home] [Help]

APPS.PAY_ETT_BUS dependencies on PAY_ELEMENT_TYPES_F

Line 31: , pay_element_types_f_tl ett

27: --
28: cursor csr_sec_grp is
29: select pbg.security_group_id
30: from per_business_groups pbg
31: , pay_element_types_f_tl ett
32: , pay_element_types_f etp
33: where ett.element_type_id = p_element_type_id
34: and pbg.business_group_id = etp.business_group_id
35: and ett.element_type_id = etp.element_type_id;

Line 32: , pay_element_types_f etp

28: cursor csr_sec_grp is
29: select pbg.security_group_id
30: from per_business_groups pbg
31: , pay_element_types_f_tl ett
32: , pay_element_types_f etp
33: where ett.element_type_id = p_element_type_id
34: and pbg.business_group_id = etp.business_group_id
35: and ett.element_type_id = etp.element_type_id;
36: --

Line 99: , pay_element_types_f_tl ett

95: --
96: cursor csr_leg_code is
97: select pbg.legislation_code
98: from per_business_groups pbg
99: , pay_element_types_f_tl ett
100: , pay_element_types_f etp
101: where ett.element_type_id = p_element_type_id
102: and pbg.business_group_id = etp.business_group_id
103: and ett.element_type_id = etp.element_type_id

Line 100: , pay_element_types_f etp

96: cursor csr_leg_code is
97: select pbg.legislation_code
98: from per_business_groups pbg
99: , pay_element_types_f_tl ett
100: , pay_element_types_f etp
101: where ett.element_type_id = p_element_type_id
102: and pbg.business_group_id = etp.business_group_id
103: and ett.element_type_id = etp.element_type_id
104: and ett.language = p_language;