APPS.PAY_US_GARN_UPGRADE dependencies on PAY_BALANCE_FEEDS_F

Line 725: from pay_balance_feeds_f

721: legislation_code,
722: input_value_id,
723: scale,
724: legislation_subgroup
725: from pay_balance_feeds_f
726: where business_group_id = cp_business_grp_id
727: and balance_type_id = cp_balance_type_id;
728:
729:

Line 735: from pay_balance_feeds_f

731: cursor c_chk_inp_val(cp_balance_type_id number,
732: cp_input_val_id number,
733: cp_business_grp_id number) IS
734: select 'Exists'
735: from pay_balance_feeds_f
736: where balance_type_id = cp_balance_type_id
737: and input_value_id = cp_input_val_id
738: and business_group_id = cp_business_grp_id;
739:

Line 833: pay_balance_feeds_f_pkg.Insert_Row(

829: hr_utility.trace('Creating Balance Feed for ' || l_old_bal_type_id_tab(l_count));
830: l_rowid := NULL;
831: l_balance_feed_id := NULL;
832:
833: pay_balance_feeds_f_pkg.Insert_Row(
834: X_Rowid => l_rowid,
835: X_Balance_Feed_Id => l_balance_feed_id,
836: X_Effective_Start_Date => l_eff_start_date,
837: X_Effective_End_Date => l_eff_end_date,

Line 890: from pay_balance_feeds_f

886: * This delete statement deletes the balance feeds for the balances
887: * associated with the element passed.
888: */
889: delete
890: from pay_balance_feeds_f
891: where balance_type_id in (select balance_type_id
892: from pay_balance_types
893: where balance_name in
894: (p_new_ele_name,