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

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 245: FROM okl_fe_criteria

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
245: FROM okl_fe_criteria
246: WHERE criteria_set_id = p_criteria_set_id;
247:
248: CURSOR get_ecv_tbl(p_criteria_id IN number) IS
249: SELECT criterion_value_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 1027: FROM okl_fe_criteria

1023: ,crit_cat_def_id
1024: ,match_criteria_code
1025: ,effective_from_date
1026: ,effective_to_date
1027: FROM okl_fe_criteria
1028: WHERE criteria_set_id = p_criteria_set_id;
1029:
1030: CURSOR get_ecv_tbl(p_criteria_id IN number) IS
1031: SELECT criterion_value_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 1231: FROM okl_fe_criteria

1227: ,crit_cat_def_id
1228: ,match_criteria_code
1229: ,effective_from_date
1230: ,effective_to_date
1231: FROM okl_fe_criteria
1232: WHERE criteria_set_id = p_criteria_set_id;
1233:
1234: CURSOR get_ecv_tbl(p_criteria_id IN number) IS
1235: SELECT criterion_value_id

Line 1386: FROM okl_fe_criteria ecl

1382: ,ecl.match_criteria_code
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;

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;