APPS.OKL_CS_WF dependencies on OKC_K_HEADERS_B

Line 2843: FROM OKC_K_HEADERS_B CHRB,

2839:
2840: CURSOR contracts_csr(c_cust_account_id NUMBER) IS
2841: SELECT chrb.id khr_id , CHRB.contract_number,
2842: hca.cust_account_id
2843: FROM OKC_K_HEADERS_B CHRB,
2844: HZ_CUST_ACCOUNTS HCA
2845: WHERE CHRB.CUST_ACCT_ID = HCA.CUST_ACCOUNT_ID
2846: AND hca.cust_account_id = c_cust_account_id;
2847:

Line 2850: /*FROM OKC_K_HEADERS_B CHRB,

2846: AND hca.cust_account_id = c_cust_account_id;
2847:
2848:
2849: -- smoduga:Removed for rules migration
2850: /*FROM OKC_K_HEADERS_B CHRB,
2851: OKC_RULES_B ORGB1,
2852: OKC_RULE_GROUPS_B ORGB2,
2853: HZ_CUST_ACCOUNTS HCA
2854: WHERE orgb2.id = orgb1.rgp_id

Line 2951: FROM okc_k_headers_b chr,

2947: c.province,
2948: c.county,
2949: c.country,
2950: c.description
2951: FROM okc_k_headers_b chr,
2952: okx_cust_site_uses_v c
2953: WHERE c.id1 = chr.bill_to_site_use_id
2954: and chr.id = c_contract_id ;
2955: