DBA Data[Home] [Help]

APPS.OTA_INITIALIZATION_WF dependencies on OTA_LP_ENROLLMENTS

Line 1216: p_lp_enrollment_id in ota_lp_enrollments.lp_enrollment_id%type,

1212: hr_utility.set_location('Leaving:'||l_proc, 5);
1213: end Initialize_auto_wf;
1214:
1215: Procedure Init_LP_wf(p_item_type in wf_items.item_type%type,
1216: p_lp_enrollment_id in ota_lp_enrollments.lp_enrollment_id%type,
1217: p_event_fired in varchar2)
1218: is
1219:
1220: cursor get_lp_info

Line 1223: from ota_learning_paths lp , ota_learning_paths_tl lpt, ota_lp_enrollments lpe

1219:
1220: cursor get_lp_info
1221: is
1222: select lpt.name, lpe.person_id, lp.start_date_active
1223: from ota_learning_paths lp , ota_learning_paths_tl lpt, ota_lp_enrollments lpe
1224: where lpt.learning_path_id = lp.learning_path_id
1225: and lpt.Language= USERENV('LANG')
1226: and lp.Learning_path_id = lpe.Learning_path_id
1227: and lpe.lp_enrollment_id = p_lp_enrollment_id;