DBA Data[Home] [Help]

APPS.ECE_AR_TRANSACTION dependencies on ECE_INTERFACE_TABLES

Line 1489: FROM ece_interface_tables eit,

1485: xProgress := '2000-60';
1486: BEGIN
1487: SELECT MIN(eel.external_level)
1488: INTO cAlw_chg_h_output_level
1489: FROM ece_interface_tables eit,
1490: ece_level_matrices elm,
1491: ece_external_levels eel
1492: WHERE eit.interface_table_name = 'ECE_AR_TRX_ALLOWANCE_CHARGES'
1493: AND eit.transaction_type = cTransaction_type

Line 1509: 'ECE_INTERFACE_TABLES' );

1505: xProgress,
1506: 'INFO',
1507: 'MINIMUM OUTPUT LEVEL',
1508: 'TABLE_NAME',
1509: 'ECE_INTERFACE_TABLES' );
1510: END;
1511:
1512: ec_debug.pl ( 3, 'cAlw_chg_h_output_level: ',cAlw_chg_h_output_level );
1513:

Line 1518: FROM ece_interface_tables eit,

1514: xProgress := '2010-60';
1515: BEGIN
1516: SELECT MAX(eel.external_level)
1517: INTO cAlw_chg_l_output_level
1518: FROM ece_interface_tables eit,
1519: ece_level_matrices elm,
1520: ece_external_levels eel
1521: WHERE eit.interface_table_name = 'ECE_AR_TRX_ALLOWANCE_CHARGES'
1522: AND eit.transaction_type = cTransaction_type

Line 1538: 'ECE_INTERFACE_TABLES' );

1534: xProgress,
1535: 'INFO',
1536: 'MAXIMUM OUTPUT LEVEL',
1537: 'TABLE_NAME',
1538: 'ECE_INTERFACE_TABLES' );
1539: END;
1540:
1541: ec_debug.pl ( 3, 'cAlw_chg_l_output_level: ',cAlw_chg_l_output_level );
1542:

Line 3413: FROM ece_interface_tables eit,

3409: xProgress := '2060-70';
3410: BEGIN
3411: SELECT MIN(eel.external_level)
3412: INTO l_alw_chg_output_level
3413: FROM ece_interface_tables eit,
3414: ece_level_matrices elm,
3415: ece_external_levels eel
3416: WHERE eit.interface_table_name = 'ECE_AR_TRX_ALLOWANCE_CHARGES'
3417: AND eit.transaction_type = cTransaction_type

Line 3433: 'ECE_INTERFACE_TABLES' );

3429: xProgress,
3430: 'INFO',
3431: 'MINIMUM OUTPUT LEVEL',
3432: 'TABLE_NAME',
3433: 'ECE_INTERFACE_TABLES' );
3434: END;
3435: ec_debug.pl ( 3, 'l_alw_chg_output_level: ',l_alw_chg_output_level );
3436:
3437: