APPS.MSD_SR_UTIL dependencies on CSD_REPAIR_JOB_XREF

Line 1100: from csd_repair_job_xref crjx

1096: x_org_id number;
1097:
1098: cursor c1 is
1099: select organization_id
1100: from csd_repair_job_xref crjx
1101: where wip_entity_id = p_txn_source_id
1102: order by repair_job_xref_id desc;
1103:
1104: begin

Line 1139: from csd_repair_job_xref

1135: x_acct_id number;
1136:
1137: cursor c1 is
1138: select repair_line_id
1139: from csd_repair_job_xref
1140: where wip_entity_id = p_txn_source_id
1141: order by repair_job_xref_id desc;
1142:
1143: cursor c2 (p_repair_line_id in number) is

Line 1203: from csd_repair_job_xref

1199: x_zone_id number;
1200:
1201: cursor c1 is
1202: select repair_line_id
1203: from csd_repair_job_xref
1204: where wip_entity_id = p_txn_source_id
1205: order by repair_job_xref_id desc;
1206:
1207: cursor c2 (p_repair_line_id in number) is

Line 1248: from csd_repair_job_xref crjx

1244:
1245: x_row_num number;
1246: cursor c1 is
1247: select 1
1248: from csd_repair_job_xref crjx
1249: where wip_entity_id = p_txn_source_id
1250: order by repair_job_xref_id;
1251:
1252: begin