APPS.OKL_SUB_PVT dependencies on OKL_SUBSIDY_POOLS_B

Line 1122: FROM okl_subsidy_pools_b

1118: p_subsidy_pool_id IN NUMBER) IS
1119:
1120: CURSOR c_get_pool_type_csr IS
1121: SELECT pool_type_code
1122: FROM okl_subsidy_pools_b
1123: WHERE id = p_subsidy_pool_id;
1124: lv_pool_type okl_subsidy_pools_b.pool_type_code%TYPE;
1125: BEGIN
1126: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1124: lv_pool_type okl_subsidy_pools_b.pool_type_code%TYPE;

1120: CURSOR c_get_pool_type_csr IS
1121: SELECT pool_type_code
1122: FROM okl_subsidy_pools_b
1123: WHERE id = p_subsidy_pool_id;
1124: lv_pool_type okl_subsidy_pools_b.pool_type_code%TYPE;
1125: BEGIN
1126: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1127: IF(p_subsidy_pool_id IS NOT NULL)THEN
1128: OPEN c_get_pool_type_csr; FETCH c_get_pool_type_csr INTO lv_pool_type;

Line 1995: (p_subsidy_pool_id okl_subsidy_pools_b.id%TYPE)

1991:
1992: -- sjalasut, added cursors for subsidy pools enhancement. START
1993: CURSOR c_get_pool_sts_csr
1994: -- START: cklee 07/28/05
1995: (p_subsidy_pool_id okl_subsidy_pools_b.id%TYPE)
1996: -- END: cklee 07/28/05
1997: IS
1998: SELECT SUBP.decision_status_code,
1999: -- start: cklee 07/22/2005

Line 2001: FROM okl_subsidy_pools_b SUBP,

1997: IS
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

Line 2010: lv_pool_sts okl_subsidy_pools_b.decision_status_code%TYPE;

2006: -- AND SUBP.id = p_subv_rec.subsidy_pool_id;
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

Line 2015: (p_subsidy_pool_id okl_subsidy_pools_b.id%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)
2016: -- END: cklee 07/28/05
2017: IS
2018: SELECT effective_from_date, effective_to_date
2019: -- start: cklee 07/22/2005

Line 2022: FROM okl_subsidy_pools_b

2018: SELECT effective_from_date, effective_to_date
2019: -- start: cklee 07/22/2005
2020: ,SUBSIDY_POOL_NAME
2021: -- end: cklee 07/22/2005
2022: FROM okl_subsidy_pools_b
2023: -- WHERE id = p_subv_rec.subsidy_pool_id;
2024: -- START: cklee 07/28/05
2025: WHERE id = p_subsidy_pool_id;
2026: -- END: cklee 07/28/05

Line 2027: lv_pool_effective_from okl_subsidy_pools_b.effective_from_date%TYPE;

2023: -- WHERE id = p_subv_rec.subsidy_pool_id;
2024: -- START: cklee 07/28/05
2025: WHERE id = p_subsidy_pool_id;
2026: -- END: cklee 07/28/05
2027: lv_pool_effective_from okl_subsidy_pools_b.effective_from_date%TYPE;
2028: lv_pool_effective_to okl_subsidy_pools_b.effective_to_date%TYPE;
2029: -- start: cklee 07/22/2005
2030: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%TYPE;
2031: -- end: cklee 07/22/2005

Line 2028: lv_pool_effective_to okl_subsidy_pools_b.effective_to_date%TYPE;

2024: -- START: cklee 07/28/05
2025: WHERE id = p_subsidy_pool_id;
2026: -- END: cklee 07/28/05
2027: lv_pool_effective_from okl_subsidy_pools_b.effective_from_date%TYPE;
2028: lv_pool_effective_to okl_subsidy_pools_b.effective_to_date%TYPE;
2029: -- start: cklee 07/22/2005
2030: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%TYPE;
2031: -- end: cklee 07/22/2005
2032:

Line 2030: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%TYPE;

2026: -- END: cklee 07/28/05
2027: lv_pool_effective_from okl_subsidy_pools_b.effective_from_date%TYPE;
2028: lv_pool_effective_to okl_subsidy_pools_b.effective_to_date%TYPE;
2029: -- start: cklee 07/22/2005
2030: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%TYPE;
2031: -- end: cklee 07/22/2005
2032:
2033: CURSOR c_chk_asset_subsidy_csr IS
2034: SELECT 1