DBA Data[Home] [Help]

APPS.OKL_CASH_APPL_RULES dependencies on HZ_CUST_ACCOUNTS

Line 324: HZ_CUST_ACCOUNTS CA,

320: from
321: OKC_K_HEADERS_ALL_B CN,
322: OKL_CNSLD_AR_STRMS_B ST,
323: OKL_CNSLD_AR_HDRS_B HD,
324: HZ_CUST_ACCOUNTS CA,
325: OKL_CNSLD_AR_LINES_B LN,
326: AR_PAYMENT_SCHEDULES_ALL PS
327: WHERE PS.CLASS IN ('INV', 'CM')
328: AND ST.RECEIVABLES_INVOICE_ID = PS.CUSTOMER_TRX_ID AND LN.ID = ST.LLN_ID

Line 2208: l_customer_num HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE DEFAULT p_rcpt_rec.customer_number;

2204: ) IS
2205:
2206: l_currency_code okl_k_headers_full_v.currency_code%type;
2207: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT p_rcpt_rec.customer_id;
2208: l_customer_num HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE DEFAULT p_rcpt_rec.customer_number;
2209: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
2210: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT p_rcpt_rec.exchange_rate_type;
2211: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT p_rcpt_rec.exchange_date;
2212: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT p_rcpt_rec.exchange_rate;