3149: , p_accrual_plan_id NUMBER
3150: , p_effective_date VARCHAR2 )
3151: RETURN NUMBER IS
3152:
3153: l_pto_ok pay_accrual_plans.accrual_plan_id%TYPE := -1;
3154:
3155: CURSOR csr_chk_pto_ok IS
3156: SELECT pap.accrual_plan_id
3157: FROM
3154:
3155: CURSOR csr_chk_pto_ok IS
3156: SELECT pap.accrual_plan_id
3157: FROM
3158: pay_accrual_plans pap
3159: ,pay_element_types_f pet
3160: ,pay_element_links_f pel
3161: ,pay_element_entries_f pee
3162: WHERE