APPS.ECX_TP_API dependencies on ECX_MAPPINGS

Line 514: ecx_mappings em

510: x_last_updated_by ,
511: x_creation_date,
512: x_last_update_date
513: from ecx_tp_details etd,
514: ecx_mappings em
515: where etd.tp_header_id = p_tp_header_id
516: and etd.ext_process_id = p_ext_process_id
517: and em.map_id = etd.map_id
518: and (p_source_tp_location_code is null

Line 715: ecx_mappings em

711: x_creation_date,
712: x_last_update_date
713: from ecx_tp_details etd,
714: ecx_tp_headers eth,
715: ecx_mappings em
716: where eth.party_id = p_party_id
717: and eth.party_site_id = p_party_site_id
718: and eth.party_type = p_party_type
719: and etd.ext_process_id = x_ext_process_id

Line 794: select map_id from ecx_mappings

790: select 1,direction from ecx_ext_processes
791: where ext_process_id = p_ext_process_id;
792:
793: Cursor c3 Is
794: select map_id from ecx_mappings
795: where map_code = p_map_code;
796:
797: Cursor c4 Is
798: select 1 from ecx_hub_users

Line 1458: select map_id from ecx_mappings

1454: from ecx_hub_users
1455: where hub_user_id = p_hub_user_id;
1456:
1457: cursor c1 is
1458: select map_id from ecx_mappings
1459: where map_code = p_map_code;
1460:
1461: cursor c2 is
1462: select direction from ecx_ext_processes