APPS.PAY_US_USER_INIT_DEDN dependencies on PAY_BALANCE_FEEDS_F

Line 506: l_balance_feed_id pay_balance_feeds_f.balance_feed_id%type;

502: -- =============================================================================
503: procedure create_eligible_comp_bal_feeds is
504:
505: l_row_id rowid;
506: l_balance_feed_id pay_balance_feeds_f.balance_feed_id%type;
507: l_proc varchar2(160);
508: --
509: -- added hint no_merge(pbf) for bug 5187416
510: cursor c1_get_reg_earn_feeds is

Line 535: , PAY_BALANCE_FEEDS_F BF

531: ,bf.input_value_id
532: ,bf.scale
533: ,et.element_type_id
534: from pay_balance_classifications bc
535: , PAY_BALANCE_FEEDS_F BF
536: , PAY_BALANCE_TYPES BT
537: , PAY_INPUT_VALUES_F IV
538: , PAY_ELEMENT_TYPES_F ET
539: , PAY_ELEMENT_CLASSIFICATIONS EC

Line 577: pay_balance_feeds_f_pkg.insert_row

573: l_proc := g_proc||'.create_eligible_comp_bal_feeds';
574: hr_utility.set_location('Entering: '||l_proc, 5);
575: for c1_rec in c1_get_reg_earn_feeds loop
576: for c2_rec in c2_balance_type loop
577: pay_balance_feeds_f_pkg.insert_row
578: (x_rowid => l_row_id,
579: x_balance_feed_id => l_balance_feed_id,
580: x_effective_start_date => p_ele_eff_start_date,
581: x_effective_end_date => hr_api.g_eot,