APPS.GHR_COMPLAINTS2_PKG dependencies on PER_ASSIGNMENTS_F

Line 66: l_asg_id per_assignments_f.assignment_id%TYPE := NULL;

62: ,p_posn_id IN OUT NOCOPY NUMBER
63: ,p_grade_id IN OUT NOCOPY NUMBER
64: ,p_job_id IN OUT NOCOPY NUMBER)IS
65:
66: l_asg_id per_assignments_f.assignment_id%TYPE := NULL;
67: l_posn_id per_assignments_f.position_id%TYPE := NULL;
68: l_grade_id per_assignments_f.grade_id%TYPE := NULL;
69: l_job_id per_assignments_f.job_id%TYPE := NULL;
70: l_record_found BOOLEAN := FALSE;

Line 67: l_posn_id per_assignments_f.position_id%TYPE := NULL;

63: ,p_grade_id IN OUT NOCOPY NUMBER
64: ,p_job_id IN OUT NOCOPY NUMBER)IS
65:
66: l_asg_id per_assignments_f.assignment_id%TYPE := NULL;
67: l_posn_id per_assignments_f.position_id%TYPE := NULL;
68: l_grade_id per_assignments_f.grade_id%TYPE := NULL;
69: l_job_id per_assignments_f.job_id%TYPE := NULL;
70: l_record_found BOOLEAN := FALSE;
71:

Line 68: l_grade_id per_assignments_f.grade_id%TYPE := NULL;

64: ,p_job_id IN OUT NOCOPY NUMBER)IS
65:
66: l_asg_id per_assignments_f.assignment_id%TYPE := NULL;
67: l_posn_id per_assignments_f.position_id%TYPE := NULL;
68: l_grade_id per_assignments_f.grade_id%TYPE := NULL;
69: l_job_id per_assignments_f.job_id%TYPE := NULL;
70: l_record_found BOOLEAN := FALSE;
71:
72: CURSOR cur_casg IS

Line 69: l_job_id per_assignments_f.job_id%TYPE := NULL;

65:
66: l_asg_id per_assignments_f.assignment_id%TYPE := NULL;
67: l_posn_id per_assignments_f.position_id%TYPE := NULL;
68: l_grade_id per_assignments_f.grade_id%TYPE := NULL;
69: l_job_id per_assignments_f.job_id%TYPE := NULL;
70: l_record_found BOOLEAN := FALSE;
71:
72: CURSOR cur_casg IS
73: SELECT pas.assignment_id, pas.position_id, pas.grade_id, pas.job_id

Line 74: FROM per_assignments_f pas

70: l_record_found BOOLEAN := FALSE;
71:
72: CURSOR cur_casg IS
73: SELECT pas.assignment_id, pas.position_id, pas.grade_id, pas.job_id
74: FROM per_assignments_f pas
75: WHERE p_complainant_person_id = pas.person_id
76: AND assignment_type <> 'B'
77: AND p_effective_date between pas.effective_start_date and pas.effective_end_date;
78: