APPS.OKL_SSC_WF dependencies on OKL_INS_PARTYSITES_V

Line 1592: SELECT site_id from OKL_INS_PARTYSITES_V

1588: SELECT party_id from hz_parties
1589: WHERE party_number = provider_name;
1590:
1591: CURSOR site_id_cur(p_party_id NUMBER) IS
1592: SELECT site_id from OKL_INS_PARTYSITES_V
1593: WHERE party_id = p_party_id;
1594:
1595: l_provider_name VARCHAR2(120);
1596: l_provider_id NUMBER;