APPS.OKL_SUB_PVT dependencies on FND_LOOKUPS

Line 1066: FROM Fnd_Lookups flk

1062: p_subsidy_calc_basis IN VARCHAR2) IS
1063:
1064: CURSOR flk_csr (p_lookup_type IN varchar2,p_lookup_code IN VARCHAR2) IS
1065: SELECT 'Y'
1066: FROM Fnd_Lookups flk
1067: WHERE flk.lookup_code = p_lookup_code
1068: And flk.lookup_type = p_lookup_type
1069: And flk.enabled_flag = 'Y'
1070: And sysdate between nvl(flk.start_date_active,sysdate) and nvl(flk.end_date_active,sysdate);

Line 1207: FROM Fnd_Lookups flk

1203: p_accounting_method_code IN VARCHAR2) IS
1204:
1205: CURSOR flk_csr (p_lookup_type IN varchar2,p_lookup_code IN VARCHAR2) IS
1206: SELECT 'Y'
1207: FROM Fnd_Lookups flk
1208: WHERE flk.lookup_code = p_lookup_code
1209: And flk.lookup_type = p_lookup_type
1210: And flk.enabled_flag = 'Y'
1211: And sysdate between nvl(flk.start_date_active,sysdate) and nvl(flk.end_date_active,sysdate);

Line 1263: FROM Fnd_Lookups flk

1259: x_return_status OUT NOCOPY VARCHAR2,
1260: p_termination_refund_basis IN VARCHAR2) IS
1261: CURSOR flk_csr (p_lookup_type IN varchar2,p_lookup_code IN VARCHAR2) IS
1262: SELECT 'Y'
1263: FROM Fnd_Lookups flk
1264: WHERE flk.lookup_code = p_lookup_code
1265: And flk.lookup_type = p_lookup_type
1266: And flk.enabled_flag = 'Y'
1267: And sysdate between nvl(flk.start_date_active,sysdate) and nvl(flk.end_date_active,sysdate);

Line 1370: FND_LOOKUPS lkup

1366: -- and included stream type purpose as part of bug 3985580.
1367: CURSOR styb_csr (p_stream_type_id IN number) IS
1368: SELECT 'Y'
1369: FROM OKL_STRM_TYPE_B styb,
1370: FND_LOOKUPS lkup
1371: WHERE styb.id = p_stream_type_id
1372: AND sysdate between nvl(styb.start_date,sysdate) and nvl(styb.end_date,sysdate)
1373: AND lkup.lookup_code = styb.STREAM_TYPE_PURPOSE
1374: AND lkup.lookup_type = 'OKL_STREAM_TYPE_PURPOSE';

Line 1428: FROM Fnd_Lookups flk

1424: x_return_status OUT NOCOPY VARCHAR2,
1425: p_receipt_method_code IN VARCHAR2) IS
1426: CURSOR flk_csr (p_lookup_type IN varchar2,p_lookup_code IN VARCHAR2) IS
1427: SELECT 'Y'
1428: FROM Fnd_Lookups flk
1429: WHERE flk.lookup_code = p_lookup_code
1430: And flk.lookup_type = p_lookup_type
1431: And flk.enabled_flag = 'Y'
1432: And sysdate between nvl(flk.start_date_active,sysdate) and nvl(flk.end_date_active,sysdate);

Line 2002: FND_LOOKUPS FLK7

1998: SELECT SUBP.decision_status_code,
1999: -- start: cklee 07/22/2005
2000: FLK7.MEANING
2001: FROM okl_subsidy_pools_b SUBP,
2002: FND_LOOKUPS FLK7
2003: WHERE FLK7.LOOKUP_TYPE = 'OKL_SUBSIDY_POOL_STATUS'
2004: AND FLK7.LOOKUP_CODE = SUBP.DECISION_STATUS_CODE
2005: -- end: cklee 07/22/2005
2006: -- AND SUBP.id = p_subv_rec.subsidy_pool_id;

Line 2011: lv_pool_sts_meaning fnd_lookups.MEANING%TYPE;

2007: -- START: cklee 07/28/05
2008: AND SUBP.id = p_subsidy_pool_id;
2009: -- END: cklee 07/28/05
2010: lv_pool_sts okl_subsidy_pools_b.decision_status_code%TYPE;
2011: lv_pool_sts_meaning fnd_lookups.MEANING%TYPE;
2012:
2013: CURSOR c_get_pool_dates_csr
2014: -- START: cklee 07/28/05
2015: (p_subsidy_pool_id okl_subsidy_pools_b.id%TYPE)