DBA Data[Home] [Help]

APPS.PQH_CORPS_UTILITY dependencies on PER_ALL_ASSIGNMENTS_F

Line 671: from per_all_assignments_f asg

667: return date
668: IS
669: Cursor csr_corps_date IS
670: Select min(asg.effective_start_date)
671: from per_all_assignments_f asg
672: where asg.grade_ladder_pgm_id = p_career_level_id
673: and assignment_id = p_assignment_id;
674:
675:

Line 678: from per_all_assignments_f asg

674:
675:
676: Cursor csr_grade_date IS
677: Select min(asg.effective_start_date)
678: from per_all_assignments_f asg
679: where asg.grade_id = p_career_level_id
680: and assignment_id = p_assignment_id;
681:
682: Cursor csr_step_date is