APPS.AHL_ENIGMA_IPC_PROCS_PVT dependencies on FND_LOOKUPS

Line 157: FROM fnd_lookups

153: AND NVL(sourced_from_enigma_flag, 'N') = 'Y';
154:
155: CURSOR chk_ig_type_code_csr (p_ig_type_code VARCHAR2) IS
156: SELECT 'X'
157: FROM fnd_lookups
158: WHERE lookup_code = NVL(p_ig_type_code, 'X')
159: AND lookup_type = 'AHL_ITEMGROUP_TYPE'
160: AND TRUNC(NVL(end_date_active, SYSDATE - 1)) < TRUNC(SYSDATE);
161:

Line 170: FROM fnd_lookups

166: AND organization_id = p_org_id;
167:
168: CURSOR chk_interchg_type_code_csr (p_interchg_type_code VARCHAR2) IS
169: SELECT 'X'
170: FROM fnd_lookups
171: WHERE lookup_code = NVL(p_interchg_type_code, 'X')
172: AND lookup_type = 'AHL_INTERCHANGE_ITEM_TYPE'
173: AND TRUNC(NVL(end_date_active, SYSDATE - 1)) < TRUNC(SYSDATE);
174:

Line 674: FROM fnd_lookups

670: ) IS
671:
672: CURSOR chk_model_code_csr (p_model_code VARCHAR2) IS
673: SELECT 'X'
674: FROM fnd_lookups
675: WHERE lookup_code = p_model_code
676: AND lookup_type = 'AHL_ENIGMA_MODEL_CODE'
677: AND TRUNC(NVL(end_date_active, SYSDATE - 1)) < TRUNC(SYSDATE);
678:

Line 681: FROM fnd_lookups

677: AND TRUNC(NVL(end_date_active, SYSDATE - 1)) < TRUNC(SYSDATE);
678:
679: CURSOR get_pos_ref_csr (p_pos_ref_code VARCHAR2) IS
680: SELECT meaning
681: FROM fnd_lookups
682: WHERE lookup_code = NVL(p_pos_ref_code, '-')
683: AND lookup_type = 'AHL_POSITION_REFERENCE'
684: AND TRUNC(NVL(end_date_active, SYSDATE - 1)) < TRUNC(SYSDATE);
685:

Line 695: FROM fnd_lookups

691: AND NVL(sourced_from_enigma_flag, 'N') = 'Y';
692:
693: CURSOR chk_ata_code_csr (p_ata_code_code VARCHAR2) IS
694: SELECT 'X'
695: FROM fnd_lookups
696: WHERE lookup_code = p_ata_code_code
697: AND lookup_type = 'AHL_ATA_CODE'
698: AND TRUNC(NVL(end_date_active, SYSDATE - 1)) < TRUNC(SYSDATE);
699: