APPS.AHL_UTIL_UC_PKG dependencies on CSI_LOOKUPS

Line 113: FROM csi_lookups f, hr_all_organization_units hou, wip_entities wip_ent

109:
110: -- if location is WIP.
111: CURSOR wip_entity_csr(p_wip_job_id IN NUMBER) IS
112: SELECT f.meaning || ';' || hou.name
113: FROM csi_lookups f, hr_all_organization_units hou, wip_entities wip_ent
114: WHERE wip_ent.organization_id = hou.organization_id
115: AND wip_ent.wip_entity_id = p_wip_job_id
116: AND f.lookup_code = 'WIP'
117: AND f.lookup_type = 'CSI_INST_LOCATION_SOURCE_CODE';

Line 546: -- Procedure to return lookup meaning given the code from CSI_Lookups --

542:
543: END ValidateCSI_Item_Instance;
544:
545: ------------------------------------------------------------------------
546: -- Procedure to return lookup meaning given the code from CSI_Lookups --
547: ------------------------------------------------------------------------
548: PROCEDURE Convert_To_CSIMeaning (p_lookup_type IN VARCHAR2,
549: p_lookup_code IN VARCHAR2,
550: x_lookup_meaning OUT NOCOPY VARCHAR2,

Line 556: FROM csi_lookups

552:
553: CURSOR csi_lookup_csr (p_lookup_type IN VARCHAR2,
554: p_lookup_code IN VARCHAR2) IS
555: SELECT meaning
556: FROM csi_lookups
557: WHERE lookup_type = p_lookup_type
558: AND lookup_code = p_lookup_code
559: AND TRUNC(SYSDATE) >= TRUNC(NVL(start_date_active, SYSDATE))
560: AND TRUNC(SYSDATE) < TRUNC(NVL(end_date_active, SYSDATE+1));

Line 562: l_lookup_meaning csi_lookups.meaning%TYPE DEFAULT NULL;

558: AND lookup_code = p_lookup_code
559: AND TRUNC(SYSDATE) >= TRUNC(NVL(start_date_active, SYSDATE))
560: AND TRUNC(SYSDATE) < TRUNC(NVL(end_date_active, SYSDATE+1));
561:
562: l_lookup_meaning csi_lookups.meaning%TYPE DEFAULT NULL;
563: l_return_val BOOLEAN DEFAULT TRUE;
564:
565: BEGIN
566: