DBA Data[Home] [Help]

APPS.PAY_ES_CALC_SS_EARNINGS dependencies on DUAL

Line 141: FROM dual;

137: --
138: SELECT (to_date('01-01-'||to_char(p_date_earned,'yyyy'),'dd-mm-yyyy')
139: -to_date('01-01-'||to_char(to_number(to_char(p_date_earned,'yyyy'))-1),'dd-mm-yyyy'))
140: INTO l_Days
141: FROM dual;
142: --
143: RETURN l_Days;
144: --
145: END get_days_prev_year;