APPS.OKL_IPY_PVT dependencies on HZ_PARTIES

Line 1205: FROM HZ_PARTIES PRT

1201: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1202: l_dummy_var VARCHAR2(1) := '?' ;
1203: CURSOR l_int_csr IS
1204: SELECT 'x' --Bug:3825159
1205: FROM HZ_PARTIES PRT
1206: WHERE PRT.CATEGORY_CODE = 'INSURANCE_AGENT'
1207: AND PRT.party_id = p_ipyv_rec.int_id ;
1208: BEGIN
1209: -- initialize return status

Line 1232: 'HZ_PARTIES'); --Bug:3825159

1228: 'Insurance Agent',
1229: g_child_table_token ,
1230: 'OKL_INS_POLICIES_V' ,
1231: g_parent_table_token ,
1232: 'HZ_PARTIES'); --Bug:3825159
1233: x_return_status := OKC_API.G_RET_STS_ERROR;
1234: END IF;
1235: END IF;
1236: END IF;

Line 1258: FROM HZ_PARTIES PRT

1254: l_dummy_var VARCHAR2(1) := '?' ;
1255: -- "WARNING : Cannot implement until OKX View OKX_xxxxxx_V defined"
1256: CURSOR l_isu_csr IS
1257: SELECT 'x' --Bug:3825159
1258: FROM HZ_PARTIES PRT
1259: WHERE PRT.CATEGORY_CODE = 'INSURER'
1260: AND PRT.PARTY_ID = p_ipyv_rec.isu_id ;
1261: CURSOR l_isu_csr1 IS
1262: SELECT 'x'

Line 1293: 'HZ_PARTIES'); --Bug:3825159

1289: 'Insurance Provider',
1290: g_child_table_token ,
1291: 'OKL_INS_POLICIES_V' ,
1292: g_parent_table_token ,
1293: 'HZ_PARTIES'); --Bug:3825159
1294: x_return_status := OKC_API.G_RET_STS_ERROR;
1295: END IF;
1296: END IF;
1297: EXCEPTION