APPS.PAY_ROM_BUS dependencies on PAY_RUN_TYPE_ORG_METHODS_F

Line 29: , pay_run_type_org_methods_f rom

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , pay_run_type_org_methods_f rom
30: where rom.run_type_org_method_id = p_run_type_org_method_id
31: and pbg.business_group_id = rom.business_group_id;
32: --
33: -- Declare local variables

Line 89: , pay_run_type_org_methods_f rom

85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups pbg
89: , pay_run_type_org_methods_f rom
90: where rom.run_type_org_method_id = p_run_type_org_method_id
91: and pbg.business_group_id (+) = rom.business_group_id;
92: --
93: -- Declare local variables

Line 306: l_legislation_code pay_run_type_org_methods_f.legislation_code%TYPE := Null;

302: ,p_legislation_code in varchar2) is
303: --
304: l_exists varchar2(1);
305: l_proc varchar2(72) := g_package||'chk_run_type_id';
306: l_legislation_code pay_run_type_org_methods_f.legislation_code%TYPE := Null;
307: --
308: CURSOR csr_chk_user_run_type(p_leg_code varchar2) is
309: select 'Y'
310: from pay_run_types_f prt

Line 587: from pay_run_type_org_methods_f rom

583: --
584: CURSOR csr_chk_unique_priority_bg
585: is
586: select null
587: from pay_run_type_org_methods_f rom
588: where rom.run_type_id = p_run_type_id
589: and rom.org_payment_method_id = p_org_payment_method_id
590: and rom.priority = p_priority
591: and rom.effective_start_date <= p_validation_end_date

Line 598: from pay_run_type_org_methods_f rom

594: --
595: CURSOR csr_chk_unique_priority_leg
596: is
597: select null
598: from pay_run_type_org_methods_f rom
599: where rom.run_type_id = p_run_type_id
600: and rom.org_payment_method_id = p_org_payment_method_id
601: and rom.priority = p_priority
602: and rom.effective_start_date <= p_validation_end_date