APPS.PAY_PBF_BUS dependencies on PAY_BALANCE_FEEDS_F

Line 30: , pay_balance_feeds_f pbf

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: --
34: -- Declare local variables

Line 100: , pay_balance_feeds_f pbf

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: --
104: -- Declare local variables

Line 598: ,p_business_group_id in pay_balance_feeds_f.business_group_id%type

594: --
595: -- ----------------------------------------------------------------------------
596: Procedure chk_input_value_id
597: (p_input_value_id in number
598: ,p_business_group_id in pay_balance_feeds_f.business_group_id%type
599: ,p_legislation_code in pay_balance_feeds_f.legislation_code%type
600: ) is
601: --
602: l_proc varchar2(72) := g_package||'chk_input_value_id';

Line 599: ,p_legislation_code in pay_balance_feeds_f.legislation_code%type

595: -- ----------------------------------------------------------------------------
596: Procedure chk_input_value_id
597: (p_input_value_id in number
598: ,p_business_group_id in pay_balance_feeds_f.business_group_id%type
599: ,p_legislation_code in pay_balance_feeds_f.legislation_code%type
600: ) is
601: --
602: l_proc varchar2(72) := g_package||'chk_input_value_id';
603: l_exists varchar2(1);

Line 617: from pay_balance_feeds_f pbf

613: = nvl(p_business_group_id, hr_api.g_number);
614:
615: cursor csr_ipv_multiple_feeds is
616: select null
617: from pay_balance_feeds_f pbf
618: where pbf.input_value_id = p_input_value_id;
619: --
620: Begin
621: hr_utility.set_location('Entering:'||l_proc, 5);

Line 676: ,p_business_group_id in pay_balance_feeds_f.business_group_id%type

672: --
673: -- ----------------------------------------------------------------------------
674: Procedure chk_balance_type_id
675: (p_balance_type_id in number
676: ,p_business_group_id in pay_balance_feeds_f.business_group_id%type
677: ,p_legislation_code in pay_balance_feeds_f.legislation_code%type
678: ) is
679: --
680: l_proc varchar2(72) := g_package||'chk_balance_type_id';

Line 677: ,p_legislation_code in pay_balance_feeds_f.legislation_code%type

673: -- ----------------------------------------------------------------------------
674: Procedure chk_balance_type_id
675: (p_balance_type_id in number
676: ,p_business_group_id in pay_balance_feeds_f.business_group_id%type
677: ,p_legislation_code in pay_balance_feeds_f.legislation_code%type
678: ) is
679: --
680: l_proc varchar2(72) := g_package||'chk_balance_type_id';
681: l_exists varchar2(1);

Line 815: ,p_business_group_id in pay_balance_feeds_f.business_group_id%type

811: -- {End Of Comments}
812:
813: procedure chk_initial_feed_exists
814: (p_balance_type_id in number
815: ,p_business_group_id in pay_balance_feeds_f.business_group_id%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';

Line 816: ,p_legislation_code in pay_balance_feeds_f.legislation_code%type

812:
813: procedure chk_initial_feed_exists
814: (p_balance_type_id in number
815: ,p_business_group_id in pay_balance_feeds_f.business_group_id%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;

Line 824: FROM pay_balance_feeds_f blf,

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,
825: pay_input_values_f inv,
826: pay_element_types_f elt,
827: pay_element_classifications ec
828: WHERE blf.balance_type_id = p_balance_type_id

Line 1097: FROM pay_balance_feeds_f

1093: l_proc varchar2(72) := g_package||'chk_bal_feed_unique';
1094:
1095: CURSOR csr_bal_feed_unique IS
1096: SELECT 1
1097: FROM pay_balance_feeds_f
1098: WHERE input_value_id = p_input_value_id
1099: AND balance_type_id =p_balance_type_id
1100: AND p_effective_date between effective_start_date and effective_end_date;
1101: