APPS.CSD_RECALLS_PVT dependencies on CSD_RECALL_PARAMETERS

Line 279: FROM csd_recall_parameters

275: IF l_department_id IS NULL
276: THEN
277: SELECT department_id, supply_subinventory
278: INTO l_department_id, l_supply_subinventory
279: FROM csd_recall_parameters
280: WHERE organization_id = fnd_profile.value('CSD_DEF_REP_INV_ORG');
281: END IF;
282:
283: l_op_dtls_tbl(1).new_row := 'Y';

Line 324: FROM csd_recall_parameters

320: IF l_supply_subinventory IS NULL
321: THEN
322: SELECT department_id, supply_subinventory
323: INTO l_department_id, l_supply_subinventory
324: FROM csd_recall_parameters
325: WHERE organization_id = fnd_profile.value('CSD_DEF_REP_INV_ORG');
326: END IF;
327:
328: l_mtl_txn_dtls_tbl(i).new_row := 'Y';

Line 808: FROM csd_recall_parameters

804: g_sr_severity,
805: g_sr_urgency,
806: g_sr_owner,
807: g_sr_summary
808: FROM csd_recall_parameters
809: WHERE organization_id = FND_PROFILE.VALUE('CSD_DEF_REP_INV_ORG');
810:
811: l_service_request_rec.status_id := g_sr_status;
812: l_service_request_rec.severity_id := g_sr_severity;

Line 1035: FROM csd_recall_parameters

1031: THEN
1032: IF l_job_status = 0 THEN
1033: SELECT wip_job_status
1034: INTO l_job_status
1035: FROM csd_recall_parameters
1036: WHERE organization_id = FND_PROFILE.VALUE('CSD_DEF_REP_INV_ORG');
1037: END IF;
1038: -- find the bill and route from the service code provided.
1039: -- prepare the job attributes.