APPS.ZX_RATES_PKG dependencies on DUAL

Line 1000: FROM DUAL) ,

996: (SELECT CASE WHEN LENGTHB(X_TAX_RATE_CODE) > 30
997: THEN SUBSTRB(X_TAX_RATE_CODE, 1, 24) ||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_TAXES_B_S')
998: ELSE X_TAX_RATE_CODE
999: END LOOKUP_CODE
1000: FROM DUAL) ,
1001: -- start bug#6992215
1002: Nvl(X_TAX_RATE_NAME, X_TAX_RATE_CODE),
1003: X_DESCRIPTION,
1004: -- end bug#6992215

Line 1011: FROM DUAL) ,

1007: THEN X_TAX_RATE_CODE
1008: ELSE
1009: NULL
1010: END TAG
1011: FROM DUAL) ,
1012: X_EFFECTIVE_FROM,
1013: X_EFFECTIVE_TO,
1014: 'US',
1015: '0',

Line 1161: dual

1157: fnd_global.conc_login_id , --program_login_id
1158: X_LEDGER_ID , --ledger_id
1159: X_Active_Flag -- Active_flag )
1160: FROM
1161: dual
1162: WHERE
1163: NOT EXISTS
1164: (SELECT NULL FROM ZX_ID_TCC_MAPPING_ALL
1165: WHERE TAX_CLASSIFICATION_CODE = X_TAX_RATE_CODE