[Home] [Help]
244: l_proc varchar2(72);
245: --
246: cursor c_asg is
247: select assignment_id
248: from per_all_assignments_f
249: where person_id = p_person_id
250: and p_effective_date between effective_start_date
251: and effective_end_date
252: and primary_flag = 'Y'
257:
258:
259: cursor c_appl_asg is
260: select assignment_id
261: from per_all_assignments_f
262: where person_id = p_person_id
263: and p_effective_date between effective_start_date
264: and effective_end_date
265: and (p_assignment_id is null or p_assignment_id = assignment_id )
1111: a.time_normal_finish,
1112: a.supervisor_id ,
1113: a.assignment_type,
1114: b.pay_basis
1115: from per_all_assignments_f a,
1116: hr_all_organization_units_vl o,
1117: per_assignment_status_types s,
1118: pay_people_groups grp,
1119: per_pay_bases b
1329: cursor c (l_person_id number ) is select
1330: a.pay_annualization_factor,b.proposed_salary_n
1331: from per_pay_bases a,
1332: per_pay_proposals b,
1333: per_all_assignments_f c
1334: where
1335: c.person_id = l_person_id and
1336: p_effective_date between c.effective_start_date and c.effective_end_date and
1337: c.assignment_id= g_assignment_id and
3099: cursor c_pay_p_asg (p_person_id number ,
3100: p_from_date date ,
3101: p_to_date date ) is
3102: select distinct assignment_id
3103: from per_all_assignments_f
3104: where person_id = p_person_id
3105: and ( primary_flag = 'Y' OR ASSIGNMENT_TYPE ='A' ) -- vkodedal fix for 6798915
3106: and effective_start_date <= p_to_date and
3107: effective_end_date >= p_from_date
3110: -- to get th last date of the assignment to
3111: -- validate the assgnmnet against type
3112: cursor c_pay_asg_date (p_Assignment_id number ) is
3113: select effective_start_date
3114: from per_all_assignments_f
3115: where Assignment_id = p_Assignment_id
3116: and ( primary_flag = 'Y' OR ASSIGNMENT_TYPE ='A' ) -- vkodedal fix for 6798915
3117: order by effective_start_date desc ;
3118: l_pay_asg_eff_date date ;