APPS.PO_ORGS_SV dependencies on MTL_PARAMETERS

Line 420: FROM mtl_parameters

416: END IF;
417: IF p_org_record.organization_id IS NOT NULL and
418: p_org_record.organization_code IS NOT NULL THEN
419: SELECT organization_code, organization_id INTO x_org_code, x_org_id
420: FROM mtl_parameters
421: WHERE organization_code = p_org_record.organization_code
422: AND organization_id = p_org_record.organization_id;
423: p_org_record.error_record.error_status := 'S';
424: p_org_record.organization_id := x_org_id;

Line 431: FROM mtl_parameters

427: END IF;
428:
429: IF p_org_record.organization_code IS NOT NULL THEN
430: SELECT organization_code, organization_id INTO x_org_code, x_org_id
431: FROM mtl_parameters
432: WHERE organization_code = p_org_record.organization_code;
433: p_org_record.error_record.error_status := 'S';
434: p_org_record.organization_id := x_org_id;
435: p_org_record.organization_code := x_org_code;

Line 441: FROM mtl_parameters

437: END IF;
438:
439: IF p_org_record.organization_id IS NOT NULL THEN
440: SELECT organization_code, organization_id INTO x_org_code, x_org_id
441: FROM mtl_parameters
442: WHERE organization_id = p_org_record.organization_id;
443: p_org_record.error_record.error_status := 'S';
444: p_org_record.organization_id := x_org_id;
445: p_org_record.organization_code := x_org_code;

Line 504: FROM mtl_parameters

500:
501: IF (p_org_record.organization_id IS NULL) THEN
502: SELECT organization_id
503: INTO x_organization_id
504: FROM mtl_parameters
505: WHERE organization_code = p_org_record.organization_code;
506: ELSE
507: x_organization_id := p_org_record.organization_id;
508: END IF;