DBA Data[Home] [Help]

APPS.PAY_SE_TAX_DECL_REPORT dependencies on DUAL

Line 62: SELECT mod(l_amount,10) INTO l_digit(l_count) from dual;

58: END loop;
59:
60: WHILE l_amount >= 10 LOOP
61:
62: SELECT mod(l_amount,10) INTO l_digit(l_count) from dual;
63: l_amount:=floor(l_amount/10);
64: l_count:=l_count+1;
65: END LOOP;
66:

Line 67: SELECT floor(l_amount) INTO l_digit(l_count) from dual;

63: l_amount:=floor(l_amount/10);
64: l_count:=l_count+1;
65: END LOOP;
66:
67: SELECT floor(l_amount) INTO l_digit(l_count) from dual;
68: p_digit1:=l_digit(1);
69: p_digit2:=l_digit(2);
70: p_digit3:=l_digit(3);
71: p_digit4:=l_digit(4);

Line 1873: 'DECEMBER','12') FROM dual;

1869: 'AUGUST','08',
1870: 'SEPTEMBER','09',
1871: 'OCTOBER','10',
1872: 'NOVEMBER','11',
1873: 'DECEMBER','12') FROM dual;
1874:
1875:
1876: l_month varchar2(5);
1877: l_full_month varchar2(25);