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 1462: v_cert_start_date ota_certifications_b.start_date_active%type;

1458: p_cert_prd_enroll_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
1459: p_date date,
1460: p_reason out nocopy number) return boolean is
1461:
1462: v_cert_start_date ota_certifications_b.start_date_active%type;
1463: v_cert_end_date ota_certifications_b.end_date_active%type;
1464: v_cert_prd_enroll_start ota_cert_prd_enrollments.cert_period_start_date%type;
1465: v_cert_prd_enroll_end ota_cert_prd_enrollments.cert_period_end_date%type;
1466: begin

Line 1463: v_cert_end_date ota_certifications_b.end_date_active%type;

1459: p_date date,
1460: p_reason out nocopy number) return boolean is
1461:
1462: v_cert_start_date ota_certifications_b.start_date_active%type;
1463: v_cert_end_date ota_certifications_b.end_date_active%type;
1464: v_cert_prd_enroll_start ota_cert_prd_enrollments.cert_period_start_date%type;
1465: v_cert_prd_enroll_end ota_cert_prd_enrollments.cert_period_end_date%type;
1466: begin
1467: select c.start_date_active, c.end_date_active, cpe.cert_period_start_date, cpe.cert_period_end_date

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

1465: v_cert_prd_enroll_end ota_cert_prd_enrollments.cert_period_end_date%type;
1466: begin
1467: select c.start_date_active, c.end_date_active, cpe.cert_period_start_date, cpe.cert_period_end_date
1468: into v_cert_start_date, v_cert_end_date, v_cert_prd_enroll_start, v_cert_prd_enroll_end
1469: from ota_certifications_b c, ota_cert_prd_enrollments cpe, ota_cert_enrollments ce
1470: where cpe.cert_prd_enrollment_id = p_cert_prd_enroll_id and
1471: cpe.cert_enrollment_id = ce.cert_enrollment_id and
1472: ce.certification_id = c.certification_id;
1473:

Line 4853: OTA_CERTIFICATIONS_B crt,

4849:
4850: cursor csr_active_cert_prd is
4851: SELECT cpe.cert_prd_enrollment_id
4852: FROM
4853: OTA_CERTIFICATIONS_B crt,
4854: OTA_CERT_ENROLLMENTS cre,
4855: OTA_CERT_PRD_ENROLLMENTS cpe,
4856: OTA_CERT_MBR_ENROLLMENTS cme,
4857: OTA_CERTIFICATION_MEMBERS cmb,