1434: l_eff_date_to varchar2(4000);
1435:
1436: --l_person_details ota_learner_enroll_ss.csr_person_to_enroll_details%ROWTYPE;
1437: l_person_full_name per_all_people_f.full_name%TYPE;
1438: l_role_name wf_roles.name%type;
1439: l_role_display_name wf_roles.display_name%type;
1440:
1441: l_assignment varchar2(100);
1442:
1435:
1436: --l_person_details ota_learner_enroll_ss.csr_person_to_enroll_details%ROWTYPE;
1437: l_person_full_name per_all_people_f.full_name%TYPE;
1438: l_role_name wf_roles.name%type;
1439: l_role_display_name wf_roles.display_name%type;
1440:
1441: l_assignment varchar2(100);
1442:
1443: l_supervisor_id per_all_people_f.person_id%Type;