APPS.PAY_ELEMENT_TYPES_SWI_ND dependencies on PAY_BALANCE_FEEDS_F

Line 735: l_balance_feed_id pay_balance_feeds_f.balance_feed_id%type;

731: p_legislation_code VARCHAR2,
732: p_effective_start_date DATE,
733: p_effective_end_date DATE) AS
734: l_row_id rowid;
735: l_balance_feed_id pay_balance_feeds_f.balance_feed_id%type;
736: l_proc varchar2(160);
737: l_count number(9);
738: --
739: cursor c1_get_reg_earn_feeds is

Line 746: from PAY_BALANCE_FEEDS_F BF,

742: ,iv.input_value_id
743: ,bf.scale
744: ,et.element_type_id
745: ,bt.legislation_code
746: from PAY_BALANCE_FEEDS_F BF,
747: PAY_BALANCE_TYPES BT,
748: PAY_INPUT_VALUES_F IV,
749: PAY_ELEMENT_TYPES_F ET,
750: PAY_ELEMENT_CLASSIFICATIONS EC,

Line 783: from pay_balance_feeds_f

779: for c1_rec in c1_get_reg_earn_feeds loop
780: for c2_rec in c2_balance_type loop
781: begin
782: select count(*) into l_count
783: from pay_balance_feeds_f
784: where balance_type_id = c2_rec.balance_type_id
785: and input_value_id = c1_rec.input_value_id
786: and business_group_id = p_business_group_id
787: and effective_start_date = p_effective_start_date

Line 791: pay_balance_feeds_f_pkg.insert_row

787: and effective_start_date = p_effective_start_date
788: and effective_end_date = p_effective_end_date
789: and nvl(legislation_code,'US') = c1_rec.legislation_code;
790: if l_count = 0 then
791: pay_balance_feeds_f_pkg.insert_row
792: (x_rowid => l_row_id,
793: x_balance_feed_id => l_balance_feed_id,
794: x_effective_start_date => p_effective_start_date,
795: x_effective_end_date => hr_api.g_eot,