APPS.OTA_LP_NOTIFY_SS dependencies on OTA_GENERAL

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

543: ota_lp_enrollments lpe
544: WHERE lps.learning_path_id = lpe.learning_path_id
545: AND lpe.path_status_code = 'ACTIVE'
546: AND trunc(sysdate) + lps.notify_days_before_target = trunc(lpe.completion_target_date)
547: AND lps.business_group_id = ota_general.get_business_group_id;
548:
549: l_lp_enrollment_id number;
550: failure exception;
551: l_proc varchar2(72) := g_package||' send_lp_ct_notifications';

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

607: WHERE learning_path_section_id = lpc.learning_path_section_id
608: AND lp_enrollment_id = lpe.lp_enrollment_id
609: AND member_status_code = 'COMPLETED')))
610:
611: AND lps.business_group_id = ota_general.get_business_group_id;
612:
613: l_lpm_enrollment_id number;
614: failure exception;
615: l_proc varchar2(72) := g_package|| ' send_lpm_ct_notifications';