DBA Data[Home] [Help]

APPS.ECE_AR_TRANSACTION dependencies on ECE_EXTERNAL_LEVELS

Line 1491: ece_external_levels eel

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
1494: AND eit.interface_table_id = elm.interface_table_id
1495: AND elm.external_level_id = eel.external_level_id

Line 1520: ece_external_levels eel

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
1523: AND eit.interface_table_id = elm.interface_table_id
1524: AND elm.external_level_id = eel.external_level_id

Line 3415: ece_external_levels eel

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
3418: AND eit.interface_table_id = elm.interface_table_id
3419: AND elm.external_level_id = eel.external_level_id