APPS.ZX_TRN_VALIDATION_PKG dependencies on DUAL

Line 4153: FROM DUAL;

4149: then
4150: /* its numeric so continue */
4151: SELECT instr(N_Check_Digit,check_digit)
4152: INTO N_Check_Flag
4153: FROM DUAL;
4154: If N_Check_Flag > 0
4155: then pass_check;
4156: else fail_check;
4157: end if;

Line 4180: FROM DUAL;

4176: then
4177: SELECT Decode(SubStr(trn_value,1,1),'Y',1,2)
4178: ||SubStr(trn_value,2,length(trn_value)-2)
4179: INTO work_trn
4180: FROM DUAL;
4181: ELSE
4182: work_trn := substr(trn_value,2,length(trn_value)-2);
4183: END IF;
4184: IF substr('TRWAGMYFPDXBNJZSQVHLCKE',mod

Line 4716: FROM DUAL

4712: 'INVALID') FINAL_RESULT
4713: INTO l_result
4714: FROM (SELECT
4715: REGEXP_SUBSTR(REPLACE(REGEXP_SUBSTR(p_trn_value,'^(CHE-[0-9]{3}.[0-9]{3}.[0-9]{3}) (MWST|TVA|IVA)$'),'.',''),'[0-9]+') NUM
4716: FROM DUAL
4717: );
4718:
4719: IF (l_result = 'VALID') THEN
4720: