DBA Data[Home] [Help]

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 2186: from pay_balance_categories_f

2182: -- legislative specific entry, then look for global entry
2183: --
2184: cursor c_get_leg_bal_cat_id(p_leg_code varchar2) is
2185: select balance_category_id
2186: from pay_balance_categories_f
2187: where category_name = 'PTO Accruals'
2188: and legislation_code = p_leg_code;
2189:
2190: cursor c_get_gbl_bal_cat_id is

Line 2192: from pay_balance_categories_f

2188: and legislation_code = p_leg_code;
2189:
2190: cursor c_get_gbl_bal_cat_id is
2191: select balance_category_id
2192: from pay_balance_categories_f
2193: where category_name = 'PTO Accruals'
2194: and legislation_code is null;
2195:
2196: l_proc varchar2(72);