APPS.OTA_INITIALIZATION_WF dependencies on OTA_CERT_PRD_ENROLLMENTS

Line 1578: p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type,

1574:
1575: Procedure initialize_cert_ntf_wf(p_item_type in wf_items.item_type%type,
1576: p_person_id in number default null,
1577: p_certification_id in ota_certifications_b.certification_id%type,
1578: p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
1579: p_cert_ntf_type in varchar2) is
1580:
1581:
1582: cursor get_certification_info is

Line 1645: l_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type;

1641:
1642: l_proc varchar2(72) := g_package || ' process_cert_alert';
1643:
1644: l_certification_id ota_certifications_b.certification_id%type;
1645: l_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type;
1646: l_person_id ota_cert_enrollments.person_id%type;
1647:
1648: l_item_type VARCHAR2(5) := 'OTWF';
1649:

Line 1657: ,ota_cert_prd_enrollments prd

1653: ,prd.cert_prd_enrollment_id
1654: ,enr.person_id
1655: From ota_certifications_b ceb
1656: ,ota_cert_enrollments enr
1657: ,ota_cert_prd_enrollments prd
1658: Where
1659: ceb.certification_id = enr.certification_id
1660: and enr.cert_enrollment_id = prd.cert_enrollment_id
1661: and trunc(sysdate) between nvl(trunc(ceb.start_date_active), trunc(sysdate)) and

Line 1677: ,ota_cert_prd_enrollments prd

1673: ,prd.cert_prd_enrollment_id
1674: ,enr.person_id
1675: From ota_certifications_b ceb
1676: ,ota_cert_enrollments enr
1677: ,ota_cert_prd_enrollments prd
1678: Where
1679: ceb.certification_id = enr.certification_id
1680: and enr.cert_enrollment_id = prd.cert_enrollment_id
1681: and trunc(sysdate) between nvl(trunc(ceb.start_date_active), trunc(sysdate)) and

Line 1694: ,ota_cert_prd_enrollments prd

1690: ,prd.cert_prd_enrollment_id
1691: ,enr.person_id
1692: From ota_certifications_b ceb
1693: ,ota_cert_enrollments enr
1694: ,ota_cert_prd_enrollments prd
1695: Where
1696: ceb.certification_id = enr.certification_id
1697: and enr.cert_enrollment_id = prd.cert_enrollment_id
1698: and trunc(sysdate) between nvl(trunc(ceb.start_date_active), trunc(sysdate)) and

Line 1713: ,ota_cert_prd_enrollments prd

1709: ,prd.cert_prd_enrollment_id
1710: ,enr.person_id
1711: From ota_certifications_b ceb
1712: ,ota_cert_enrollments enr
1713: ,ota_cert_prd_enrollments prd
1714: Where
1715: ceb.certification_id = enr.certification_id
1716: and enr.cert_enrollment_id = prd.cert_enrollment_id
1717: and trunc(sysdate) between nvl(trunc(ceb.start_date_active), trunc(sysdate)) and