APPS.PAY_US_WEB_W4 dependencies on PAY_US_EMP_FED_TAX_RULES_F

Line 256: ,p_fed_org_filing_status_code IN pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE

252:
253: FUNCTION Fed_State_Filing_Status_Match(
254: p_state_code IN pay_us_states.state_code%TYPE
255: ,p_state_org_filing_status_code IN pay_us_emp_state_tax_rules_f.filing_status_code%TYPE
256: ,p_fed_org_filing_status_code IN pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
257: ,p_fed_org_wa IN pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
258: ,p_state_org_wa IN pay_us_emp_state_tax_rules_f.withholding_allowances%TYPE
259: ,p_fed_exmpt_cnt IN NUMBER
260: ,p_state_empt_cnt IN NUMBER

Line 257: ,p_fed_org_wa IN pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE

253: FUNCTION Fed_State_Filing_Status_Match(
254: p_state_code IN pay_us_states.state_code%TYPE
255: ,p_state_org_filing_status_code IN pay_us_emp_state_tax_rules_f.filing_status_code%TYPE
256: ,p_fed_org_filing_status_code IN pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
257: ,p_fed_org_wa IN pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
258: ,p_state_org_wa IN pay_us_emp_state_tax_rules_f.withholding_allowances%TYPE
259: ,p_fed_exmpt_cnt IN NUMBER
260: ,p_state_empt_cnt IN NUMBER
261: ,p_new_filing_status_code IN OUT NOCOPY pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE

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

257: ,p_fed_org_wa IN pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
258: ,p_state_org_wa IN pay_us_emp_state_tax_rules_f.withholding_allowances%TYPE
259: ,p_fed_exmpt_cnt IN NUMBER
260: ,p_state_empt_cnt IN NUMBER
261: ,p_new_filing_status_code IN OUT NOCOPY pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
262: )
263: RETURN BOOLEAN IS
264:
265: CURSOR cur_state_name(p_st_cd IN VARCHAR2) IS

Line 728: pay_us_emp_fed_tax_rules_f ftr

724:
725: CURSOR c_excess_over_fed IS
726: select 'x'
727: from per_assignments_f paf,
728: pay_us_emp_fed_tax_rules_f ftr
729: where paf.person_id = p_person_id
730: and ftr.assignment_id = paf.assignment_id
731: and paf.assignment_type = 'E'
732: and decode(l_primary_only,'Y',paf.primary_flag,'Y') = 'Y'

Line 767: pay_us_emp_fed_tax_rules_f ftr

763:
764: CURSOR c_future_fed_recs IS
765: select 'x'
766: from per_assignments_f paf,
767: pay_us_emp_fed_tax_rules_f ftr
768: where paf.person_id = p_person_id
769: and paf.assignment_type = 'E'
770: and ftr.assignment_id = paf.assignment_id
771: and decode(l_primary_only,'Y',paf.primary_flag,'Y') = 'Y'

Line 922: ln_add_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;

918: ** Public
919: **
920: ******************************************************************/
921: AS
922: ln_add_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
923: l_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
924: l_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
925: l_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
926: l_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;

Line 923: l_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;

919: **
920: ******************************************************************/
921: AS
922: ln_add_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
923: l_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
924: l_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
925: l_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
926: l_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
927: ln_person_id per_people_f.person_id%TYPE;

Line 924: l_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;

920: ******************************************************************/
921: AS
922: ln_add_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
923: l_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
924: l_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
925: l_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
926: l_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
927: ln_person_id per_people_f.person_id%TYPE;
928: ln_business_group_id per_people_f.business_group_id%TYPE;

Line 925: l_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;

921: AS
922: ln_add_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
923: l_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
924: l_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
925: l_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
926: l_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
927: ln_person_id per_people_f.person_id%TYPE;
928: ln_business_group_id per_people_f.business_group_id%TYPE;
929: ln_organization_id hr_organization_information.organization_id%TYPE;

Line 926: l_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;

922: ln_add_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
923: l_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
924: l_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
925: l_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
926: l_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
927: ln_person_id per_people_f.person_id%TYPE;
928: ln_business_group_id per_people_f.business_group_id%TYPE;
929: ln_organization_id hr_organization_information.organization_id%TYPE;
930: lr_org_info_rec hr_organization_information%ROWTYPE;

Line 1721: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE

1717: END;
1718:
1719:
1720: PROCEDURE update_alien_tax_records(
1721: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1722: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1723: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
1724: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1725: ,p_process VARCHAR2

Line 1722: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE

1718:
1719:
1720: PROCEDURE update_alien_tax_records(
1721: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1722: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1723: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
1724: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1725: ,p_process VARCHAR2
1726: ,p_itemtype VARCHAR2

Line 1723: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE

1719:
1720: PROCEDURE update_alien_tax_records(
1721: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1722: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1723: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
1724: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1725: ,p_process VARCHAR2
1726: ,p_itemtype VARCHAR2
1727: ,p_person_id per_people_f.person_id%TYPE default null

Line 1724: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE

1720: PROCEDURE update_alien_tax_records(
1721: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1722: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1723: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
1724: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1725: ,p_process VARCHAR2
1726: ,p_itemtype VARCHAR2
1727: ,p_person_id per_people_f.person_id%TYPE default null
1728: ,p_effective_date date default null

Line 1749: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;

1745: ln_business_group_id per_people_f.business_group_id%TYPE;
1746: ln_parent_audit_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
1747: ln_assignment_id per_assignments_f.assignment_id%TYPE;
1748: ln_gre_id hr_organization_units.organization_id%TYPE;
1749: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
1750: ln_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
1751: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1752: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1753: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

Line 1751: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

1747: ln_assignment_id per_assignments_f.assignment_id%TYPE;
1748: ln_gre_id hr_organization_units.organization_id%TYPE;
1749: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
1750: ln_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
1751: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1752: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1753: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
1754: lv_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1755: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;

Line 1752: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

1748: ln_gre_id hr_organization_units.organization_id%TYPE;
1749: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
1750: ln_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
1751: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1752: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1753: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
1754: lv_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1755: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1756: lv_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;

Line 1753: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

1749: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
1750: ln_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
1751: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1752: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1753: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
1754: lv_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1755: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1756: lv_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
1757: lv_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;

Line 1754: lv_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;

1750: ln_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
1751: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1752: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1753: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
1754: lv_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1755: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1756: lv_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
1757: lv_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1758: lv_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;

Line 1755: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;

1751: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1752: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1753: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
1754: lv_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1755: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1756: lv_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
1757: lv_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1758: lv_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1759: lv_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;

Line 1756: lv_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;

1752: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1753: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
1754: lv_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1755: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1756: lv_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
1757: lv_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1758: lv_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1759: lv_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
1760: lv_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;

Line 1757: lv_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;

1753: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
1754: lv_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1755: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1756: lv_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
1757: lv_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1758: lv_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1759: lv_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
1760: lv_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
1761: lv_last_name_diff_flag VARCHAR2(1);

Line 1758: lv_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;

1754: lv_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1755: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1756: lv_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
1757: lv_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1758: lv_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1759: lv_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
1760: lv_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
1761: lv_last_name_diff_flag VARCHAR2(1);
1762: lv_state_name pay_us_states.state_name%TYPE;

Line 1759: lv_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;

1755: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1756: lv_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
1757: lv_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1758: lv_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1759: lv_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
1760: lv_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
1761: lv_last_name_diff_flag VARCHAR2(1);
1762: lv_state_name pay_us_states.state_name%TYPE;
1763: lv_state_code pay_us_states.state_code%TYPE;

Line 1760: lv_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;

1756: lv_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
1757: lv_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1758: lv_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1759: lv_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
1760: lv_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
1761: lv_last_name_diff_flag VARCHAR2(1);
1762: lv_state_name pay_us_states.state_name%TYPE;
1763: lv_state_code pay_us_states.state_code%TYPE;
1764: lv_state_default_code VARCHAR2(30);

Line 1834: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE

1830: END update_alien_tax_records;
1831:
1832:
1833: PROCEDURE update_tax_records(
1834: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1835: ,p_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1836: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1837: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1838: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE

Line 1835: ,p_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE

1831:
1832:
1833: PROCEDURE update_tax_records(
1834: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1835: ,p_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1836: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1837: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1838: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
1839: ,p_last_name_diff VARCHAR2 DEFAULT 'N'

Line 1836: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE

1832:
1833: PROCEDURE update_tax_records(
1834: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1835: ,p_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1836: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1837: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1838: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
1839: ,p_last_name_diff VARCHAR2 DEFAULT 'N'
1840: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE

Line 1837: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE

1833: PROCEDURE update_tax_records(
1834: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1835: ,p_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1836: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1837: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1838: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
1839: ,p_last_name_diff VARCHAR2 DEFAULT 'N'
1840: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1841: ,p_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE

Line 1838: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE

1834: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1835: ,p_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
1836: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1837: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1838: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
1839: ,p_last_name_diff VARCHAR2 DEFAULT 'N'
1840: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1841: ,p_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1842: ,p_transaction_id hr_api_transactions.transaction_id%type

Line 1840: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE

1836: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1837: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1838: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
1839: ,p_last_name_diff VARCHAR2 DEFAULT 'N'
1840: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1841: ,p_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1842: ,p_transaction_id hr_api_transactions.transaction_id%type
1843: ,p_person_id VARCHAR2
1844: ,p_transaction_type VARCHAR2

Line 1841: ,p_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE

1837: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
1838: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
1839: ,p_last_name_diff VARCHAR2 DEFAULT 'N'
1840: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1841: ,p_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1842: ,p_transaction_id hr_api_transactions.transaction_id%type
1843: ,p_person_id VARCHAR2
1844: ,p_transaction_type VARCHAR2
1845: ,p_source_name VARCHAR2

Line 1867: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;

1863: ln_business_group_id per_people_f.business_group_id%TYPE;
1864: ln_parent_audit_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
1865: ln_assignment_id per_assignments_f.assignment_id%TYPE;
1866: ln_gre_id hr_organization_units.organization_id%TYPE;
1867: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
1868: ln_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
1869: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1870: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1871: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

Line 1869: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

1865: ln_assignment_id per_assignments_f.assignment_id%TYPE;
1866: ln_gre_id hr_organization_units.organization_id%TYPE;
1867: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
1868: ln_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
1869: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1870: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1871: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
1872: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1873: lv_state_filing_status_code pay_us_emp_state_tax_rules_f.filing_status_code%TYPE;

Line 1870: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

1866: ln_gre_id hr_organization_units.organization_id%TYPE;
1867: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
1868: ln_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
1869: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1870: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1871: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
1872: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1873: lv_state_filing_status_code pay_us_emp_state_tax_rules_f.filing_status_code%TYPE;
1874: cu_state_filing_status_code pay_us_emp_state_tax_rules_f.filing_status_code%TYPE;

Line 1871: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

1867: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
1868: ln_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
1869: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1870: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1871: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
1872: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1873: lv_state_filing_status_code pay_us_emp_state_tax_rules_f.filing_status_code%TYPE;
1874: cu_state_filing_status_code pay_us_emp_state_tax_rules_f.filing_status_code%TYPE;
1875: cu_state_wa pay_us_emp_state_tax_rules_f.withholding_allowances%TYPE;

Line 1872: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;

1868: ln_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
1869: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1870: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
1871: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
1872: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
1873: lv_state_filing_status_code pay_us_emp_state_tax_rules_f.filing_status_code%TYPE;
1874: cu_state_filing_status_code pay_us_emp_state_tax_rules_f.filing_status_code%TYPE;
1875: cu_state_wa pay_us_emp_state_tax_rules_f.withholding_allowances%TYPE;
1876: cu_sit_exempt pay_us_emp_state_tax_rules_f.sit_exempt%TYPE;

Line 1936: from pay_us_emp_fed_tax_rules_f ftr, per_assignments_f paf,

1932: decode(ftr.fit_exempt,'Y',1,0),
1933: decode(ftr.futa_tax_exempt,'Y',1,0),
1934: decode(ftr.medicare_tax_exempt,'Y',1,0),
1935: decode(ftr.ss_tax_exempt,'Y',1,0)
1936: from pay_us_emp_fed_tax_rules_f ftr, per_assignments_f paf,
1937: hr_soft_coding_keyflex hsck
1938: where paf.person_id = ln_person_id
1939: and paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
1940: and paf.assignment_id = ftr.assignment_id

Line 1960: from pay_us_emp_fed_tax_rules_f ftr

1956: decode(ftr.fit_exempt,'Y',1,0) fit_exempt_count,
1957: decode(ftr.futa_tax_exempt,'Y',1,0) futa_tax_exempt_count,
1958: decode(ftr.medicare_tax_exempt,'Y',1,0) medicare_tax_exempt_count,
1959: decode(ftr.ss_tax_exempt,'Y',1,0) ss_tax_exempt_count
1960: from pay_us_emp_fed_tax_rules_f ftr
1961: ,per_assignments_f paf
1962: ,hr_soft_coding_keyflex hsck
1963: where paf.person_id = ln_person_id
1964: and paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id

Line 2796: l_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;

2792: l_number_value hr_api_transaction_values.number_value%type;
2793:
2794: l_filing_status hr_api_transaction_values.varchar2_value%type;
2795:
2796: l_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
2797:
2798: l_allowances hr_api_transaction_values.number_value%type;
2799: l_add_tax hr_api_transaction_values.number_value%type;
2800: l_exempt hr_api_transaction_values.varchar2_value%type;

Line 2802: l_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;

2798: l_allowances hr_api_transaction_values.number_value%type;
2799: l_add_tax hr_api_transaction_values.number_value%type;
2800: l_exempt hr_api_transaction_values.varchar2_value%type;
2801:
2802: l_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
2803: l_org_allowances hr_api_transaction_values.number_value%type;
2804: l_org_exempt hr_api_transaction_values.varchar2_value%type;
2805: l_last_name_diff hr_api_transaction_values.varchar2_value%TYPE;
2806: