DBA Data[Home] [Help]

APPS.PAY_PRT_BUS dependencies on PER_BUSINESS_GROUPS

Line 28: from per_business_groups pbg

24: -- Declare cursor
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: --

Line 87: from per_business_groups pbg

83: -- Declare cursor
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: --

Line 738: from per_business_groups

734: --
735: cursor get_bg_id
736: is
737: select business_group_id
738: from per_business_groups
739: where legislation_code = p_legislation_code;
740: --
741: l_proc varchar2(72) := g_package || 'chk_for_child_actions';
742: l_error EXCEPTION;