APPS.GHR_PC_BASIC_PAY dependencies on PER_ASSIGNMENTS_F

Line 1097: l_position_id per_assignments_f.position_id%type;

1093: l_old_user_table_id NUMBER;
1094: l_asg_ei_data per_assignment_extra_info%rowtype;
1095: l_prd_effective_date date;
1096: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
1097: l_position_id per_assignments_f.position_id%type;
1098: l_assignment_id per_assignments_f.assignment_id%type;
1099: l_temp_step per_people_extra_info.pei_information6%type;
1100: l_effective_date date;
1101:

Line 1098: l_assignment_id per_assignments_f.assignment_id%type;

1094: l_asg_ei_data per_assignment_extra_info%rowtype;
1095: l_prd_effective_date date;
1096: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
1097: l_position_id per_assignments_f.position_id%type;
1098: l_assignment_id per_assignments_f.assignment_id%type;
1099: l_temp_step per_people_extra_info.pei_information6%type;
1100: l_effective_date date;
1101:
1102: --Cursor to get the position id.

Line 1105: FROM per_assignments_f asg

1101:
1102: --Cursor to get the position id.
1103: CURSOR cur_per_pos(p_effective_date date) is
1104: SELECT asg.position_id, asg.assignment_id
1105: FROM per_assignments_f asg
1106: WHERE asg.person_id = p_pay_calc_data.person_id
1107: AND trunc(nvl(p_effective_date,sysdate))
1108: between asg.effective_start_date and asg.effective_end_date
1109: AND asg.assignment_type <> 'B'

Line 1114: FROM per_assignments_f asg

1110: AND asg.primary_flag = 'Y';
1111:
1112: CURSOR cur_per_pos_2 is
1113: SELECT asg.effective_start_date,asg.position_id, asg.assignment_id
1114: FROM per_assignments_f asg
1115: WHERE asg.person_id = p_pay_calc_data.person_id
1116: AND asg.position_id is not null
1117: AND asg.assignment_type <> 'B'
1118: AND asg.primary_flag = 'Y'