DBA Data[Home] [Help]

APPS.ZX_TRN_VALIDATION_PKG dependencies on DUAL

Line 3621: N_Check_Flag from dual;

3617: IF numeric_result = '0'
3618: then
3619: /* its numeric so continue */
3620: select instr(N_Check_Digit,check_digit) into
3621: N_Check_Flag from dual;
3622: If N_Check_Flag > 0
3623: then
3624: pass_check;
3625: else

Line 3650: FROM DUAL;

3646: then
3647: SELECT Decode(SubStr(trn_value,1,1),'Y',1,2)
3648: ||SubStr(trn_value,2,length(trn_value)-2)
3649: INTO work_trn
3650: FROM DUAL;
3651: ELSE
3652: work_trn := substr(trn_value,2,length(trn_value)-2);
3653: END IF;
3654: IF substr('TRWAGMYFPDXBNJZSQVHLCKE',mod