APPS.PAY_RTT_BUS dependencies on PAY_RUN_TYPES_F

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 236: -- pay_run_types_f.

232: -- {Start Of Comments}
233: --
234: -- Description:
235: -- The surrogate key, run_type_id must exist on the non-translated table
236: -- pay_run_types_f.
237: --
238: -- Pre Conditions:
239: -- g_old_rec has been populated with details of the values currently in
240: -- the database.

Line 248: -- pay_run_types_f.

244: -- record set to.
245: --
246: -- Post Success:
247: -- Processing continues if the run_type_id exist on the non-translated table
248: -- pay_run_types_f.
249: --
250: -- Post Failure:
251: -- An application error is raised if run_type_id does not exist on
252: -- pay_run_types_f.

Line 252: -- pay_run_types_f.

248: -- pay_run_types_f.
249: --
250: -- Post Failure:
251: -- An application error is raised if run_type_id does not exist on
252: -- pay_run_types_f.
253: --
254: -- {End Of Comments}
255: -- ----------------------------------------------------------------------------
256: Procedure chk_run_type_id

Line 262: FROM pay_run_types_f prt

258: --
259: CURSOR csr_chk_rt_id
260: IS
261: SELECT prt.run_type_id
262: FROM pay_run_types_f prt
263: WHERE prt.run_type_id = p_run_type_id;
264: --
265: l_proc varchar2(72) := g_package || 'chk_run_type_id';
266: l_error EXCEPTION;

Line 302: -- pay_run_types_f.

298: -- record set to.
299: --
300: -- Post Success:
301: -- Processing continues if the run_type_id exist on the non-translated table
302: -- pay_run_types_f.
303: --
304: -- Post Failure:
305: -- An application error is raised if run_type_id does not exist on
306: -- pay_run_types_f.

Line 306: -- pay_run_types_f.

302: -- pay_run_types_f.
303: --
304: -- Post Failure:
305: -- An application error is raised if run_type_id does not exist on
306: -- pay_run_types_f.
307: --
308: -- {End Of Comments}
309: -- ----------------------------------------------------------------------------
310: Procedure chk_tl_run_type_name

Line 323: from pay_run_types_f

319: CURSOR get_startup_data
320: is
321: select business_group_id
322: , legislation_code
323: from pay_run_types_f
324: where run_type_id = p_run_type_id;
325: --
326: CURSOR csr_tl_name_exists(p_bus_grp_id number
327: ,p_leg_code varchar2)

Line 330: from pay_run_types_f prt

326: CURSOR csr_tl_name_exists(p_bus_grp_id number
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)

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