APPS.PAY_FI_EXPIRY_SUPPORT dependencies on DUAL

Line 83: FROM dual;

79: l_date date;
80: BEGIN
81: SELECT TO_DATE(decode(sign(to_number(to_char(p_effective_date,'MM'))-3),1,TO_DATE('01/04/'||(to_char(p_effective_date,'YYYY') + 1) , 'DD/MM/YYYY') ,TO_DATE('01/04/'||(to_char(p_effective_date,'YYYY')) , 'DD/MM/YYYY') ) )
82: INTO l_date
83: FROM dual;
84:
85: RETURN l_date;
86: END hyear_ec;
87: --