APPS.AHL_PRD_DISP_UTIL_PVT dependencies on FND_LOOKUPS

Line 1572: FROM AHL_PRD_DISPOSITIONS_B B, FND_LOOKUPS FND1, FND_LOOKUPS FND2

1568: B.secondary_disposition_code,
1569: FND2.MEANING SECONDARY_TYPE,
1570: B.part_change_id,
1571: decode(B.instance_id, null, decode(B.path_position_id, null, 'N', 'Y'), 'Y') TRACKABLE_FLAG
1572: FROM AHL_PRD_DISPOSITIONS_B B, FND_LOOKUPS FND1, FND_LOOKUPS FND2
1573: WHERE FND1.LOOKUP_TYPE (+) = 'AHL_IMMED_DISP_TYPE'
1574: AND B.immediate_disposition_code = FND1.LOOKUP_CODE (+)
1575: AND FND2.LOOKUP_TYPE (+) = 'AHL_SECND_DISP_TYPE'
1576: AND B.SECONDARY_DISPOSITION_CODE = FND2.LOOKUP_CODE (+)

Line 1581: FROM fnd_lookups

1577: AND B.disposition_id = p_disp_id;
1578: --
1579: CURSOR get_immed_disp_types_csr IS
1580: SELECT lookup_code, meaning
1581: FROM fnd_lookups
1582: WHERE lookup_type = 'AHL_IMMED_DISP_TYPE'
1583: AND Lookup_code <> 'NULL';
1584: --
1585: CURSOR get_second_disp_types_csr IS

Line 1587: FROM fnd_lookups

1583: AND Lookup_code <> 'NULL';
1584: --
1585: CURSOR get_second_disp_types_csr IS
1586: SELECT lookup_code, meaning
1587: FROM fnd_lookups
1588: WHERE lookup_type = 'AHL_SECND_DISP_TYPE'
1589: AND Lookup_code <> 'NULL';
1590:
1591: --