APPS.OKL_PAY_INVOICES_CONS_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 711: l_contract_group okc_k_headers_all_b.contract_number%TYPE := p_contract_number; -- defualt to contract_number as a group criteria

707: ,p_contract_number IN VARCHAR2
708: ,p_adv_grouping_flag IN VARCHAR2 DEFAULT 'Y' -- reserved for future use
709: ) RETURN VARCHAR2 IS
710:
711: l_contract_group okc_k_headers_all_b.contract_number%TYPE := p_contract_number; -- defualt to contract_number as a group criteria
712: l_disb_rules disb_rules_type;
713: lx_rule_found BOOLEAN := FALSE;
714: lx_return_status VARCHAR2(30) := G_RET_STS_SUCCESS;
715:

Line 1731: -- ,okc_k_headers_all_b chr -- cklee 09/13/07

1727: okl_trns_acc_dstrs acc_cr
1728: ,okl_txl_ap_inv_lns_b tpl
1729: ,okl_trx_ap_invoices_b tap
1730: ,po_vendor_sites_all povs
1731: -- ,okc_k_headers_all_b chr -- cklee 09/13/07
1732: ,OKL_STRM_TYPE_B sty -- cklee 09/13/07
1733: WHERE
1734: NVL(tap.trx_status_code, 'ENTERED') in ( 'ENTERED', 'APPROVED' ) AND
1735: trunc(tap.date_invoiced) BETWEEN

Line 1802: -- ,okc_k_headers_all_b chr -- cklee 09/13/07

1798: okl_trns_acc_dstrs acc_cr
1799: ,okl_txl_ap_inv_lns_b tpl
1800: ,okl_trx_ap_invoices_b tap
1801: ,po_vendor_sites_all povs
1802: -- ,okc_k_headers_all_b chr -- cklee 09/13/07
1803: ,OKL_STRM_TYPE_B sty -- cklee 09/13/07
1804: WHERE
1805: NVL(tap.trx_status_code, 'APPROVED') in ( 'APPROVED') AND
1806: trunc(tap.date_invoiced) BETWEEN

Line 1862: -- p_contract_group okc_k_headers_all_b.contract_number%type,

1858: p_currency_conversion_date date,
1859: p_legal_entity_id okl_trx_ap_invs_all_b.legal_entity_id%type,
1860: p_vpa_id okl_trx_ap_invs_all_b.vpa_id%type,
1861: p_invoice_type okl_trx_ap_invs_all_b.invoice_type%type,
1862: -- p_contract_group okc_k_headers_all_b.contract_number%type,
1863: p_disbursement_rule varchar2,
1864: p_disbursement_group varchar2,
1865: p_cin_date_invoiced date
1866: )IS

Line 1902: -- ,okc_k_headers_all_b chr -- cklee 09/13/07

1898: ,okl_trns_acc_dstrs acc_cr
1899: ,po_vendor_sites_all povs
1900: ,okl_txl_ap_inv_lns_b tpl
1901: ,okl_trx_ap_invoices_b tap
1902: -- ,okc_k_headers_all_b chr -- cklee 09/13/07
1903: ,OKL_STRM_TYPE_B sty -- cklee 09/13/07
1904: WHERE
1905: NVL(tap.trx_status_code, 'ENTERED') in ( 'ENTERED', 'APPROVED' )
1906: AND trunc(tap.date_invoiced) BETWEEN

Line 1983: -- ,okc_k_headers_all_b chr -- cklee 09/13/07

1979: ,okl_trns_acc_dstrs acc_cr
1980: ,po_vendor_sites_all povs
1981: ,okl_txl_ap_inv_lns_b tpl
1982: ,okl_trx_ap_invoices_b tap
1983: -- ,okc_k_headers_all_b chr -- cklee 09/13/07
1984: ,OKL_STRM_TYPE_B sty -- cklee 09/13/07
1985: WHERE
1986: NVL(tap.trx_status_code, 'ENTERED') in ( 'ENTERED', 'APPROVED' )
1987: AND trunc(tap.date_invoiced) BETWEEN

Line 4655: from okc_k_headers_all_b

4651: -- i NUMBER;
4652:
4653: CURSOR l_contract_id_csr (cNum VARCHAR2) Is
4654: select id
4655: from okc_k_headers_all_b
4656: where contract_number = cNum;
4657:
4658: -- l_contract_id_rec l_contract_id_csr%ROWTYPE;
4659: