APPS.OKL_CS_WF dependencies on OKC_K_HEADERS_B

Line 2852: FROM OKC_K_HEADERS_B CHRB,

2848:
2849: CURSOR contracts_csr(c_cust_account_id NUMBER) IS
2850: SELECT chrb.id khr_id , CHRB.contract_number,
2851: hca.cust_account_id
2852: FROM OKC_K_HEADERS_B CHRB,
2853: HZ_CUST_ACCOUNTS HCA
2854: WHERE CHRB.CUST_ACCT_ID = HCA.CUST_ACCOUNT_ID
2855: AND hca.cust_account_id = c_cust_account_id;
2856:

Line 2859: /*FROM OKC_K_HEADERS_B CHRB,

2855: AND hca.cust_account_id = c_cust_account_id;
2856:
2857:
2858: -- smoduga:Removed for rules migration
2859: /*FROM OKC_K_HEADERS_B CHRB,
2860: OKC_RULES_B ORGB1,
2861: OKC_RULE_GROUPS_B ORGB2,
2862: HZ_CUST_ACCOUNTS HCA
2863: WHERE orgb2.id = orgb1.rgp_id

Line 2960: FROM okc_k_headers_b chr,

2956: c.province,
2957: c.county,
2958: c.country,
2959: c.description
2960: FROM okc_k_headers_b chr,
2961: okx_cust_site_uses_v c
2962: WHERE c.id1 = chr.bill_to_site_use_id
2963: and chr.id = c_contract_id ;
2964: