APPS.DPP_EXECUTIONPROCESS_PVT dependencies on OZF_SUPP_TRD_PRFLS_ALL

Line 677: FROM OZF_SUPP_TRD_PRFLS_ALL

673: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| L_API_NAME;
674: BEGIN
675: SELECT SUPP_TRADE_PROFILE_ID
676: INTO L_RET_ID
677: FROM OZF_SUPP_TRD_PRFLS_ALL
678: WHERE SUPPLIER_ID = P_VENDOR_ID
679: AND SUPPLIER_SITE_ID = P_VENDOR_SITE_ID
680: AND ORG_ID = P_ORG_ID;
681:

Line 1280: FROM dpp_transaction_headers_all dtha, ozf_supp_trd_prfls_all ostpa

1276: transaction_number,
1277: ref_document_number,
1278: skip_adjustment_flag,
1279: skip_approval_flag
1280: FROM dpp_transaction_headers_all dtha, ozf_supp_trd_prfls_all ostpa
1281: WHERE dtha.vendor_id = ostpa.supplier_id
1282: AND dtha.vendor_site_id = ostpa.supplier_site_id
1283: AND dtha.org_id = ostpa.org_id
1284: AND dtha.transaction_status = 'ACTIVE'