APPS.PAY_RTT_BUS dependencies on PAY_RUN_TYPES_F_TL

Line 31: , pay_run_types_f_tl rtt

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: --
35: -- Declare local variables

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 100: , pay_run_types_f_tl rtt

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;
104: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;

Line 331: , pay_run_types_f_tl rtt

327: ,p_leg_code varchar2)
328: is
329: select 'Y'
330: from pay_run_types_f prt
331: , pay_run_types_f_tl rtt
332: where prt.run_type_id = rtt.run_type_id
333: and rtt.language = p_language
334: and upper(p_run_type_name) = upper(rtt.run_type_name)
335: and (prt.run_type_id <> p_run_type_id