APPS.ECE_AR_TRANSACTION dependencies on ECE_MAPPINGS

Line 1497: FROM ece_mappings em1

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
1496: AND eel.map_id = (SELECT NVL(cMap_id, MAX(em1.map_id))
1497: FROM ece_mappings em1
1498: WHERE em1.map_code like 'EC_'||RTRIM(LTRIM(NVL(cTransaction_type,'%')))||'_FF');
1499: EXCEPTION
1500: WHEN NO_DATA_FOUND THEN
1501: ec_debug.pl ( 1,

Line 1526: FROM ece_mappings em1

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
1525: AND eel.map_id = (SELECT NVL(cMap_id, MAX(em1.map_id))
1526: FROM ece_mappings em1
1527: WHERE em1.map_code like 'EC_'||RTRIM(LTRIM(NVL(cTransaction_type,'%')))||'_FF');
1528: EXCEPTION
1529: WHEN NO_DATA_FOUND THEN
1530: ec_debug.pl ( 1,

Line 3421: FROM ece_mappings em1

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
3420: AND eel.map_id = (SELECT NVL(cMap_id, MAX(em1.map_id))
3421: FROM ece_mappings em1
3422: WHERE em1.map_code like 'EC_'||RTRIM(LTRIM(NVL(cTransaction_type,'%')))||'_FF');
3423: EXCEPTION
3424: WHEN NO_DATA_FOUND THEN
3425: ec_debug.pl ( 1,