DBA Data[Home] [Help]

APPS.OKL_CS_WF dependencies on HZ_CUST_ACCOUNTS

Line 2853: HZ_CUST_ACCOUNTS HCA

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:
2857:

Line 2862: HZ_CUST_ACCOUNTS HCA

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
2864: AND to_char(HCA.CUST_ACCOUNT_ID) = orgb1.object1_id1
2865: AND chrb.id = orgb1.dnz_chr_id
2866: AND chrb.id = orgb2.chr_id