APPS.OKL_FE_ADJ_MATRIX_PVT dependencies on OKL_FE_ADJ_MAT_V

Line 78: SELECT effective_from_date, effective_to_date FROM okl_fe_adj_mat_versions where adj_mat_id= p_adj_mat_id

74: (SELECT rate_set_version_id FROM okl_fe_rate_set_versions WHERE adj_mat_version_id=p_version_id);
75:
76: -- cursor to fetch the start date and the end of the previous version
77: CURSOR prev_ver_csr(p_adj_mat_id IN NUMBER, p_ver_number IN VARCHAR2) IS
78: SELECT effective_from_date, effective_to_date FROM okl_fe_adj_mat_versions where adj_mat_id= p_adj_mat_id
79: and version_number= p_ver_number-1;
80:
81: CURSOR get_elig_crit_start_date(p_version_id IN NUMBER) IS
82: SELECT max(effective_from_date)

Line 534: FROM OKL_FE_ADJ_MAT_V WHERE ADJ_MAT_ID= p_adj_mat_id;

530: CREATION_DATE,
531: LAST_UPDATED_BY,
532: LAST_UPDATE_DATE,
533: LAST_UPDATE_LOGIN
534: FROM OKL_FE_ADJ_MAT_V WHERE ADJ_MAT_ID= p_adj_mat_id;
535:
536: -- cursor to fetch the versions record
537: CURSOR adj_mat_version(p_adj_mat_id IN NUMBER, p_version_number IN VARCHAR2) IS
538: SELECT ADJ_MAT_VERSION_ID,

Line 565: LAST_UPDATE_LOGIN FROM OKL_FE_ADJ_MAT_VERSIONS

561: CREATED_BY,
562: CREATION_DATE,
563: LAST_UPDATED_BY,
564: LAST_UPDATE_DATE,
565: LAST_UPDATE_LOGIN FROM OKL_FE_ADJ_MAT_VERSIONS
566: WHERE ADJ_MAT_ID=p_adj_mat_id and VERSION_NUMBER= p_version_number;
567:
568: l_api_name VARCHAR2(40) := 'populate_adj_matrix';
569: l_api_version NUMBER := 1.0;

Line 785: OKL_FE_ADJ_MAT_VERSIONS WHERE ADJ_MAT_ID=p_adj_mat_id;

781: x_ecv_tbl OUT NOCOPY okl_ecv_tbl) IS
782:
783: CURSOR get_version_number(p_adj_mat_id IN NUMBER) IS
784: SELECT max(version_number) FROM
785: OKL_FE_ADJ_MAT_VERSIONS WHERE ADJ_MAT_ID=p_adj_mat_id;
786:
787: l_version_number VARCHAR2(24);
788: l_api_name VARCHAR2(40):='get_version';
789: l_api_version NUMBER:=1.0;

Line 906: FROM okl_fe_adj_mat_v

902: l_dummy_var VARCHAR2(1):='?';
903:
904: CURSOR pam_unique_chk(p_name IN varchar2) IS
905: SELECT 'x'
906: FROM okl_fe_adj_mat_v
907: WHERE adj_mat_name = p_name;
908:
909: BEGIN
910: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 1049: FROM okl_fe_adj_mat_versions

1045:
1046: -- cursor to fetch the previous version effective from and the previous version effective to
1047: CURSOR prev_ver_csr(l_adj_mat_id IN NUMBER, l_version_number IN VARCHAR2) IS
1048: SELECT effective_from_date, effective_to_date
1049: FROM okl_fe_adj_mat_versions
1050: WHERE adj_mat_id= l_adj_mat_id AND version_number=l_version_number -1;
1051:
1052: CURSOR get_elig_crit_start_date(p_version_id IN NUMBER) IS
1053: SELECT max(effective_from_date)

Line 1569: FROM okl_fe_adj_mat_versions

1565: SELECT ADJ_MAT_ID,
1566: VERSION_NUMBER,
1567: EFFECTIVE_FROM_DATE,
1568: EFFECTIVE_TO_DATE
1569: FROM okl_fe_adj_mat_versions
1570: WHERE ADJ_MAT_VERSION_ID = p_version_id;
1571:
1572: CURSOR ver_eff_to_csr(p_adj_mat_id IN NUMBER, p_version_number IN NUMBER)IS
1573: SELECT ADJ_MAT_VERSION_ID,

Line 1574: EFFECTIVE_TO_DATE FROM okl_fe_adj_mat_versions

1570: WHERE ADJ_MAT_VERSION_ID = p_version_id;
1571:
1572: CURSOR ver_eff_to_csr(p_adj_mat_id IN NUMBER, p_version_number IN NUMBER)IS
1573: SELECT ADJ_MAT_VERSION_ID,
1574: EFFECTIVE_TO_DATE FROM okl_fe_adj_mat_versions
1575: WHERE ADJ_MAT_ID=p_adj_mat_id and VERSION_NUMBER = p_version_number;
1576:
1577: CURSOR max_version_csr(p_adj_mat_id IN NUMBER) IS
1578: SELECT max(VERSION_NUMBER) FROM OKL_FE_ADJ_MAT_VERSIONS

Line 1578: SELECT max(VERSION_NUMBER) FROM OKL_FE_ADJ_MAT_VERSIONS

1574: EFFECTIVE_TO_DATE FROM okl_fe_adj_mat_versions
1575: WHERE ADJ_MAT_ID=p_adj_mat_id and VERSION_NUMBER = p_version_number;
1576:
1577: CURSOR max_version_csr(p_adj_mat_id IN NUMBER) IS
1578: SELECT max(VERSION_NUMBER) FROM OKL_FE_ADJ_MAT_VERSIONS
1579: WHERE ADJ_MAT_ID = p_adj_mat_id;
1580:
1581:
1582: CURSOR cal_end_date(p_version_id IN NUMBER) IS