APPS.PAY_US_WEB_W4 dependencies on PAY_US_EMP_FED_TAX_RULES_F

Line 218: ,p_fed_org_filing_status_code IN pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE

214:
215: FUNCTION Fed_State_Filing_Status_Match(
216: p_state_code IN pay_us_states.state_code%TYPE
217: ,p_state_org_filing_status_code IN pay_us_emp_state_tax_rules_f.filing_status_code%TYPE
218: ,p_fed_org_filing_status_code IN pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
219: ,p_fed_org_wa IN pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
220: ,p_state_org_wa IN pay_us_emp_state_tax_rules_f.withholding_allowances%TYPE
221: ,p_fed_exmpt_cnt IN NUMBER
222: ,p_state_empt_cnt IN NUMBER

Line 219: ,p_fed_org_wa IN pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE

215: FUNCTION Fed_State_Filing_Status_Match(
216: p_state_code IN pay_us_states.state_code%TYPE
217: ,p_state_org_filing_status_code IN pay_us_emp_state_tax_rules_f.filing_status_code%TYPE
218: ,p_fed_org_filing_status_code IN pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
219: ,p_fed_org_wa IN pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
220: ,p_state_org_wa IN pay_us_emp_state_tax_rules_f.withholding_allowances%TYPE
221: ,p_fed_exmpt_cnt IN NUMBER
222: ,p_state_empt_cnt IN NUMBER
223: ,p_new_filing_status_code IN OUT NOCOPY pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE

Line 223: ,p_new_filing_status_code IN OUT NOCOPY pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE

219: ,p_fed_org_wa IN pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
220: ,p_state_org_wa IN pay_us_emp_state_tax_rules_f.withholding_allowances%TYPE
221: ,p_fed_exmpt_cnt IN NUMBER
222: ,p_state_empt_cnt IN NUMBER
223: ,p_new_filing_status_code IN OUT NOCOPY pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
224: )
225: RETURN BOOLEAN IS
226:
227: CURSOR cur_state_name(p_st_cd IN VARCHAR2) IS

Line 596: pay_us_emp_fed_tax_rules_f ftr

592:
593: CURSOR c_excess_over_fed IS
594: select 'x'
595: from per_assignments_f paf,
596: pay_us_emp_fed_tax_rules_f ftr
597: where paf.person_id = p_person_id
598: and ftr.assignment_id = paf.assignment_id
599: and paf.assignment_type = 'E'
600: and decode(l_primary_only,'Y',paf.primary_flag,'Y') = 'Y'

Line 635: pay_us_emp_fed_tax_rules_f ftr

631:
632: CURSOR c_future_fed_recs IS
633: select 'x'
634: from per_assignments_f paf,
635: pay_us_emp_fed_tax_rules_f ftr
636: where paf.person_id = p_person_id
637: and paf.assignment_type = 'E'
638: and ftr.assignment_id = paf.assignment_id
639: and decode(l_primary_only,'Y',paf.primary_flag,'Y') = 'Y'

Line 790: ln_add_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;

786: ** Public
787: **
788: ******************************************************************/
789: AS
790: ln_add_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
791: l_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
792: l_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
793: l_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
794: l_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;

Line 791: l_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;

787: **
788: ******************************************************************/
789: AS
790: ln_add_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
791: l_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
792: l_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
793: l_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
794: l_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
795: ln_person_id per_people_f.person_id%TYPE;

Line 792: l_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;

788: ******************************************************************/
789: AS
790: ln_add_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
791: l_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
792: l_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
793: l_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
794: l_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
795: ln_person_id per_people_f.person_id%TYPE;
796: ln_business_group_id per_people_f.business_group_id%TYPE;

Line 793: l_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;

789: AS
790: ln_add_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
791: l_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
792: l_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
793: l_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
794: l_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
795: ln_person_id per_people_f.person_id%TYPE;
796: ln_business_group_id per_people_f.business_group_id%TYPE;
797: ln_organization_id hr_organization_information.organization_id%TYPE;

Line 794: l_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;

790: ln_add_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
791: l_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
792: l_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
793: l_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
794: l_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
795: ln_person_id per_people_f.person_id%TYPE;
796: ln_business_group_id per_people_f.business_group_id%TYPE;
797: ln_organization_id hr_organization_information.organization_id%TYPE;
798: lr_org_info_rec hr_organization_information%ROWTYPE;

Line 1580: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE

1576: END;
1577:
1578:
1579: PROCEDURE update_alien_tax_records(
1580: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1581: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1582: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
1583: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1584: ,p_process VARCHAR2

Line 1581: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE

1577:
1578:
1579: PROCEDURE update_alien_tax_records(
1580: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1581: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1582: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
1583: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1584: ,p_process VARCHAR2
1585: ,p_itemtype VARCHAR2

Line 1582: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE

1578:
1579: PROCEDURE update_alien_tax_records(
1580: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1581: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1582: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
1583: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1584: ,p_process VARCHAR2
1585: ,p_itemtype VARCHAR2
1586: ,p_person_id per_people_f.person_id%TYPE default null

Line 1583: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE

1579: PROCEDURE update_alien_tax_records(
1580: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1581: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1582: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
1583: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1584: ,p_process VARCHAR2
1585: ,p_itemtype VARCHAR2
1586: ,p_person_id per_people_f.person_id%TYPE default null
1587: ,p_effective_date date default null

Line 1608: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;

1604: ln_business_group_id per_people_f.business_group_id%TYPE;
1605: ln_parent_audit_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
1606: ln_assignment_id per_assignments_f.assignment_id%TYPE;
1607: ln_gre_id hr_organization_units.organization_id%TYPE;
1608: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
1609: ln_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
1610: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1611: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1612: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

Line 1610: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

1606: ln_assignment_id per_assignments_f.assignment_id%TYPE;
1607: ln_gre_id hr_organization_units.organization_id%TYPE;
1608: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
1609: ln_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
1610: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1611: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1612: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
1613: lv_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1614: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;

Line 1611: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

1607: ln_gre_id hr_organization_units.organization_id%TYPE;
1608: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
1609: ln_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
1610: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1611: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1612: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
1613: lv_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1614: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1615: lv_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;

Line 1612: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

1608: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
1609: ln_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
1610: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1611: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1612: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
1613: lv_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1614: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1615: lv_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
1616: lv_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;

Line 1613: lv_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;

1609: ln_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
1610: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1611: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1612: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
1613: lv_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1614: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1615: lv_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
1616: lv_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1617: lv_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;

Line 1614: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;

1610: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1611: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1612: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
1613: lv_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1614: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1615: lv_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
1616: lv_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1617: lv_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1618: lv_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;

Line 1615: lv_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;

1611: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1612: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
1613: lv_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1614: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1615: lv_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
1616: lv_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1617: lv_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1618: lv_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
1619: lv_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;

Line 1616: lv_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;

1612: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
1613: lv_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1614: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1615: lv_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
1616: lv_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1617: lv_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1618: lv_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
1619: lv_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
1620: lv_last_name_diff_flag VARCHAR2(1);

Line 1617: lv_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;

1613: lv_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1614: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1615: lv_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
1616: lv_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1617: lv_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1618: lv_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
1619: lv_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
1620: lv_last_name_diff_flag VARCHAR2(1);
1621: lv_state_name pay_us_states.state_name%TYPE;

Line 1618: lv_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;

1614: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1615: lv_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
1616: lv_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1617: lv_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1618: lv_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
1619: lv_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
1620: lv_last_name_diff_flag VARCHAR2(1);
1621: lv_state_name pay_us_states.state_name%TYPE;
1622: lv_state_code pay_us_states.state_code%TYPE;

Line 1619: lv_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;

1615: lv_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
1616: lv_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1617: lv_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1618: lv_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
1619: lv_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
1620: lv_last_name_diff_flag VARCHAR2(1);
1621: lv_state_name pay_us_states.state_name%TYPE;
1622: lv_state_code pay_us_states.state_code%TYPE;
1623: lv_state_default_code VARCHAR2(30);

Line 1693: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE

1689: END update_alien_tax_records;
1690:
1691:
1692: PROCEDURE update_tax_records(
1693: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1694: ,p_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1695: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1696: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1697: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE

Line 1694: ,p_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE

1690:
1691:
1692: PROCEDURE update_tax_records(
1693: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1694: ,p_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1695: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1696: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1697: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
1698: ,p_last_name_diff VARCHAR2 DEFAULT 'N'

Line 1695: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE

1691:
1692: PROCEDURE update_tax_records(
1693: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1694: ,p_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1695: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1696: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1697: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
1698: ,p_last_name_diff VARCHAR2 DEFAULT 'N'
1699: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE

Line 1696: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE

1692: PROCEDURE update_tax_records(
1693: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1694: ,p_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1695: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1696: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1697: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
1698: ,p_last_name_diff VARCHAR2 DEFAULT 'N'
1699: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1700: ,p_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE

Line 1697: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE

1693: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1694: ,p_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1695: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1696: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1697: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
1698: ,p_last_name_diff VARCHAR2 DEFAULT 'N'
1699: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1700: ,p_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1701: ,p_transaction_id hr_api_transactions.transaction_id%type

Line 1699: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE

1695: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1696: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1697: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
1698: ,p_last_name_diff VARCHAR2 DEFAULT 'N'
1699: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1700: ,p_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1701: ,p_transaction_id hr_api_transactions.transaction_id%type
1702: ,p_person_id VARCHAR2
1703: ,p_transaction_type VARCHAR2

Line 1700: ,p_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE

1696: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1697: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
1698: ,p_last_name_diff VARCHAR2 DEFAULT 'N'
1699: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1700: ,p_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1701: ,p_transaction_id hr_api_transactions.transaction_id%type
1702: ,p_person_id VARCHAR2
1703: ,p_transaction_type VARCHAR2
1704: ,p_source_name VARCHAR2

Line 1726: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;

1722: ln_business_group_id per_people_f.business_group_id%TYPE;
1723: ln_parent_audit_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
1724: ln_assignment_id per_assignments_f.assignment_id%TYPE;
1725: ln_gre_id hr_organization_units.organization_id%TYPE;
1726: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
1727: ln_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
1728: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1729: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1730: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

Line 1728: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

1724: ln_assignment_id per_assignments_f.assignment_id%TYPE;
1725: ln_gre_id hr_organization_units.organization_id%TYPE;
1726: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
1727: ln_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
1728: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1729: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1730: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
1731: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1732: lv_state_filing_status_code pay_us_emp_state_tax_rules_f.filing_status_code%TYPE;

Line 1729: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

1725: ln_gre_id hr_organization_units.organization_id%TYPE;
1726: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
1727: ln_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
1728: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1729: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1730: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
1731: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1732: lv_state_filing_status_code pay_us_emp_state_tax_rules_f.filing_status_code%TYPE;
1733: cu_state_filing_status_code pay_us_emp_state_tax_rules_f.filing_status_code%TYPE;

Line 1730: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

1726: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
1727: ln_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
1728: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1729: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1730: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
1731: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1732: lv_state_filing_status_code pay_us_emp_state_tax_rules_f.filing_status_code%TYPE;
1733: cu_state_filing_status_code pay_us_emp_state_tax_rules_f.filing_status_code%TYPE;
1734: cu_state_wa pay_us_emp_state_tax_rules_f.withholding_allowances%TYPE;

Line 1731: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;

1727: ln_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
1728: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1729: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1730: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
1731: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1732: lv_state_filing_status_code pay_us_emp_state_tax_rules_f.filing_status_code%TYPE;
1733: cu_state_filing_status_code pay_us_emp_state_tax_rules_f.filing_status_code%TYPE;
1734: cu_state_wa pay_us_emp_state_tax_rules_f.withholding_allowances%TYPE;
1735: cu_sit_exempt pay_us_emp_state_tax_rules_f.sit_exempt%TYPE;

Line 1795: from pay_us_emp_fed_tax_rules_f ftr, per_assignments_f paf,

1791: decode(ftr.fit_exempt,'Y',1,0),
1792: decode(ftr.futa_tax_exempt,'Y',1,0),
1793: decode(ftr.medicare_tax_exempt,'Y',1,0),
1794: decode(ftr.ss_tax_exempt,'Y',1,0)
1795: from pay_us_emp_fed_tax_rules_f ftr, per_assignments_f paf,
1796: hr_soft_coding_keyflex hsck
1797: where paf.person_id = ln_person_id
1798: and paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
1799: and paf.assignment_id = ftr.assignment_id

Line 1819: from pay_us_emp_fed_tax_rules_f ftr

1815: decode(ftr.fit_exempt,'Y',1,0) fit_exempt_count,
1816: decode(ftr.futa_tax_exempt,'Y',1,0) futa_tax_exempt_count,
1817: decode(ftr.medicare_tax_exempt,'Y',1,0) medicare_tax_exempt_count,
1818: decode(ftr.ss_tax_exempt,'Y',1,0) ss_tax_exempt_count
1819: from pay_us_emp_fed_tax_rules_f ftr
1820: ,per_assignments_f paf
1821: ,hr_soft_coding_keyflex hsck
1822: where paf.person_id = ln_person_id
1823: and paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id

Line 2625: l_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;

2621: l_number_value hr_api_transaction_values.number_value%type;
2622:
2623: l_filing_status hr_api_transaction_values.varchar2_value%type;
2624:
2625: l_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
2626:
2627: l_allowances hr_api_transaction_values.number_value%type;
2628: l_add_tax hr_api_transaction_values.number_value%type;
2629: l_exempt hr_api_transaction_values.varchar2_value%type;

Line 2631: l_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;

2627: l_allowances hr_api_transaction_values.number_value%type;
2628: l_add_tax hr_api_transaction_values.number_value%type;
2629: l_exempt hr_api_transaction_values.varchar2_value%type;
2630:
2631: l_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
2632: l_org_allowances hr_api_transaction_values.number_value%type;
2633: l_org_exempt hr_api_transaction_values.varchar2_value%type;
2634: l_last_name_diff hr_api_transaction_values.varchar2_value%TYPE;
2635: