APPS.OZF_PRE_PROCESS_PVT dependencies on ECX_TP_HEADERS_V

Line 678: FROM ecx_tp_headers_v

674: IS
675: SELECT party_id
676: , party_site_id
677: , company_admin_email
678: FROM ecx_tp_headers_v
679: WHERE party_site_id = pc_party_site
680: UNION
681: SELECT party_id
682: , party_site_id

Line 684: FROM ecx_tp_headers_v hdr

680: UNION
681: SELECT party_id
682: , party_site_id
683: , company_admin_email
684: FROM ecx_tp_headers_v hdr
685: , ecx_tp_details_v dtl
686: WHERE hdr.tp_header_id = dtl.tp_header_id
687: AND source_tp_location_code = to_char(pc_party_site);
688:

Line 7552: l_party_id ecx_tp_headers_v.party_id%TYPE;

7548: l_api_version_number CONSTANT NUMBER := 1.0;
7549:
7550: l_trans_type ecx_tp_details_v.transaction_type%TYPE;
7551: l_trans_subtype ecx_tp_details_v.transaction_subtype%TYPE;
7552: l_party_id ecx_tp_headers_v.party_id%TYPE;
7553: l_party_site_id ecx_tp_headers_v.party_site_id%TYPE;
7554: l_resale_batch_id NUMBER;
7555:
7556: l_enabled NUMBER;

Line 7553: l_party_site_id ecx_tp_headers_v.party_site_id%TYPE;

7549:
7550: l_trans_type ecx_tp_details_v.transaction_type%TYPE;
7551: l_trans_subtype ecx_tp_details_v.transaction_subtype%TYPE;
7552: l_party_id ecx_tp_headers_v.party_id%TYPE;
7553: l_party_site_id ecx_tp_headers_v.party_site_id%TYPE;
7554: l_resale_batch_id NUMBER;
7555:
7556: l_enabled NUMBER;
7557: l_admin_email VARCHAR2(1000);

Line 7568: FROM ecx_tp_headers_v eth

7564: , pc_transaction_type VARCHAR2
7565: , pc_txn_sub_type VARCHAR2 )
7566: IS
7567: SELECT etd.confirmation, eth.company_admin_email
7568: FROM ecx_tp_headers_v eth
7569: , ecx_tp_details_v etd
7570: WHERE eth.tp_header_id = etd.tp_header_id
7571: AND eth.party_id = pc_party_id
7572: AND eth.party_site_id = pc_site_id