DBA Data[Home] [Help]

APPS.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on HZ_PARTIES

Line 23: P_CUSTOMER_NUMBER HZ_PARTIES.PARTY_NUMBER%TYPE;

19:
20: P_BOOK_CLASS OKL_K_HEADERS.DEAL_TYPE%TYPE;
21: P_LEASE_PRODUCT OKL_PRODUCTS.NAME%TYPE;
22: P_CONTRACT_STATUS OKC_K_HEADERS_ALL_B.sts_code%TYPE; -- check
23: P_CUSTOMER_NUMBER HZ_PARTIES.PARTY_NUMBER%TYPE;
24: P_CUSTOMER_NAME HZ_PARTIES.party_name%TYPE;
25: P_SIC_CODE HZ_PARTIES.SIC_CODE%TYPE;
26: P_VENDOR_NUMBER po_vendors.segment1%TYPE;
27: P_VENDOR_NAME po_vendors.vendor_name%TYPE;

Line 24: P_CUSTOMER_NAME HZ_PARTIES.party_name%TYPE;

20: P_BOOK_CLASS OKL_K_HEADERS.DEAL_TYPE%TYPE;
21: P_LEASE_PRODUCT OKL_PRODUCTS.NAME%TYPE;
22: P_CONTRACT_STATUS OKC_K_HEADERS_ALL_B.sts_code%TYPE; -- check
23: P_CUSTOMER_NUMBER HZ_PARTIES.PARTY_NUMBER%TYPE;
24: P_CUSTOMER_NAME HZ_PARTIES.party_name%TYPE;
25: P_SIC_CODE HZ_PARTIES.SIC_CODE%TYPE;
26: P_VENDOR_NUMBER po_vendors.segment1%TYPE;
27: P_VENDOR_NAME po_vendors.vendor_name%TYPE;
28: P_SALES_CHANNEL_CODE HZ_CUST_ACCOUNTS.SALES_CHANNEL_CODE%TYPE;

Line 25: P_SIC_CODE HZ_PARTIES.SIC_CODE%TYPE;

21: P_LEASE_PRODUCT OKL_PRODUCTS.NAME%TYPE;
22: P_CONTRACT_STATUS OKC_K_HEADERS_ALL_B.sts_code%TYPE; -- check
23: P_CUSTOMER_NUMBER HZ_PARTIES.PARTY_NUMBER%TYPE;
24: P_CUSTOMER_NAME HZ_PARTIES.party_name%TYPE;
25: P_SIC_CODE HZ_PARTIES.SIC_CODE%TYPE;
26: P_VENDOR_NUMBER po_vendors.segment1%TYPE;
27: P_VENDOR_NAME po_vendors.vendor_name%TYPE;
28: P_SALES_CHANNEL_CODE HZ_CUST_ACCOUNTS.SALES_CHANNEL_CODE%TYPE;
29: P_GEN_ACCRUAL varchar2(240);