APPS.AHL_UTIL_UC_PKG dependencies on CSI_LOOKUPS

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

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

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

547:
548: END ValidateCSI_Item_Instance;
549:
550: ------------------------------------------------------------------------
551: -- Procedure to return lookup meaning given the code from CSI_Lookups --
552: ------------------------------------------------------------------------
553: PROCEDURE Convert_To_CSIMeaning (p_lookup_type IN VARCHAR2,
554: p_lookup_code IN VARCHAR2,
555: x_lookup_meaning OUT NOCOPY VARCHAR2,

Line 561: FROM csi_lookups

557:
558: CURSOR csi_lookup_csr (p_lookup_type IN VARCHAR2,
559: p_lookup_code IN VARCHAR2) IS
560: SELECT meaning
561: FROM csi_lookups
562: WHERE lookup_type = p_lookup_type
563: AND lookup_code = p_lookup_code
564: AND TRUNC(SYSDATE) >= TRUNC(NVL(start_date_active, SYSDATE))
565: AND TRUNC(SYSDATE) < TRUNC(NVL(end_date_active, SYSDATE+1));

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

563: AND lookup_code = p_lookup_code
564: AND TRUNC(SYSDATE) >= TRUNC(NVL(start_date_active, SYSDATE))
565: AND TRUNC(SYSDATE) < TRUNC(NVL(end_date_active, SYSDATE+1));
566:
567: l_lookup_meaning csi_lookups.meaning%TYPE DEFAULT NULL;
568: l_return_val BOOLEAN DEFAULT TRUE;
569:
570: BEGIN
571: