DBA Data[Home] [Help]

APPS.ECE_AR_TRANSACTION dependencies on ECE_LEVEL_MATRICES

Line 1490: ece_level_matrices elm,

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

Line 1519: ece_level_matrices elm,

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

Line 3414: ece_level_matrices elm,

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