DBA Data[Home] [Help]

APPS.IGF_AP_LI_ISIR_IMP_PROC dependencies on DUAL

Line 566: FROM dual;

562: SELECT DECODE( lv_signed_char, '{','0','A','1', 'B','2', 'C','3', 'D','4', 'E','5', 'F','6',
563: 'G','7', 'H','8', 'I','9', 'J','1', 'K','2',
564: 'L','3', 'M','4', 'N','5', 'O','6', 'P','7', 'Q','8', 'R','9', '}','0' )
565: INTO lv_signed_value
566: FROM dual;
567:
568: -- Get the amount by concatanating number and signed value
569: ln_Amount := TO_NUMBER( lv_number||lv_signed_value);
570:

Line 5849: FROM dual;

5845: BEGIN
5846:
5847: SELECT TRANSLATE (pv_ssn,'1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ`~!@#$%^&*_+=-,./?><():; ','1234567890')
5848: INTO ln_ssn
5849: FROM dual;
5850:
5851: RETURN ln_ssn;
5852:
5853: EXCEPTION