[Home] [Help]
68:
69: --cursor duplicated in pl_get_tax_details
70: cursor csr_contract_assgt_type(r_date date) is
71: select kyflx.segment3,past.per_system_status,paaf.person_id
72: from hr_soft_coding_keyflex kyflx,
73: per_assignment_status_types past,
74: per_all_assignments_f paaf
75: where paaf.assignment_id=p_assignment_id
76: and r_date between paaf.effective_start_date and paaf.effective_end_date
92: where per_or_asg_id=r_per_or_asg_id
93: and contract_category=r_contract_category
94: and r_sii_date between effective_start_date and effective_end_date ;
95:
96: l_contract_category hr_soft_coding_keyflex.segment3%type;
97: l_per_system_status per_assignment_status_types.per_system_status%type;
98: l_join_variable pay_pl_sii_details_f.per_or_asg_id%type;
99: l_date_earned date;
100: l_date_terminated date;
399: and pivf.input_value_id=prrv.input_value_id;
400:
401: cursor csr_contract_assgt_type(r_date date) is
402: select kyflx.segment3,kyflx.segment4,past.per_system_status,paaf.person_id
403: from hr_soft_coding_keyflex kyflx,
404: per_assignment_status_types past,
405: per_all_assignments_f paaf
406: where paaf.assignment_id=p_assignment_id
407: and r_date between paaf.effective_start_date and paaf.effective_end_date
409: and paaf.assignment_status_type_id=past.assignment_status_type_id ;
410:
411: cursor csr_normal_assignments(r_person_id number) is
412: select assignment_id
413: from per_all_assignments_f paaf,hr_soft_coding_keyflex kyflex
414: where paaf.person_id=r_person_id
415: and payroll_id= p_payroll_id
416: and kyflex.segment3='NORMAL'
417: and p_date_earned between paaf.effective_start_date and paaf.effective_end_date
419:
420: cursor csr_other_normal_contracts(r_person_id number) is
421: select 'Y'
422: from per_all_assignments_f paaf
423: ,hr_soft_coding_keyflex kyflex
424: ,per_assignment_status_types past
425: where paaf.person_id=r_person_id
426: and paaf.assignment_id<>p_assignment_id
427: and p_date_earned between paaf.effective_start_date and paaf.effective_end_date