APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on PER_ALL_ASSIGNMENTS_F

Line 170: ,p_assignment_id per_all_assignments_f.assignment_id%type

166:
167:
168:
169: FUNCTION learner_is_notSelected(p_person_id IN per_all_people_f.person_id%type
170: ,p_assignment_id per_all_assignments_f.assignment_id%type
171: ,p_event_id IN ota_events.event_id%type)
172: RETURN Boolean IS
173:
174: CURSOR lrnr_already_selected IS

Line 182: l_lrnr_assignment_id per_all_assignments_f.assignment_id%type;

178: person_id = p_person_id
179: AND event_id = p_event_id
180: AND create_enrollment = 'Y';
181:
182: l_lrnr_assignment_id per_all_assignments_f.assignment_id%type;
183: l_person_name per_all_people_f.full_name%type;
184: l_proc varchar2(72) := g_package||'learner_is_notSelected';
185:
186: BEGIN

Line 228: FROM per_all_assignments_f asg,

224: RETURN VARCHAR2 IS
225:
226: CURSOR csr_lrnr_belongs_to_org IS
227: SELECT asg.assignment_id
228: FROM per_all_assignments_f asg,
229: (
230: SELECT p_organization_id AS organization_id
231: FROM dual
232: UNION ALL

Line 250: l_assignment_id per_all_assignments_f.assignment_id%type;

246: WHERE asg.person_id = p_person_id AND
247: asg.organization_id = orgs.organization_id AND
248: asg.assignment_type in ('E','A','C');
249:
250: l_assignment_id per_all_assignments_f.assignment_id%type;
251: l_proc varchar2(72) := g_package||'learner_belongs_to_child_org';
252: BEGIN
253:
254: hr_utility.set_location(' Entering:'||l_proc, 5);

Line 285: per_all_assignments_f paf,

281: SELECT paf.organization_id,
282: paf.business_group_id,
283: paf.assignment_id
284: FROM
285: per_all_assignments_f paf,
286: per_person_types ppt,
287: per_all_people_f perp,
288: per_person_type_usages_f ptu
289: WHERE

Line 379: organization_id per_all_assignments_f.organization_id%type,

375: job_id per_jobs_tl.job_id%type,
376: position_id per_all_positions.position_id%type,
377: completed_crs_prereq varchar2(1),
378: completed_comp_prereq varchar2(1),
379: organization_id per_all_assignments_f.organization_id%type,
380: assignment_id per_all_assignments_f.assignment_id%type
381: );
382: lrnr_rec learner_rec;
383:

Line 380: assignment_id per_all_assignments_f.assignment_id%type

376: position_id per_all_positions.position_id%type,
377: completed_crs_prereq varchar2(1),
378: completed_comp_prereq varchar2(1),
379: organization_id per_all_assignments_f.organization_id%type,
380: assignment_id per_all_assignments_f.assignment_id%type
381: );
382: lrnr_rec learner_rec;
383:
384: CURSOR csr_get_learners(

Line 402: ,per_all_assignments_f paf

398: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,p_event_id) completed_comp_prereq
399: , paf.organization_id
400: , paf.assignment_id
401: FROM per_all_people_f ppf
402: ,per_all_assignments_f paf
403: ,per_jobs_tl pjt
404: ,per_all_positions pps
405: ,per_person_type_usages_f ptu
406: ,per_person_types pts

Line 490: ,per_all_assignments_f paf

486: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,:2) completed_comp_prereq
487: , paf.organization_id organization_id
488: , paf.assignment_id assignment_id
489: FROM per_all_people_f ppf
490: ,per_all_assignments_f paf
491: ,per_jobs_tl pjt
492: ,per_all_positions pps
493: ,per_person_type_usages_f ptu
494: ,per_person_types pts

Line 628: FROM per_all_assignments_f assg,

624:
625:
626: CURSOR csr_get_cost_center_info(l_assignment_id NUMBER) IS
627: SELECT pcak.cost_allocation_keyflex_id
628: FROM per_all_assignments_f assg,
629: pay_cost_allocations_f pcaf,
630: pay_cost_allocation_keyflex pcak
631: WHERE assg.assignment_id = pcaf.assignment_id
632: AND assg.assignment_id = l_assignment_id