APPS.OKS_CDT_PVT dependencies on FND_LOOKUPS

Line 911: from FND_LOOKUPS

907:
908: l_dummy_var VARCHAR2(1) := '?';
909: Cursor l_fndv_csr Is
910: select 'x'
911: from FND_LOOKUPS
912: where lookup_code = p_approval_type ---- Check Up
913: and (lookup_type = 'OKS_REN_ONLINE_APPROVAL'
914: or lookup_type = 'OKS_REN_MANUAL_APPROVAL')
915: and sysdate between nvl(start_date_active,sysdate)

Line 1006: from FND_LOOKUPS

1002:
1003: l_dummy_var VARCHAR2(1) := '?';
1004: Cursor l_fndv_csr Is
1005: select 'x'
1006: from FND_LOOKUPS
1007: where lookup_code = p_evergreen_approval_type
1008: and (lookup_type = 'OKS_REN_MANUAL_APPROVAL')
1009: and sysdate between nvl(start_date_active,sysdate)
1010: and nvl(end_date_active,sysdate)

Line 1100: from FND_LOOKUPS

1096:
1097: l_dummy_var VARCHAR2(1) := '?';
1098: Cursor l_fndv_csr Is
1099: select 'x'
1100: from FND_LOOKUPS
1101: where lookup_code = p_online_approval_type
1102: and (lookup_type = 'OKS_REN_ONLINE_APPROVAL')
1103: and sysdate between nvl(start_date_active,sysdate)
1104: and nvl(end_date_active,sysdate)