3455: cursor cur_cpp_block ( cp_bg_id in number,
3456: cp_person_id in number,
3457: cp_effective_date in date ) is
3458: select cpp_qpp_exempt_flag
3459: from per_all_assignments_f paaf, pay_ca_emp_fed_tax_info_f pcefti
3460: where paaf.person_id = cp_person_id
3461: and to_char(cp_effective_date,'YYYY') between
3462: to_char(paaf.effective_start_date,'YYYY') and
3463: to_char(paaf.effective_end_date, 'YYYY' )
3474: cursor cur_ei_block ( cp_bg_id in number,
3475: cp_person_id in number,
3476: cp_effective_date in date ) is
3477: select ei_exempt_flag
3478: from per_all_assignments_f paaf, pay_ca_emp_fed_tax_info_f pcefti
3479: where paaf.person_id = cp_person_id
3480: and to_char(cp_effective_date,'YYYY') between
3481: to_char(paaf.effective_start_date,'YYYY') and
3482: to_char(paaf.effective_end_date, 'YYYY' )