APPS.PAY_PAYMENT_XML_PKG dependencies on DUAL

Line 105: from dual;

101: utl_raw.cast_to_varchar2(hextoraw('C38B')),'E'),
102: utl_raw.cast_to_varchar2(hextoraw('C382')),'A'),
103: utl_raw.cast_to_varchar2(hextoraw('C592')),'OE'),
104: utl_raw.cast_to_varchar2(hextoraw('C386')),'AE')
105: from dual;
106:
107: begin
108: open c_uppercase(p_input_string);
109: fetch c_uppercase into l_output_string;

Line 779: from dual;

775: if (is_decimal<>0)
776: then
777: select length(substr(l_deposit_amount, is_decimal+1, length(l_deposit_amount)))
778: into curr_no_of_decimals
779: from dual;
780:
781: while(curr_no_of_decimals <> currency_precision) loop
782: select rpad(l_deposit_amount, length(l_deposit_amount)+ 1, '0')
783: into l_deposit_amount

Line 784: from dual;

780:
781: while(curr_no_of_decimals <> currency_precision) loop
782: select rpad(l_deposit_amount, length(l_deposit_amount)+ 1, '0')
783: into l_deposit_amount
784: from dual;
785: curr_no_of_decimals := curr_no_of_decimals+1;
786: end loop;
787: end if;
788: --