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.OTA_LO_UTILITY dependencies on OTA_CERTIFICATIONS_B

Line 8: FROM OTA_CERTIFICATIONS_B crt,

4: g_package varchar2(33) := ' ota_lo_utility.'; -- Global package name
5: cursor csr_active_cert_prd_person(p_event_id ota_events.event_id%type,
6: p_person_id ota_cert_enrollments.contact_id%type) is
7: SELECT cpe.cert_prd_enrollment_id
8: FROM OTA_CERTIFICATIONS_B crt,
9: OTA_CERT_ENROLLMENTS cre,
10: OTA_CERT_PRD_ENROLLMENTS cpe,
11: OTA_CERT_MBR_ENROLLMENTS cme,
12: OTA_CERTIFICATION_MEMBERS cmb,

Line 39: FROM OTA_CERTIFICATIONS_B crt,

35:
36: cursor csr_active_cert_prd_contact(p_event_id ota_events.event_id%type,
37: p_contact_id ota_cert_enrollments.contact_id%type) is
38: SELECT cpe.cert_prd_enrollment_id
39: FROM OTA_CERTIFICATIONS_B crt,
40: OTA_CERT_ENROLLMENTS cre,
41: OTA_CERT_PRD_ENROLLMENTS cpe,
42: OTA_CERT_MBR_ENROLLMENTS cme,
43: OTA_CERTIFICATION_MEMBERS cmb,

Line 743: FROM OTA_CERTIFICATIONS_B crt,

739: -- learner in case he is either a person or a contact.
740: Cursor csr_person_cert_status(p_event_id ota_events.event_id%type,
741: p_person_id ota_cert_enrollments.person_id%type) is
742: SELECT cre.CERTIFICATION_STATUS_CODE
743: FROM OTA_CERTIFICATIONS_B crt,
744: OTA_CERT_ENROLLMENTS cre,
745: OTA_CERT_MBR_ENROLLMENTS cme,
746: OTA_CERTIFICATION_MEMBERS cmb,
747: OTA_EVENTS evt

Line 762: FROM OTA_CERTIFICATIONS_B crt,

758:
759: Cursor csr_contact_cert_status(p_event_id ota_events.event_id%type,
760: p_contact_id ota_cert_enrollments.contact_id%type) is
761: SELECT cre.CERTIFICATION_STATUS_CODE
762: FROM OTA_CERTIFICATIONS_B crt,
763: OTA_CERT_ENROLLMENTS cre,
764: OTA_CERT_MBR_ENROLLMENTS cme,
765: OTA_CERTIFICATION_MEMBERS cmb,
766: OTA_EVENTS evt

Line 1786: v_cert_start_date ota_certifications_b.start_date_active%type;

1782: p_cert_prd_enroll_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
1783: p_date date,
1784: p_reason out nocopy number) return boolean is
1785:
1786: v_cert_start_date ota_certifications_b.start_date_active%type;
1787: v_cert_end_date ota_certifications_b.end_date_active%type;
1788: v_cert_prd_enroll_start ota_cert_prd_enrollments.cert_period_start_date%type;
1789: v_cert_prd_enroll_end ota_cert_prd_enrollments.cert_period_end_date%type;
1790: begin

Line 1787: v_cert_end_date ota_certifications_b.end_date_active%type;

1783: p_date date,
1784: p_reason out nocopy number) return boolean is
1785:
1786: v_cert_start_date ota_certifications_b.start_date_active%type;
1787: v_cert_end_date ota_certifications_b.end_date_active%type;
1788: v_cert_prd_enroll_start ota_cert_prd_enrollments.cert_period_start_date%type;
1789: v_cert_prd_enroll_end ota_cert_prd_enrollments.cert_period_end_date%type;
1790: begin
1791: select c.start_date_active, c.end_date_active, cpe.cert_period_start_date, cpe.cert_period_end_date

Line 1793: from ota_certifications_b c, ota_cert_prd_enrollments cpe, ota_cert_enrollments ce

1789: v_cert_prd_enroll_end ota_cert_prd_enrollments.cert_period_end_date%type;
1790: begin
1791: select c.start_date_active, c.end_date_active, cpe.cert_period_start_date, cpe.cert_period_end_date
1792: into v_cert_start_date, v_cert_end_date, v_cert_prd_enroll_start, v_cert_prd_enroll_end
1793: from ota_certifications_b c, ota_cert_prd_enrollments cpe, ota_cert_enrollments ce
1794: where cpe.cert_prd_enrollment_id = p_cert_prd_enroll_id and
1795: cpe.cert_enrollment_id = ce.cert_enrollment_id and
1796: ce.certification_id = c.certification_id;
1797: