DBA Data[Home] [Help]

APPS.HXC_TIME_ENTRY_RULES_UTILS_PKG dependencies on PAY_ACCRUAL_PLANS

Line 3098: l_pto_ok pay_accrual_plans.accrual_plan_id%TYPE := -1;

3094: , p_accrual_plan_id NUMBER
3095: , p_effective_date VARCHAR2 )
3096: RETURN NUMBER IS
3097:
3098: l_pto_ok pay_accrual_plans.accrual_plan_id%TYPE := -1;
3099:
3100: CURSOR csr_chk_pto_ok IS
3101: SELECT pap.accrual_plan_id
3102: FROM

Line 3103: pay_accrual_plans pap

3099:
3100: CURSOR csr_chk_pto_ok IS
3101: SELECT pap.accrual_plan_id
3102: FROM
3103: pay_accrual_plans pap
3104: ,pay_element_types_f pet
3105: ,pay_element_links_f pel
3106: ,pay_element_entries_f pee
3107: WHERE