DBA Data[Home] [Help]

APPS.PAY_RTT_BUS dependencies on PER_BUSINESS_GROUPS

Line 30: from per_business_groups pbg

26: -- Declare cursor
27: --
28: cursor csr_sec_grp is
29: select pbg.security_group_id
30: from per_business_groups pbg
31: , pay_run_types_f_tl rtt
32: where rtt.run_type_id = p_run_type_id;
33: -- and pbg.business_group_id = business_group_id;
34: --

Line 93: -- pay_run_types_f_tl and PER_BUSINESS_GROUPS

89: --
90: -- Declare cursor
91: --
92: -- EDIT_HERE In the following cursor statement add join(s) between
93: -- pay_run_types_f_tl and PER_BUSINESS_GROUPS
94: -- so that the legislation_code for
95: -- the current business group context can be derived.
96: -- Remove this comment when the edit has been completed.
97: cursor csr_leg_code is

Line 99: from per_business_groups pbg

95: -- the current business group context can be derived.
96: -- Remove this comment when the edit has been completed.
97: cursor csr_leg_code is
98: select pbg.legislation_code
99: from per_business_groups pbg
100: , pay_run_types_f_tl rtt
101: -- , EDIT_HERE table_name(s) 333
102: where rtt.run_type_id = p_run_type_id
103: and rtt.language = p_language;