APPS.OZF_PRE_PROCESS_PVT dependencies on ECX_TP_DETAILS_V

Line 699: , ecx_tp_details_v dtl

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:
703: time NUMBER;

Line 8017: l_trans_type ecx_tp_details_v.transaction_type%TYPE;

8013: IS
8014: l_api_name CONSTANT VARCHAR2(30) := 'Confirm_BOD_Enabled';
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;

Line 8018: l_trans_subtype ecx_tp_details_v.transaction_subtype%TYPE;

8014: l_api_name CONSTANT VARCHAR2(30) := 'Confirm_BOD_Enabled';
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:

Line 8036: , ecx_tp_details_v etd

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
8040: AND etd.transaction_type = pc_transaction_type