[Home] [Help]
421: lv_trans_type VARCHAR2(30) := 'US_TAX_FORMS';
422: lv_trans_subtype VARCHAR2(30) := 'W4';
423: ln_business_group_id per_people_f.business_group_id%TYPE;
424: ln_parent_audit_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
425: ln_assignment_id per_assignments_f.assignment_id%TYPE;
426: ln_gre_id hr_organization_units.organization_id%TYPE;
427: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
428: ln_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
429: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
448: ftr.object_version_number,
449: ftr.effective_start_date,
450: paf.assignment_id,
451: hsck.segment1
452: from pay_us_emp_fed_tax_rules_f ftr, per_assignments_f paf,
453: hr_soft_coding_keyflex hsck
454: where paf.person_id = p_person_id
455: and paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
456: and paf.assignment_id = ftr.assignment_id
474: pus.state_code,
475: paf.assignment_id,
476: stif.sta_information7,
477: hsck.segment1
478: from pay_us_emp_state_tax_rules_f str, per_assignments_f paf,
479: pay_us_state_tax_info_f stif, pay_us_states pus,
480: hr_soft_coding_keyflex hsck
481: where paf.person_id = p_person_id
482: and paf.assignment_id = str.assignment_id
851:
852: CURSOR c_tax_defaulting IS
853: select 'x'
854: from pay_us_emp_fed_tax_rules_f prtf,
855: per_assignments_f paf
856: where paf.person_id = p_person_id
857: and decode(l_primary_only,'Y',paf.primary_flag,'Y') = 'Y'
858: and prtf.assignment_id = paf.assignment_id
859: and prtf.effective_start_date <= p_effective_date;
859: and prtf.effective_start_date <= p_effective_date;
860:
861: CURSOR c_primary_retiree_asg IS
862: select 'x'
863: from per_assignments_f paf,
864: hr_organization_information hoi,
865: hr_soft_coding_keyflex sck
866: where paf.person_id = p_person_id
867: and paf.primary_flag = 'Y'
872: and hoi.org_information_context = '1099R Magnetic Report Rules';
873:
874: CURSOR c_excess_over_fed IS
875: select 'x'
876: from per_assignments_f paf,
877: pay_us_emp_fed_tax_rules_f ftr
878: where paf.person_id = p_person_id
879: and ftr.assignment_id = paf.assignment_id
880: and paf.assignment_type = 'E'
887: or nvl(ftr.fit_override_amount,0) <> 0);
888:
889: CURSOR c_excess_over_state IS
890: select 'x'
891: from per_assignments_f paf,
892: pay_us_emp_state_tax_rules_f str
893: where paf.person_id = p_person_id
894: and paf.assignment_type = 'E'
895: and str.assignment_id = paf.assignment_id
904: or nvl(str.supp_tax_override_rate,0) <> 0);
905:
906: CURSOR c_excess_over_state_for_fed IS
907: select 'x'
908: from per_assignments_f paf,
909: pay_us_emp_state_tax_rules_f str,
910: pay_us_state_tax_info_f stif
911: where paf.person_id = p_person_id
912: and paf.assignment_type = 'E'
923: or nvl(str.supp_tax_override_rate,0) <> 0);
924:
925: CURSOR c_future_fed_recs IS
926: select 'x'
927: from per_assignments_f paf,
928: pay_us_emp_fed_tax_rules_f ftr
929: where paf.person_id = p_person_id
930: and paf.assignment_type = 'E'
931: and ftr.assignment_id = paf.assignment_id
934: and p_effective_date between paf.effective_start_date and paf.effective_end_date;
935:
936: CURSOR c_future_state_recs IS
937: select 'x'
938: from per_assignments_f paf,
939: pay_us_emp_state_tax_rules_f str
940: where paf.person_id = p_person_id
941: and str.assignment_id = paf.assignment_id
942: and paf.assignment_type = 'E'
947:
948:
949: CURSOR c_future_state_recs_for_fed IS
950: select 'x'
951: from per_assignments_f paf,
952: pay_us_emp_state_tax_rules_f str,
953: pay_us_state_tax_info_f stif
954: where paf.person_id = p_person_id
955: and str.assignment_id = paf.assignment_id