APPS.OTA_COST_TRANSFER_TO_GL_PKG dependencies on OTA_PERFORMANCES

Line 219: select pfr.learning_object_id from ota_performances pfr

215: bst.type in ('A','C')) or
216: ( (ocu.synchronous_flag = 'N' and ocu.online_flag = 'Y' and
217: off.learning_object_id is not null and
218: off.learning_object_id in (
219: select pfr.learning_object_id from ota_performances pfr
220: where
221: pfr.user_id= tdb.delegate_person_id and
222: pfr.user_type = 'E' and
223: pfr.lesson_status <> 'N') ) and

Line 277: select pfr.learning_object_id from ota_performances pfr

273: bst.type not in ('A','C')) or
274: ( (ocu.synchronous_flag = 'N' and ocu.online_flag = 'Y' and
275: off.learning_object_id is not null and
276: ((off.learning_object_id in (
277: select pfr.learning_object_id from ota_performances pfr
278: where
279: pfr.user_id= tdb.delegate_person_id and
280: pfr.user_type = 'E' and
281: pfr.lesson_status = 'N')) or

Line 283: select pfr.learning_object_id from ota_performances pfr

279: pfr.user_id= tdb.delegate_person_id and
280: pfr.user_type = 'E' and
281: pfr.lesson_status = 'N')) or
282: ( off.learning_object_id not in(
283: select pfr.learning_object_id from ota_performances pfr
284: where
285: pfr.user_id= tdb.delegate_person_id and
286: pfr.user_type = 'E')))) and
287: bst.type in ('A','C','P','W','R','E')) or

Line 1154: select pfr.learning_object_id from ota_performances pfr

1150: bst.type in ('A','C')) or
1151: ( (ocu.synchronous_flag = 'N' and ocu.online_flag = 'Y' and
1152: off.learning_object_id is not null and
1153: off.learning_object_id in (
1154: select pfr.learning_object_id from ota_performances pfr
1155: where
1156: pfr.user_id= tdb.delegate_person_id and
1157: pfr.user_type = 'E' and
1158: pfr.lesson_status <> 'N') ) and