[Home] [Help]
126: asg.location_id
127: into v_person_id,
128: v_location_id
129: from per_all_people_f per,
130: per_assignments_f asg
131: where asg.assignment_id = p_asg_id
132: and asg.business_group_id = p_business_group_id
133: and p_effective_date between asg.effective_start_date and asg.effective_end_date
134: and per.person_id = asg.person_id
350: from fnd_sessions
351: where session_id = (select userenv('sessionid') from dual);
352: cursor c_per_id is
353: select person_id from
354: per_assignments_f
355: where assignment_id = p_assignment_id
356: and business_group_id = p_business_group_id
357: and primary_flag = 'Y'
358: and assignment_type <> 'B'
829: select start_date,end_date
830: from per_time_periods
831: where payroll_id in
832: (select payroll_id
833: from per_assignments_f
834: where assignment_id = p_asg_id
835: and trunc(p_effective_date) between effective_start_date and effective_end_date)
836: and p_effective_date between start_date and end_date;
837:
900: select start_date,end_date
901: from per_time_periods
902: where payroll_id in
903: (select payroll_id
904: from per_assignments_f
905: where assignment_id = p_asg_id
906: and trunc(p_effective_date) between effective_start_date and effective_end_date)
907: and p_effective_date between start_date and end_date;
908:
1032: select start_date,end_date
1033: from per_time_periods
1034: where payroll_id in
1035: (select payroll_id
1036: from per_assignments_f
1037: where assignment_id = p_asg_id
1038: and trunc(p_effective_date) between effective_start_date and effective_end_date)
1039: and p_effective_date between start_date and end_date;
1040:
1994: l_current_check_date Date;
1995:
1996: Cursor c_get_payroll_id is
1997: select payroll_id
1998: from per_assignments_f
1999: where assignment_id = p_asg_id
2000: and p_effective_date between effective_start_date and effective_end_date;
2001:
2002: Cursor c_get_db_curr_pay_period_dtls is