DBA Data[Home] [Help]

APPS.OKL_CS_WF dependencies on HZ_CUST_ACCOUNTS

Line 2844: HZ_CUST_ACCOUNTS HCA

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

Line 2853: HZ_CUST_ACCOUNTS HCA

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