DBA Data[Home] [Help]

APPS.JE_ES_MODELO_EXT_PKG dependencies on DUAL

Line 727: FROM DUAL;

723: author:Brathod
724: As no such currency conversion found in R11i code
725: SELECT DECODE( G_CURRENCY_CODE, 'EUR', (arrenda_rec.trx_line_amt*100), arrenda_rec.trx_line_amt)
726: INTO arrenda_rec.trx_line_amt
727: FROM DUAL;
728: */
729:
730: 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;
731:

Line 1606: FROM dual;

1602: SELECT to_date ('01'||l_from||p_tax_year, 'DDMMYYYY'),
1603: last_day(to_date ('01'||l_to||p_tax_year, 'DDMMYYYY'))
1604: INTO p_340_start_date,
1605: p_340_end_date
1606: FROM dual;
1607:
1608: END set_dates;
1609:
1610: FUNCTION before_Report

Line 3191: -- FROM DUAL ;

3187:
3188:
3189: -- SELECT DECODE(lc_triangulation,'X','T','E') --Bug 5525421: No traingulation for AP.
3190: -- INTO lc_clave_operation
3191: -- FROM DUAL ;
3192: G_LINENO := '1.6.2.7.2.4';
3193: IF lc_clave_operation IN ('1','2') THEN
3194: lc_sign := ' ';
3195: ELSE

Line 4160: FROM DUAL ;

4156: G_LINENO := '2.4.10.2.1';
4157: /* BUG 9765740
4158: SELECT DECODE(lc_triangulation,'X','T','E')
4159: INTO lc_clave_operation
4160: FROM DUAL ;
4161: */
4162: lc_clave_operation := lc_triangulation;
4163:
4164: G_LINENO := '2.4.10.2.2';

Line 4201: FROM DUAL ;

4197: /* -- BUG 9765740
4198:
4199: SELECT DECODE(lc_triangulation,'X','t','e') -- Bug 5525421
4200: INTO lc_clave_operation
4201: FROM DUAL ;
4202: */
4203: lc_clave_operation := lower(lc_triangulation);
4204:
4205: G_LINENO := '2.4.10.2.5';