APPS.OKL_ARINTF_PVT dependencies on OKC_K_HEADERS_B

Line 74: l_khr_id okc_k_headers_b.id%type;

70: l_line_cust_address_id OKL_TRX_AR_INVOICES_V.ibt_id%TYPE;
71: l_line_receipt_method_id OKL_TRX_AR_INVOICES_V.irm_id%TYPE;
72: l_line_term_id OKL_TRX_AR_INVOICES_V.irt_id%TYPE;
73:
74: l_khr_id okc_k_headers_b.id%type;
75:
76: CURSOR get_chr_id (p_kle_id NUMBER) IS
77: select dnz_chr_id
78: from okc_k_lines_b

Line 85: FROM okc_k_headers_b khr

81: -- nikshah -- Bug # 5484903 Fixed,
82: -- Changed CURSOR line_bill_to_csr SQL definition
83: CURSOR line_bill_to_csr(p_khr_id NUMBER, p_kle_id NUMBER) IS
84: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
85: FROM okc_k_headers_b khr
86: , okx_cust_site_uses_v cs
87: , okc_k_lines_b cle
88: , hz_customer_profiles cp
89: WHERE khr.id = p_khr_id

Line 97: FROM okc_k_headers_b khr

93: AND cle.BILL_TO_SITE_USE_ID = cs.id1
94: AND khr.bill_to_site_use_id = cp.site_use_id(+)
95: UNION
96: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
97: FROM okc_k_headers_b khr
98: , okc_k_lines_b cle
99: , okc_k_items item
100: , okc_k_lines_b linked_asset
101: , okx_cust_site_uses_v cs

Line 694: FROM okc_k_headers_b

690: IS
691: --modified by pgomes on 21-aug-2003 for rules migration
692: CURSOR get_khr_id_csr ( p_contract_number VARCHAR2 ) IS
693: SELECT cust_acct_id
694: FROM okc_k_headers_b
695: where contract_number = p_contract_number;
696:
697: --commented out by pgomes on 21-aug-2003 for rules migration
698: BEGIN

Line 1061: l_khr_id okc_k_headers_b.id%type;

1057: l_group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type;
1058: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;
1059: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;
1060: l_invoice_group okl_invoice_formats_v.name%type;
1061: l_khr_id okc_k_headers_b.id%type;
1062: l_bank_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
1063:
1064:
1065: CURSOR acc_sys_option is

Line 1265: CURSOR get_sales_rep(p_contract_number okc_k_headers_b.contract_number%TYPE) IS

1261: --WHERE NAME = 'No Sales Credit';
1262: WHERE SALESREP_ID = p_salesrep_id;
1263:
1264: --added new cursor to fetch the sales rep for the contract.
1265: CURSOR get_sales_rep(p_contract_number okc_k_headers_b.contract_number%TYPE) IS
1266: SELECT contact.object1_id1
1267: FROM okc_k_headers_b hdr, okc_contacts contact
1268: WHERE contact.dnz_chr_id = hdr.id
1269: AND hdr.contract_number = p_contract_number

Line 1267: FROM okc_k_headers_b hdr, okc_contacts contact

1263:
1264: --added new cursor to fetch the sales rep for the contract.
1265: CURSOR get_sales_rep(p_contract_number okc_k_headers_b.contract_number%TYPE) IS
1266: SELECT contact.object1_id1
1267: FROM okc_k_headers_b hdr, okc_contacts contact
1268: WHERE contact.dnz_chr_id = hdr.id
1269: AND hdr.contract_number = p_contract_number
1270: AND contact.cro_code = 'SALESPERSON';
1271:

Line 1272: l_prev_contract_num okc_k_headers_b.contract_number%TYPE;

1268: WHERE contact.dnz_chr_id = hdr.id
1269: AND hdr.contract_number = p_contract_number
1270: AND contact.cro_code = 'SALESPERSON';
1271:
1272: l_prev_contract_num okc_k_headers_b.contract_number%TYPE;
1273: l_sales_person okc_contacts_v.object1_id1%TYPE;
1274: --vthiruva - Bug 4222231..end
1275:
1276: CURSOR sales_type_credit_csr IS