APPS.PAY_PRT_BUS dependencies on PAY_RUN_TYPES_F

Line 29: , pay_run_types_f prt

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , pay_run_types_f prt
30: where prt.run_type_id = p_run_type_id
31: and pbg.business_group_id = prt.business_group_id;
32: --
33: -- Declare local variables

Line 88: , pay_run_types_f prt

84: --
85: cursor csr_leg_code is
86: select pbg.legislation_code
87: from per_business_groups pbg
88: , pay_run_types_f prt
89: where prt.run_type_id = p_run_type_id
90: and pbg.business_group_id (+) = prt.business_group_id;
91: --
92: -- Declare local variables

Line 164: from pay_run_types_f prt

160: --
161: cursor csr_get_bg_id
162: is
163: select prt.business_group_id
164: from pay_run_types_f prt
165: where prt.run_type_id = p_run_type_id;
166: --
167: l_legislation_code varchar2(150);
168: l_bg_id number(15);

Line 333: from pay_run_types_f prt

329: --
330: /*
331: cursor csr_rt_name is
332: select prt.run_type_name
333: from pay_run_types_f prt
334: where prt.run_type_name = p_run_type_name
335: and nvl(prt.business_group_id, -1) = nvl(p_business_group_id
336: , nvl(prt.business_group_id, -1))
337: and nvl(prt.legislation_code, 'CORE') = nvl(p_legislation_code, 'CORE')

Line 343: from pay_run_types_f prt

339: and prt.effective_end_date;
340: */
341: cursor csr_rt_name_u is
342: select prt.run_type_name
343: from pay_run_types_f prt
344: where prt.business_group_id = p_business_group_id
345: and prt.legislation_code is null
346: and prt.run_type_name = p_run_type_name
347: and p_effective_date between prt.effective_start_date

Line 352: from pay_run_types_f prt

348: and prt.effective_end_date;
349: --
350: cursor csr_rt_name_s is
351: select prt.run_type_name
352: from pay_run_types_f prt
353: where prt.legislation_code = p_legislation_code
354: and prt.business_group_id is null
355: and prt.run_type_name = p_run_type_name
356: and p_effective_date between prt.effective_start_date

Line 361: from pay_run_types_f prt

357: and prt.effective_end_date;
358: --
359: cursor csr_rt_name_g is
360: select prt.run_type_name
361: from pay_run_types_f prt
362: where prt.run_type_name = p_run_type_name
363: and prt.business_group_id is null
364: and prt.legislation_code is null
365: and p_effective_date between prt.effective_start_date

Line 1281: -- Currently the only columns that can be updated on pay_run_types_f are

1277: --
1278: Begin
1279: hr_utility.set_location('Entering:'||l_proc, 5);
1280: --
1281: -- Currently the only columns that can be updated on pay_run_types_f are
1282: -- run_type_name and shortname. These can only be updated in CORRECTION
1283: -- mode, so if a different update mode has been passed in, raise an error
1284: -- NOTE: this will have to be changed if new columns with different update
1285: -- requirements are added to the table.