APPS.OZF_PRE_PROCESS_PVT dependencies on ECX_TP_HEADERS_V

Line 692: FROM ecx_tp_headers_v

688: IS
689: SELECT party_id
690: , party_site_id
691: , company_admin_email
692: FROM ecx_tp_headers_v
693: WHERE party_site_id = pc_party_site
694: UNION
695: SELECT party_id
696: , party_site_id

Line 698: FROM ecx_tp_headers_v hdr

694: UNION
695: SELECT party_id
696: , party_site_id
697: , company_admin_email
698: FROM ecx_tp_headers_v hdr
699: , ecx_tp_details_v dtl
700: WHERE hdr.tp_header_id = dtl.tp_header_id
701: AND source_tp_location_code = to_char(pc_party_site);
702:

Line 8019: l_party_id ecx_tp_headers_v.party_id%TYPE;

8015: l_api_version_number CONSTANT NUMBER := 1.0;
8016:
8017: l_trans_type ecx_tp_details_v.transaction_type%TYPE;
8018: l_trans_subtype ecx_tp_details_v.transaction_subtype%TYPE;
8019: l_party_id ecx_tp_headers_v.party_id%TYPE;
8020: l_party_site_id ecx_tp_headers_v.party_site_id%TYPE;
8021: l_resale_batch_id NUMBER;
8022:
8023: l_enabled NUMBER;

Line 8020: l_party_site_id ecx_tp_headers_v.party_site_id%TYPE;

8016:
8017: l_trans_type ecx_tp_details_v.transaction_type%TYPE;
8018: l_trans_subtype ecx_tp_details_v.transaction_subtype%TYPE;
8019: l_party_id ecx_tp_headers_v.party_id%TYPE;
8020: l_party_site_id ecx_tp_headers_v.party_site_id%TYPE;
8021: l_resale_batch_id NUMBER;
8022:
8023: l_enabled NUMBER;
8024: l_admin_email VARCHAR2(1000);

Line 8035: FROM ecx_tp_headers_v eth

8031: , pc_transaction_type VARCHAR2
8032: , pc_txn_sub_type VARCHAR2 )
8033: IS
8034: SELECT etd.confirmation, eth.company_admin_email
8035: FROM ecx_tp_headers_v eth
8036: , ecx_tp_details_v etd
8037: WHERE eth.tp_header_id = etd.tp_header_id
8038: AND eth.party_id = pc_party_id
8039: AND eth.party_site_id = pc_site_id