APPS.SR_UWQ_INTEG dependencies on OKS_ENT_HDR_SUMMARY_V

Line 1190: from oks_ent_hdr_summary_v oks, hz_parties hzp

1186: -- When a Contract number is passed as an IVR it is converted
1187: -- to the Party Id. All Open SR for that party is queried.
1188: cursor contract_cursor is
1189: select oks.contract_id, oks.party_id,hzp.party_type
1190: from oks_ent_hdr_summary_v oks, hz_parties hzp
1191: where oks.contract_number = p_parameter_value
1192: and oks.party_id = hzp.party_id
1193: and oks.start_date_active <= sysdate
1194: order by oks.start_date_active DESC;