[Home] [Help]
337: per_system_status asg_status,
338: sck.segment1 tax_ref
339: from per_all_assignments_f asg,
340: pay_all_payrolls_f pay,
341: per_assignment_status_types pat,
342: hr_soft_coding_keyflex sck
343: where asg.person_id = p_person_id
344: and ( -- no need to fetch payroll, but do check the tax ref
345: (p_aggr_flag = 'Y' and
400: CURSOR get_cpe_flag(p_person_id number, p_paye_ref varchar2, p_date date ) IS
401: select assignment_id
402: from per_all_assignments_f asg,
403: pay_all_payrolls_f pay,
404: per_assignment_status_types pat,
405: hr_soft_coding_keyflex sck
406: where asg.person_id = p_person_id
407: and sck.segment1 = p_paye_ref
408: and asg.payroll_id = pay.payroll_id
515: -------------------------------------------------------------------
516: CURSOR get_future_term_date(p_assignment_id number, p_effective_date date ) IS
517: select effective_start_date
518: from PER_ALL_ASSIGNMENTS_F paaf,
519: per_assignment_status_types past
520: where paaf.effective_start_date >= p_effective_date
521: and paaf.assignment_id = p_assignment_id
522: and paaf.assignment_status_type_id =past.assignment_status_type_id
523: and past.per_system_status IN ('TERM_ASSIGN')
2514: paaf.assignment_id,
2515: nvl(papf.per_information10,'N')
2516: from per_assignment_extra_info paei,
2517: per_all_assignments_f paaf,
2518: per_assignment_status_types pat,
2519: per_all_people_f papf
2520: where paei.AEI_INFORMATION_CATEGORY = 'GB_RTI_AGGREGATION'
2521: and paei.AEI_INFORMATION3 = p_m34_rec.assignment_number
2522: and paaf.assignment_id = paei.assignment_id