APPS.CSD_REPAIRS_PVT dependencies on FND_LOOKUPS

Line 117: FND_LOOKUPS FS_LKUP

113: FS_B.flow_status_code,
114: FS_LKUP.meaning flow_status,
115: FS_B.status_code
116: FROM CSD_FLOW_STATUSES_B FS_B,
117: FND_LOOKUPS FS_LKUP
118: WHERE FS_B.flow_status_code = 'D' AND
119: FS_LKUP.lookup_type = 'CSD_REPAIR_FLOW_STATUS' AND
120: FS_LKUP.lookup_code = FS_B.flow_status_code AND
121: FS_LKUP.enabled_flag = 'Y' AND

Line 1694: FROM fnd_lookups fnd

1690: IS
1691:
1692: CURSOR c1 IS
1693: SELECT 'X'
1694: FROM fnd_lookups fnd
1695: WHERE fnd.lookup_code = p_status
1696: AND fnd.lookup_type = 'CSD_REPAIR_STATUS'
1697: AND fnd.enabled_flag = 'Y'
1698: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(fnd.start_date_active, SYSDATE))

Line 1750: FROM fnd_lookups fnd

1746: IS
1747:
1748: CURSOR c1 IS
1749: SELECT 'X'
1750: FROM fnd_lookups fnd
1751: WHERE fnd.lookup_code = p_approval_required_flag
1752: AND fnd.lookup_type = 'YES_NO'
1753: AND fnd.enabled_flag = 'Y'
1754: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(fnd.start_date_active, SYSDATE))

Line 1814: FROM fnd_lookups fnd

1810:
1811:
1812: CURSOR c1 IS
1813: SELECT 'X'
1814: FROM fnd_lookups fnd
1815: WHERE fnd.lookup_code = p_approval_status
1816: AND fnd.lookup_type = lc_appr_sts_lkp_typ
1817: AND fnd.enabled_flag = lc_enabled
1818: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(fnd.start_date_active, SYSDATE))

Line 4065: FROM FND_LOOKUPS RSN_LKUP

4061:
4062: -- Query to validate the reason code
4063: CURSOR c_check_status_reason IS
4064: SELECT RSN_LKUP.meaning reason
4065: FROM FND_LOOKUPS RSN_LKUP
4066: WHERE
4067: RSN_LKUP.lookup_type = 'CSD_REASON' AND
4068: RSN_LKUP.lookup_code = p_reason_code AND
4069: RSN_LKUP.enabled_flag = 'Y' AND

Line 4714: FROM FND_LOOKUPS RSN_LKUP

4710:
4711: -- Query to validate the reason code
4712: CURSOR c_check_rt_reason IS
4713: SELECT meaning
4714: FROM FND_LOOKUPS RSN_LKUP
4715: WHERE
4716: RSN_LKUP.lookup_type = 'CSD_RT_TRANSITION_REASONS' AND
4717: RSN_LKUP.lookup_code = p_reason_code AND
4718: RSN_LKUP.enabled_flag = 'Y' AND