APPS.MSD_SR_UTIL dependencies on CS_INCIDENTS_ALL_B

Line 1153: from cs_incidents_all_b cia,

1149: 'attribute9', cust.attribute9, 'attribute10', cust.attribute10, 'attribute11',
1150: cust.attribute11, 'attribute12', cust.attribute12, 'attribute13',cust.attribute13,
1151: 'attribute14', cust.attribute14, 'attribute15', cust.attribute15, '2'), '1',
1152: nvl(cia.account_id, msd_sr_util.get_null_pk), msd_sr_util.get_null_pk)
1153: from cs_incidents_all_b cia,
1154: hz_cust_accounts cust,
1155: csd_repairs crp
1156: where crp.repair_line_id = p_repair_line_id
1157: and cia.incident_id = crp.incident_id

Line 1209: from cs_incidents_all_b cia,

1205: order by repair_job_xref_id desc;
1206:
1207: cursor c2 (p_repair_line_id in number) is
1208: select get_sr_zone_pk(hps.location_id, p_zone_filter)
1209: from cs_incidents_all_b cia,
1210: hz_party_sites hps,
1211: csd_repairs crp
1212: where crp.repair_line_id = p_repair_line_id
1213: and cia.incident_id = crp.incident_id