APPS.OKL_IPY_PVT dependencies on OKL_INS_PARTYSITES_V

Line 1104: FROM OKL_INS_PARTYSITES_V

1100: l_dummy_var VARCHAR2(1) := '?' ;
1101: --foriegn check for agent site id
1102: CURSOR l_agnt_csr IS
1103: SELECT 'x'
1104: FROM OKL_INS_PARTYSITES_V
1105: WHERE site_id = p_ipyv_rec.agent_site_id ;
1106: BEGIN
1107: -- initialize return status
1108: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1130: 'OKL_INS_PARTYSITES_V');

1126: 'Agent Address',
1127: g_child_table_token ,
1128: 'OKL_INS_POLICIES_V' ,
1129: g_parent_table_token ,
1130: 'OKL_INS_PARTYSITES_V');
1131: x_return_status := OKC_API.G_RET_STS_ERROR;
1132: END IF;
1133: END IF;
1134: END IF;

Line 1155: FROM OKL_INS_PARTYSITES_V

1151: l_dummy_var VARCHAR2(1) := '?' ;
1152: -- "WARNING : Cannot implement until OKX View OKX_xxxxxx_V defined"
1153: CURSOR l_agncy_csr IS
1154: SELECT 'x'
1155: FROM OKL_INS_PARTYSITES_V
1156: WHERE SITE_ID = p_ipyv_rec.agency_site_id
1157: AND PARTY_ID = p_ipyv_rec.isu_id;
1158: BEGIN
1159: -- initialize return status

Line 1181: 'OKL_INS_PARTYSITES_V');

1177: 'Agency Address',
1178: g_child_table_token ,
1179: 'OKL_INS_POLICIES_V' ,
1180: g_parent_table_token ,
1181: 'OKL_INS_PARTYSITES_V');
1182: x_return_status := OKC_API.G_RET_STS_ERROR;
1183: END IF;
1184: END IF;
1185: EXCEPTION