DBA Data[Home] [Help]

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;