DBA Data[Home] [Help]

APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_BPD_AR_INV_LINES_V

Line 6959: FROM okl_bpd_ar_inv_lines_v

6955: WHERE contract_id = p_chr_id;*/
6956:
6957: CURSOR outstanding_amount_csr (p_chr_id IN NUMBER) IS
6958: SELECT NVL(SUM(amount_due_remaining), 0)
6959: FROM okl_bpd_ar_inv_lines_v
6960: WHERE contract_id = p_chr_id;
6961:
6962:
6963: l_outstanding_amount NUMBER := 0;

Line 10527: FROM okl_bpd_ar_inv_lines_v ARL,

10523: OKL R12B billing changes
10524: */
10525: CURSOR c_principal_payments_tot(p_credit_id number) IS
10526: SELECT NVL(SUM(ARL.AMOUNT),0)
10527: FROM okl_bpd_ar_inv_lines_v ARL,
10528: (
10529: select gov.dnz_chr_id chr_id,
10530: crd.ID credit_id
10531: from OKC_K_HEADERS_B crd,