[Home] [Help]
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
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);
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
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);