APPS.OKL_SSC_WF dependencies on OKL_INS_PARTYSITES_V

Line 1506: SELECT site_id from OKL_INS_PARTYSITES_V

1502: SELECT party_id from hz_parties
1503: WHERE party_number = provider_name;
1504:
1505: CURSOR site_id_cur(p_party_id NUMBER) IS
1506: SELECT site_id from OKL_INS_PARTYSITES_V
1507: WHERE party_id = p_party_id;
1508:
1509: l_provider_name VARCHAR2(120);
1510: l_provider_id NUMBER;