DBA Data[Home] [Help]

APPS.AR_BFB_UTILS_PVT dependencies on DUAL

Line 20: select to_char(the_date, 'MM' ) - 3 into m from dual;

16: l_dow NUMBER;
17:
18: begin
19:
20: select to_char(the_date, 'MM' ) - 3 into m from dual;
21: select to_char(the_date, 'YYYY' ) into y from dual;
22: select to_char(the_date, 'DD' ) into d from dual;
23:
24: if ( m < 0 ) then

Line 21: select to_char(the_date, 'YYYY' ) into y from dual;

17:
18: begin
19:
20: select to_char(the_date, 'MM' ) - 3 into m from dual;
21: select to_char(the_date, 'YYYY' ) into y from dual;
22: select to_char(the_date, 'DD' ) into d from dual;
23:
24: if ( m < 0 ) then
25: m := m + 12;

Line 22: select to_char(the_date, 'DD' ) into d from dual;

18: begin
19:
20: select to_char(the_date, 'MM' ) - 3 into m from dual;
21: select to_char(the_date, 'YYYY' ) into y from dual;
22: select to_char(the_date, 'DD' ) into d from dual;
23:
24: if ( m < 0 ) then
25: m := m + 12;
26: y := y - 1;