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