APPS.OTA_INITIALIZATION_WF dependencies on OTA_CERT_PRD_ENROLLMENTS

Line 1580: p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type,

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

Line 1647: l_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type;

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

Line 1659: ,ota_cert_prd_enrollments prd

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

Line 1680: ,ota_cert_prd_enrollments prd

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

Line 1698: ,ota_cert_prd_enrollments prd

1694: ,prd.cert_prd_enrollment_id
1695: ,enr.person_id
1696: From ota_certifications_b ceb
1697: ,ota_cert_enrollments enr
1698: ,ota_cert_prd_enrollments prd
1699: Where
1700: ceb.certification_id = enr.certification_id
1701: and enr.cert_enrollment_id = prd.cert_enrollment_id
1702: and trunc(sysdate) between nvl(trunc(ceb.start_date_active), trunc(sysdate)) and

Line 1717: ,ota_cert_prd_enrollments prd

1713: ,prd.cert_prd_enrollment_id
1714: ,enr.person_id
1715: From ota_certifications_b ceb
1716: ,ota_cert_enrollments enr
1717: ,ota_cert_prd_enrollments prd
1718: Where
1719: ceb.certification_id = enr.certification_id
1720: and enr.cert_enrollment_id = prd.cert_enrollment_id
1721: and trunc(sysdate) between nvl(trunc(ceb.start_date_active), trunc(sysdate)) and