APPS.HR_ACCRUAL_PLAN_API dependencies on PAY_BALANCE_CATEGORIES_F

Line 784: from pay_balance_categories_f

780: -- legislative specific entry, then look for global entry
781: --
782: cursor c_get_leg_bal_cat_id(p_leg_code varchar2) is
783: select balance_category_id
784: from pay_balance_categories_f
785: where category_name = 'PTO Accruals'
786: and legislation_code = p_leg_code;
787:
788: cursor c_get_gbl_bal_cat_id is

Line 790: from pay_balance_categories_f

786: and legislation_code = p_leg_code;
787:
788: cursor c_get_gbl_bal_cat_id is
789: select balance_category_id
790: from pay_balance_categories_f
791: where category_name = 'PTO Accruals'
792: and legislation_code is null;
793:
794: l_proc varchar2(72);

Line 2178: from pay_balance_categories_f

2174: -- legislative specific entry, then look for global entry
2175: --
2176: cursor c_get_leg_bal_cat_id(p_leg_code varchar2) is
2177: select balance_category_id
2178: from pay_balance_categories_f
2179: where category_name = 'PTO Accruals'
2180: and legislation_code = p_leg_code;
2181:
2182: cursor c_get_gbl_bal_cat_id is

Line 2184: from pay_balance_categories_f

2180: and legislation_code = p_leg_code;
2181:
2182: cursor c_get_gbl_bal_cat_id is
2183: select balance_category_id
2184: from pay_balance_categories_f
2185: where category_name = 'PTO Accruals'
2186: and legislation_code is null;
2187:
2188: l_proc varchar2(72);