APPS.OKL_CASH_RULES_SUMRY_PVT dependencies on OKL_CSH_ALLCTN_RL_HDR

Line 48: FROM OKL_CSH_ALLCTN_RL_HDR A, OKL_CASH_ALLCTN_RLS B

44: -- DECLARE Cursors
45: -------------------
46: CURSOR get_this_car_id( p_cat_id NUMBER ) IS
47: SELECT B.cau_id, A.NAME, B.DEFAULT_RULE
48: FROM OKL_CSH_ALLCTN_RL_HDR A, OKL_CASH_ALLCTN_RLS B
49: WHERE A.ID = B.CAU_ID
50: AND B.ID = p_cat_id;
51:
52: CURSOR get_last_cat_id ( p_car_id NUMBER ) IS

Line 60: l_this_car_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE;

56: (end_date >= trunc(sysdate) OR end_date IS NULL)
57: ORDER BY START_DATE DESC;
58:
59: -------------------
60: l_this_car_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE;
61: l_last_cat_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE;
62: l_this_car_name OKL_CSH_ALLCTN_RL_HDR.NAME%TYPE;
63:
64: l_default_rule OKL_CASH_ALLCTN_RLS.DEFAULT_RULE%TYPE;

Line 61: l_last_cat_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE;

57: ORDER BY START_DATE DESC;
58:
59: -------------------
60: l_this_car_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE;
61: l_last_cat_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE;
62: l_this_car_name OKL_CSH_ALLCTN_RL_HDR.NAME%TYPE;
63:
64: l_default_rule OKL_CASH_ALLCTN_RLS.DEFAULT_RULE%TYPE;
65:

Line 62: l_this_car_name OKL_CSH_ALLCTN_RL_HDR.NAME%TYPE;

58:
59: -------------------
60: l_this_car_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE;
61: l_last_cat_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE;
62: l_this_car_name OKL_CSH_ALLCTN_RL_HDR.NAME%TYPE;
63:
64: l_default_rule OKL_CASH_ALLCTN_RLS.DEFAULT_RULE%TYPE;
65:
66: BEGIN