APPS.OTA_CERT_APPROVAL_SS dependencies on OTA_CERTIFICATIONS_TL

Line 24: from ota_Certifications_tl ctl , ota_Certifications_b ctb

20: l_cert_id number(15);
21:
22: Cursor get_cert_details (crs_certification_id number)is
23: select ctl.name, ctb.initial_completion_date
24: from ota_Certifications_tl ctl , ota_Certifications_b ctb
25: where ctl.certification_id = ctb.certification_id
26: and ctl.Language= USERENV('LANG')
27: and ctl.certification_id =crs_certification_id;
28:

Line 29: l_certification_name ota_certifications_tl.name%type;

25: where ctl.certification_id = ctb.certification_id
26: and ctl.Language= USERENV('LANG')
27: and ctl.certification_id =crs_certification_id;
28:
29: l_certification_name ota_certifications_tl.name%type;
30: l_comp_date varchar2(100);
31:
32:
33:

Line 766: from ota_Certifications_tl ctl , ota_Certifications_b ctb

762: l_attribute20 ota_cert_enrollments.attribute1%type;
763:
764: Cursor get_cert_name (crs_certification_id number)is
765: select ctl.name
766: from ota_Certifications_tl ctl , ota_Certifications_b ctb
767: where ctl.certification_id = ctb.certification_id
768: and ctl.Language= USERENV('LANG')
769: and ctl.certification_id =crs_certification_id;
770:

Line 771: l_certification_name ota_certifications_tl.name%type;

767: where ctl.certification_id = ctb.certification_id
768: and ctl.Language= USERENV('LANG')
769: and ctl.certification_id =crs_certification_id;
770:
771: l_certification_name ota_certifications_tl.name%type;
772:
773: l_approval_req_flag varchar2(1);
774:
775: begin