APPS.OTA_LP_NOTIFY_SS dependencies on OTA_GENERAL

Line 568: AND lps.business_group_id = ota_general.get_business_group_id;

564: ota_lp_enrollments lpe
565: WHERE lps.learning_path_id = lpe.learning_path_id
566: AND lpe.path_status_code = 'ACTIVE'
567: AND trunc(sysdate) + lps.notify_days_before_target = trunc(lpe.completion_target_date)
568: AND lps.business_group_id = ota_general.get_business_group_id;
569:
570: l_lp_enrollment_id number;
571: failure exception;
572: l_proc varchar2(72) := g_package||' send_lp_ct_notifications';

Line 632: AND lps.business_group_id = ota_general.get_business_group_id;

628: WHERE learning_path_section_id = lpc.learning_path_section_id
629: AND lp_enrollment_id = lpe.lp_enrollment_id
630: AND member_status_code = 'COMPLETED')))
631:
632: AND lps.business_group_id = ota_general.get_business_group_id;
633:
634: l_lpm_enrollment_id number;
635: failure exception;
636: l_proc varchar2(72) := g_package|| ' send_lpm_ct_notifications';