APPS.CSD_REPAIRS_PVT dependencies on FND_LOOKUPS

Line 125: FND_LOOKUPS FS_LKUP

121: FS_B.flow_status_code,
122: FS_LKUP.meaning flow_status,
123: FS_B.status_code
124: FROM CSD_FLOW_STATUSES_B FS_B,
125: FND_LOOKUPS FS_LKUP
126: WHERE FS_B.flow_status_code = 'D' AND
127: FS_LKUP.lookup_type = 'CSD_REPAIR_FLOW_STATUS' AND
128: FS_LKUP.lookup_code = FS_B.flow_status_code AND
129: FS_LKUP.enabled_flag = 'Y' AND

Line 2001: FROM fnd_lookups fnd

1997: IS
1998:
1999: CURSOR c1 IS
2000: SELECT 'X'
2001: FROM fnd_lookups fnd
2002: WHERE fnd.lookup_code = p_status
2003: AND fnd.lookup_type = 'CSD_REPAIR_STATUS'
2004: AND fnd.enabled_flag = 'Y'
2005: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(fnd.start_date_active, SYSDATE))

Line 2057: FROM fnd_lookups fnd

2053: IS
2054:
2055: CURSOR c1 IS
2056: SELECT 'X'
2057: FROM fnd_lookups fnd
2058: WHERE fnd.lookup_code = p_approval_required_flag
2059: AND fnd.lookup_type = 'YES_NO'
2060: AND fnd.enabled_flag = 'Y'
2061: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(fnd.start_date_active, SYSDATE))

Line 2121: FROM fnd_lookups fnd

2117:
2118:
2119: CURSOR c1 IS
2120: SELECT 'X'
2121: FROM fnd_lookups fnd
2122: WHERE fnd.lookup_code = p_approval_status
2123: AND fnd.lookup_type = lc_appr_sts_lkp_typ
2124: AND fnd.enabled_flag = lc_enabled
2125: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(fnd.start_date_active, SYSDATE))

Line 4373: FROM FND_LOOKUPS RSN_LKUP

4369:
4370: -- Query to validate the reason code
4371: CURSOR c_check_status_reason IS
4372: SELECT RSN_LKUP.meaning reason
4373: FROM FND_LOOKUPS RSN_LKUP
4374: WHERE
4375: RSN_LKUP.lookup_type = 'CSD_REASON' AND
4376: RSN_LKUP.lookup_code = p_reason_code AND
4377: RSN_LKUP.enabled_flag = 'Y' AND

Line 5022: FROM FND_LOOKUPS RSN_LKUP

5018:
5019: -- Query to validate the reason code
5020: CURSOR c_check_rt_reason IS
5021: SELECT meaning
5022: FROM FND_LOOKUPS RSN_LKUP
5023: WHERE
5024: RSN_LKUP.lookup_type = 'CSD_RT_TRANSITION_REASONS' AND
5025: RSN_LKUP.lookup_code = p_reason_code AND
5026: RSN_LKUP.enabled_flag = 'Y' AND