APPS.GHR_PA_REQUESTS_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 984: l_assignment_id per_all_assignments_f.assignment_id%type;

980: l_pos_ei_grade_data per_position_extra_info%rowtype;
981: l_pos_ei_grp1_data per_position_extra_info%rowtype;
982:
983: l_pos_organization_id hr_organization_information.organization_id%TYPE;
984: l_assignment_id per_all_assignments_f.assignment_id%type;
985: l_retained_grade ghr_pay_calc.retained_grade_rec_type;
986: l_person_id per_all_assignments_f.person_id%type;
987: l_prd VARCHAR2(30);
988: l_dummy VARCHAR2(30);

Line 986: l_person_id per_all_assignments_f.person_id%type;

982:
983: l_pos_organization_id hr_organization_information.organization_id%TYPE;
984: l_assignment_id per_all_assignments_f.assignment_id%type;
985: l_retained_grade ghr_pay_calc.retained_grade_rec_type;
986: l_person_id per_all_assignments_f.person_id%type;
987: l_prd VARCHAR2(30);
988: l_dummy VARCHAR2(30);
989:
990: l_grade_id number(15);

Line 997: FROM per_all_assignments_f

993: l_location_id number(15);
994: --
995: CURSOR cur_ass_id IS
996: SELECT assignment_id, person_id
997: FROM per_all_assignments_f
998: WHERE position_id = p_position_id
999: AND assignment_type <> 'B'
1000: AND primary_flag = 'Y'
1001: AND p_effective_date

Line 1546: FROM per_all_assignments_f asg

1542: l_ret_val VARCHAR2(5) := 'FALSE';
1543: --
1544: CURSOR c_asg IS
1545: SELECT 1
1546: FROM per_all_assignments_f asg
1547: WHERE asg.position_id = p_position_id
1548: AND NVL(p_effective_date,TRUNC(sysdate))
1549: BETWEEN asg.effective_start_date AND asg.effective_end_date
1550: AND asg.assignment_type NOT IN ('A', 'B');