APPS.OTA_LRNR_ENROLL_UNENROLL_WF dependencies on OTA_CERTIFICATIONS_TL

Line 18: l_cert_name ota_certifications_tl.name%type;

14: l_item_type wf_items.item_type%type := upper(p_itemtype);
15: l_item_key wf_items.item_key%type;
16:
17:
18: l_cert_name ota_certifications_tl.name%type;
19: l_cert_comp_date ota_certifications_b.initial_completion_date%type;
20: l_cert_dur ota_certifications_b.initial_completion_duration%type;
21:
22:

Line 35: from ota_Certifications_tl ctl , ota_Certifications_b ctb

31:
32:
33: Cursor get_cert_details is
34: select ctl.name, ctb.initial_completion_date,ctb.initial_completion_duration
35: from ota_Certifications_tl ctl , ota_Certifications_b ctb
36: where ctl.certification_id = ctb.certification_id
37: and ctl.Language= USERENV('LANG')
38: and ctl.certification_id= p_certificationid;
39: