APPS.HR_TMPLT dependencies on PAY_BALANCE_CATEGORIES_F
Line 197: l_return pay_balance_categories_f.category_name%TYPE;
193: FUNCTION get_balance_category(
194: p_category_id IN NUMBER
195: )
196: RETURN VARCHAR2 IS 197: l_return pay_balance_categories_f.category_name%TYPE; 198:
199: CURSOR cur_balance_category
200: IS SELECT
201: bcf.category_name
Line 203: pay_balance_categories_f bcf
199: CURSOR cur_balance_category
200: IS SELECT
201: bcf.category_name
202: FROM 203: pay_balance_categories_f bcf 204: WHERE
205: bcf.balance_category_id = p_category_id AND
206: SYSDATE BETWEEN bcf.effective_start_date AND
207: bcf.effective_end_date;