DBA Data[Home] [Help]

APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_BPD_AR_INV_LINES_V

Line 7557: FROM okl_bpd_ar_inv_lines_v

7553: WHERE contract_id = p_chr_id;*/
7554:
7555: CURSOR outstanding_amount_csr (p_chr_id IN NUMBER) IS
7556: SELECT NVL(SUM(amount_due_remaining), 0)
7557: FROM okl_bpd_ar_inv_lines_v
7558: WHERE contract_id = p_chr_id;
7559:
7560:
7561: l_outstanding_amount NUMBER := 0;

Line 11466: FROM okl_bpd_ar_inv_lines_v ARL,

11462: OKL R12B billing changes
11463: */
11464: CURSOR c_principal_payments_tot(p_credit_id number) IS
11465: SELECT NVL(SUM(ARL.AMOUNT),0)
11466: FROM okl_bpd_ar_inv_lines_v ARL,
11467: (
11468: select gov.dnz_chr_id chr_id,
11469: crd.ID credit_id
11470: from OKC_K_HEADERS_B crd,