APPS.ZX_PTP_IMPORT dependencies on DUAL

Line 1928: FROM DUAL

1924: l_dynamic_sql := l_const_sql||
1925: q'# AND 1= (CASE WHEN (REGEXP_LIKE(registration_number,'^(GB)[[:digit:]]{9}$') OR
1926: REGEXP_LIKE(registration_number,'^(GB)[[:digit:]]{12}$')) THEN
1927: (SELECT 1
1928: FROM DUAL
1929: CONNECT BY LEVEL<8
1930: HAVING (Mod(SUM(SUBSTR(registration_number,LEVEL+2,1)*(9-LEVEL)),97)-97 + SUBSTR(registration_number,-2,2) = 0) OR
1931: (Mod(SUM(SUBSTR(registration_number,LEVEL+2,1)*(9-LEVEL)),97)-97 + 55 + SUBSTR(registration_number,-2,2) = 0) OR
1932: (Mod(SUM(SUBSTR(registration_number,LEVEL+2,1)*(9-LEVEL)),97)-97 + 55 -97 + SUBSTR(registration_number,-2,2) = 0))

Line 2286: FROM DUAL

2282: (REGEXP_SUBSTR(num,'[0-9]',1,9)),'VALID',
2283: 'INVALID') FINAL_RESULT
2284: FROM (SELECT
2285: REGEXP_SUBSTR(REPLACE(REGEXP_SUBSTR(registration_number,'^(CHE-[0-9]{3}.[0-9]{3}.[0-9]{3}) (MWST|TVA|IVA)$'),'.',''),'[0-9]+') NUM
2286: FROM DUAL
2287: )
2288: WHERE REGEXP_SUBSTR(registration_number,'^(CHE-[0-9]{3}.[0-9]{3}.[0-9]{3}) (MWST|TVA|IVA)$')=registration_number
2289: )
2290: )

Line 7783: FROM DUAL

7779: ELSE
7780: BEGIN
7781: SELECT G_CONC_RET_STS_WARNING
7782: INTO x_return_status
7783: FROM DUAL
7784: WHERE EXISTS (SELECT /*+ FIRST_ROWS(1) */ 1
7785: FROM zx_errors_int
7786: WHERE request_id = G_REQUEST_ID
7787: AND ROWNUM=1);

Line 8247: FROM DUAL

8243:
8244: BEGIN
8245: SELECT 1
8246: INTO l_num1
8247: FROM DUAL
8248: WHERE EXISTS (SELECT /*+ FIRST_ROWS(1) */ 1
8249: FROM zx_errors_int
8250: WHERE request_id = G_REQUEST_ID
8251: AND ROWNUM=1);