DBA Data[Home] [Help]

APPS.PQH_RANKING dependencies on PER_ALL_ASSIGNMENTS_F

Line 692: from per_all_assignments_f

688: l_proc constant varchar2(72):= g_package||'compute_score_for_gsp';
689: --
690: cursor per_asg_cur is
691: select assignment_id
692: from per_all_assignments_f
693: where person_id = p_person_id
694: And primary_flag = 'Y'
695: and p_effective_date between effective_start_date and effective_end_date;
696:

Line 697: l_assignment_id per_all_assignments_f.assignment_id%type;

693: where person_id = p_person_id
694: And primary_flag = 'Y'
695: and p_effective_date between effective_start_date and effective_end_date;
696:
697: l_assignment_id per_all_assignments_f.assignment_id%type;
698:
699: BEGIN
700:
701: hr_utility.set_location('Entering:'||l_proc, 5);