APPS.OKS_MASSCHANGE_PVT dependencies on OKC_K_HEADERS_B

Line 29: l_org_id OKC_K_HEADERS_B.org_id%type;

25: l_select Varchar2(2000);
26: l_from Varchar2(2000);
27: l_where Varchar2(20000);
28: l_org_where Varchar2(2000);
29: l_org_id OKC_K_HEADERS_B.org_id%type;
30: l_eligible_contracts eligible_contracts_tbl;
31:
32: i Number := 0;
33: j Number := 0;

Line 6996: FROM okc_contacts oc , okc_k_headers_b kh

6992:
6993: CURSOR Get_contact(p_chr_id IN Number,p_cro_code IN Varchar2,
6994: p_object_code IN Varchar2, p_old_value IN Varchar2) IS
6995: SELECT oc.id, oc.object_version_number, kh.start_date start_date
6996: FROM okc_contacts oc , okc_k_headers_b kh
6997: WHERE oc.dnz_chr_id = p_chr_id
6998: AND oc.cro_code = p_cro_code
6999: AND oc.object1_id1 = p_old_value
7000: AND oc.jtot_object1_code = p_object_code

Line 7012: , Okc_k_headers_b Kh

7008:
7009: CURSOR Get_Salesrep(p_chr_id IN Number, p_old_value IN Varchar2) IS
7010: SELECT srv.id, srv.object_version_number, kh.start_date
7011: FROM OKS_K_SALES_CREDITS_V srv
7012: , Okc_k_headers_b Kh
7013: WHERE srv.cle_id Is Null
7014: And kh.id = p_chr_id
7015: And kh.id = srv.chr_id
7016: AND srv.ctc_id = to_number(p_old_value);

Line 7120: From okc_k_headers_b okch

7116: AND cln.price_list_id is null ;
7117:
7118: CURSOR get_contract_dtls (p_id IN Number) IS
7119: Select okch.currency_code
7120: From okc_k_headers_b okch
7121: Where okch.id = p_id ;
7122:
7123: ---------------------
7124: -- Local variables --

Line 7665: SELECT id FROM okc_k_headers_b okh

7661: -- Function to check the Contract is a Warranty or not
7662: FUNCTION Check_warranty(p_chr_id IN Number)
7663: RETURN Varchar2 IS
7664: CURSOR Warranty_lookup IS
7665: SELECT id FROM okc_k_headers_b okh
7666: WHERE
7667: Exists (select 'x' from OKC_K_LINES_B cle
7668: where cle.dnz_chr_id = okh.id
7669: and cle.lse_id = 14 )

Line 13978: okc_k_headers_b okh

13974: ,mrd.security_group_id
13975: ,okh.sts_code status_code
13976: FROM okc_masschange_req_dtls mrd,
13977: okc_operation_lines opn,
13978: okc_k_headers_b okh
13979: WHERE mrd.ole_id = opn.id(+)
13980: AND opn.subject_chr_id = okh.id(+) ;
13981:
13982: l_api_version CONSTANT NUMBER := 1.0;