eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_ECC_VALUES_PVT dependencies on OKL_FE_CRITERIA_SET

Line 240: FROM okl_fe_criteria_set

236: lx_ecv_tbl okl_ecv_tbl;
237:
238: CURSOR get_ech_rec IS
239: SELECT criteria_set_id
240: FROM okl_fe_criteria_set
241: WHERE source_id = p_source_id AND source_object_code = p_source_type;
242:
243: CURSOR get_ecl_tbl(p_criteria_set_id IN number) IS
244: SELECT criteria_id

Line 1016: FROM okl_fe_criteria_set

1012: SELECT criteria_set_id
1013: ,object_version_number
1014: ,match_criteria_code
1015: ,validation_code
1016: FROM okl_fe_criteria_set
1017: WHERE source_id = p_source_id AND source_object_code = p_source_type;
1018:
1019: CURSOR get_ecl_tbl(p_criteria_set_id IN number) IS
1020: SELECT criteria_id

Line 1220: FROM okl_fe_criteria_set

1216: SELECT criteria_set_id
1217: ,object_version_number
1218: ,match_criteria_code
1219: ,validation_code
1220: FROM okl_fe_criteria_set
1221: WHERE source_id = p_source_id AND source_object_code = p_source_type;
1222:
1223: CURSOR get_ecl_tbl(p_criteria_set_id IN number) IS
1224: SELECT criteria_id

Line 1387: ,okl_fe_criteria_set ech

1383: ,ecl.effective_from_date
1384: ,ecl.effective_to_date
1385: ,ecl.object_version_number
1386: FROM okl_fe_criteria ecl
1387: ,okl_fe_criteria_set ech
1388: WHERE ech.source_id = p_source_id
1389: AND ech.source_object_code = p_source_type
1390: AND ecl.criteria_set_id = ech.criteria_set_id;
1391: i number;