DBA Data[Home] [Help]

APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 439: FROM per_all_assignments_f asg

435: ,asg.assignment_id secondary_assignment_id
436: ,asg.effective_start_date teacher_start_date
437: -- added for compatibility with tp4. csrasg_details.
438: ,0 tp_sf_spinal_point_id
439: FROM per_all_assignments_f asg
440: WHERE asg.assignment_id = p_assignment_id
441: AND ( ( p_effective_date BETWEEN asg.effective_start_date
442: AND asg.effective_end_date )
443: OR

Line 462: ,per_all_assignments_f asg

458: ) IS
459: SELECT pgd.ROWID
460: FROM per_grades pgr
461: ,per_grade_definitions pgd
462: ,per_all_assignments_f asg
463: WHERE pgr.grade_id = asg.grade_id
464: AND pgr.grade_definition_id = pgd.grade_definition_id
465: AND asg.assignment_id = p_assignment_id
466: AND p_effective_date