APPS.PAY_PBF_BUS dependencies on PER_BUSINESS_GROUPS

Line 29: from PER_BUSINESS_GROUPS_PERF pbg

25: -- Declare cursor
26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id,pbg.legislation_code
29: from PER_BUSINESS_GROUPS_PERF pbg
30: , pay_balance_feeds_f pbf
31: where pbf.balance_feed_id = p_balance_feed_id
32: and pbg.business_group_id = pbf.business_group_id;
33: --

Line 99: from per_business_groups_perf pbg

95: -- Declare cursor
96: --
97: cursor csr_leg_code is
98: select pbg.legislation_code
99: from per_business_groups_perf pbg
100: , pay_balance_feeds_f pbf
101: where pbf.balance_feed_id = p_balance_feed_id
102: and pbg.business_group_id (+) = pbf.business_group_id;
103: --

Line 604: l_legislation_code per_business_groups.legislation_code%type;

600: ) is
601: --
602: l_proc varchar2(72) := g_package||'chk_input_value_id';
603: l_exists varchar2(1);
604: l_legislation_code per_business_groups.legislation_code%type;
605:
606: cursor csr_ipv_id is
607: select '1'
608: from pay_input_values_f

Line 682: l_legislation_code per_business_groups.legislation_code%type;

678: ) is
679: --
680: l_proc varchar2(72) := g_package||'chk_balance_type_id';
681: l_exists varchar2(1);
682: l_legislation_code per_business_groups.legislation_code%type;
683:
684: cursor csr_bal_type_id is
685: select '1'
686: from pay_balance_types

Line 820: l_legislation_code per_business_groups.legislation_code%type;

816: ,p_legislation_code in pay_balance_feeds_f.legislation_code%type
817: ) is
818: --
819: l_proc varchar2(72) := g_package||'chk_initial_feed_exists';
820: l_legislation_code per_business_groups.legislation_code%type;
821:
822: CURSOR csr_initial_feed_exist IS
823: SELECT 1
824: FROM pay_balance_feeds_f blf,