DBA Data[Home] [Help]

APPS.JE_ES_MODELO_EXT_PKG dependencies on DUAL

Line 217: FROM DUAL;

213: author:Brathod
214: As no such currency conversion found in R11i code
215: SELECT DECODE( G_CURRENCY_CODE, 'EUR', (arr_rec.trx_line_amt*100), arr_rec.trx_line_amt)
216: INTO arr_rec.trx_line_amt
217: FROM DUAL;
218: */
219:
220: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'inserting with tipo 3: p_cust_tax_reg_num=' ||p_cust_tax_reg_num); END IF;
221:

Line 1764: -- FROM DUAL ;

1760: ln_formerly_decl_amt := 0;
1761: G_LINENO := '1.6.2.7.2.3';
1762: -- SELECT DECODE(lc_triangulation,'X','T','E') --Bug 5525421: No traingulation for AP.
1763: -- INTO lc_clave_operation
1764: -- FROM DUAL ;
1765: G_LINENO := '1.6.2.7.2.4';
1766: IF lc_clave_operation IN ('1','2') THEN
1767: lc_sign := ' ';
1768: ELSE

Line 2394: FROM DUAL ;

2390: ln_running_total := ln_ncorrection_amount;
2391: G_LINENO := '2.4.10.2.1';
2392: SELECT DECODE(lc_triangulation,'X','T','E')
2393: INTO lc_clave_operation
2394: FROM DUAL ;
2395: G_LINENO := '2.4.10.2.2';
2396:
2397: ELSIF lc_correction_year IS NOT NULL AND lc_correction_period IS NOT NULL THEN --IS a Correction
2398: G_LINENO := '2.4.10.2.3';

Line 2405: FROM DUAL ;

2401: ln_base_imponiable := ln_correction_amount;
2402: G_LINENO := '2.4.10.2.4';
2403: SELECT DECODE(lc_triangulation,'X','t','e') -- Bug 5525421
2404: INTO lc_clave_operation
2405: FROM DUAL ;
2406: G_LINENO := '2.4.10.2.5';
2407: IF lc_clave_operation IN ('1','2') THEN
2408: lc_sign := ' ';
2409: ELSE