APPS.AS_OPP_COMPETITOR_PVT dependencies on HZ_PARTIES

Line 1167: FROM HZ_PARTIES

1163: IS
1164:
1165: CURSOR C_COMPETITOR_Id_Exists (c_cmp_Id NUMBER) IS
1166: SELECT 'X'
1167: FROM HZ_PARTIES
1168: WHERE party_id = c_cmp_Id
1169: AND STATUS in ('A', 'I');
1170:
1171: l_val VARCHAR2(1);