APPS.GHR_PC_BASIC_PAY dependencies on PER_ASSIGNMENTS_F

Line 1080: l_position_id per_assignments_f.position_id%type;

1076: l_old_user_table_id NUMBER;
1077: l_asg_ei_data per_assignment_extra_info%rowtype;
1078: l_prd_effective_date date;
1079: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
1080: l_position_id per_assignments_f.position_id%type;
1081: l_assignment_id per_assignments_f.assignment_id%type;
1082: l_temp_step per_people_extra_info.pei_information6%type;
1083: l_effective_date date;
1084:

Line 1081: l_assignment_id per_assignments_f.assignment_id%type;

1077: l_asg_ei_data per_assignment_extra_info%rowtype;
1078: l_prd_effective_date date;
1079: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
1080: l_position_id per_assignments_f.position_id%type;
1081: l_assignment_id per_assignments_f.assignment_id%type;
1082: l_temp_step per_people_extra_info.pei_information6%type;
1083: l_effective_date date;
1084:
1085: --Cursor to get the position id.

Line 1088: FROM per_assignments_f asg

1084:
1085: --Cursor to get the position id.
1086: CURSOR cur_per_pos(p_effective_date date) is
1087: SELECT asg.position_id, asg.assignment_id
1088: FROM per_assignments_f asg
1089: WHERE asg.person_id = p_pay_calc_data.person_id
1090: AND trunc(nvl(p_effective_date,sysdate))
1091: between asg.effective_start_date and asg.effective_end_date
1092: AND asg.assignment_type <> 'B'

Line 1097: FROM per_assignments_f asg

1093: AND asg.primary_flag = 'Y';
1094:
1095: CURSOR cur_per_pos_2 is
1096: SELECT asg.effective_start_date,asg.position_id, asg.assignment_id
1097: FROM per_assignments_f asg
1098: WHERE asg.person_id = p_pay_calc_data.person_id
1099: AND asg.position_id is not null
1100: AND asg.assignment_type <> 'B'
1101: AND asg.primary_flag = 'Y'