APPS.PAY_FED_BUS dependencies on PAY_US_EMP_FED_TAX_RULES_F

Line 37: ,p_sui_state_code in pay_us_emp_fed_tax_rules_f.sui_state_code%TYPE

33: -- Internal table handler use only.
34: --
35: Procedure chk_sui_state_code
36: (p_emp_fed_tax_rule_id in number
37: ,p_sui_state_code in pay_us_emp_fed_tax_rules_f.sui_state_code%TYPE
38: ) is
39: --
40: l_proc varchar2(72) := g_package||'chk_sui_state_code';
41: l_dummy varchar2(1);

Line 77: pay_fed_shd.constraint_error('PAY_US_EMP_FED_TAX_RULES_FK1');

73: close csr_state_code;
74: --
75: -- raise error as FK does not relate to PK in pay_us_states table.
76: --
77: pay_fed_shd.constraint_error('PAY_US_EMP_FED_TAX_RULES_FK1');
78: --
79: end if;
80: --
81: close csr_state_code;

Line 121: ,p_assignment_id in pay_us_emp_fed_tax_rules_f.assignment_id%TYPE

117: -- Internal table handler use only.
118: --
119: Procedure chk_assignment_id
120: (p_emp_fed_tax_rule_id in number
121: ,p_assignment_id in pay_us_emp_fed_tax_rules_f.assignment_id%TYPE
122: ,p_business_group_id in
123: pay_us_emp_fed_tax_rules_f.business_group_id%TYPE
124: ,p_object_version_number in number
125: ,p_effective_date in date

Line 123: pay_us_emp_fed_tax_rules_f.business_group_id%TYPE

119: Procedure chk_assignment_id
120: (p_emp_fed_tax_rule_id in number
121: ,p_assignment_id in pay_us_emp_fed_tax_rules_f.assignment_id%TYPE
122: ,p_business_group_id in
123: pay_us_emp_fed_tax_rules_f.business_group_id%TYPE
124: ,p_object_version_number in number
125: ,p_effective_date in date
126: ) is
127: --

Line 234: pay_us_emp_fed_tax_rules_f.sui_jurisdiction_code%TYPE

230: --
231: Procedure chk_sui_jurisdiction_code
232: (p_emp_fed_tax_rule_id in number
233: ,p_sui_jurisdiction_code in
234: pay_us_emp_fed_tax_rules_f.sui_jurisdiction_code%TYPE
235: ,p_sui_state_code in pay_us_emp_fed_tax_rules_f.sui_state_code%TYPE
236: ) is
237: --
238: l_proc varchar2(72) := g_package||'chk_sui_jurisdiction_code';

Line 235: ,p_sui_state_code in pay_us_emp_fed_tax_rules_f.sui_state_code%TYPE

231: Procedure chk_sui_jurisdiction_code
232: (p_emp_fed_tax_rule_id in number
233: ,p_sui_jurisdiction_code in
234: pay_us_emp_fed_tax_rules_f.sui_jurisdiction_code%TYPE
235: ,p_sui_state_code in pay_us_emp_fed_tax_rules_f.sui_state_code%TYPE
236: ) is
237: --
238: l_proc varchar2(72) := g_package||'chk_sui_jurisdiction_code';
239: l_dummy varchar2(1);

Line 324: pay_us_emp_fed_tax_rules_f.additional_wa_amount%TYPE

320: --
321: Procedure chk_additional_wa_amount
322: (p_emp_fed_tax_rule_id in number
323: ,p_additional_wa_amount in
324: pay_us_emp_fed_tax_rules_f.additional_wa_amount%TYPE
325: ) is
326: --
327: l_proc varchar2(72) := g_package||'chk_additional_wa_amount';
328: --

Line 393: pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE

389: --
390: Procedure chk_filing_status_code
391: (p_emp_fed_tax_rule_id in number
392: ,p_filing_status_code in
393: pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
394: ,p_effective_date in date
395: ,p_validation_start_date in date
396: ,p_validation_end_date in date
397: ) is

Line 479: pay_us_emp_fed_tax_rules_f.fit_override_amount%TYPE

475: --
476: Procedure chk_fit_override_amount
477: (p_emp_fed_tax_rule_id in number
478: ,p_fit_override_amount in
479: pay_us_emp_fed_tax_rules_f.fit_override_amount%TYPE
480: ) is
481: --
482: l_proc varchar2(72) := g_package||'chk_fit_override_amount';
483: --

Line 545: pay_us_emp_fed_tax_rules_f.fit_override_rate%TYPE

541: --
542: Procedure chk_fit_override_rate
543: (p_emp_fed_tax_rule_id in number
544: ,p_fit_override_rate in
545: pay_us_emp_fed_tax_rules_f.fit_override_rate%TYPE
546: ) is
547: --
548: l_proc varchar2(72) := g_package||'chk_fit_override_rate';
549: --

Line 611: pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE

607: --
608: Procedure chk_withholding_allowances
609: (p_emp_fed_tax_rule_id in number
610: ,p_withholding_allowances in
611: pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
612: ) is
613: --
614: l_proc varchar2(72) := g_package||'chk_withholding_allowances';
615: --

Line 680: pay_us_emp_fed_tax_rules_f.eic_filing_status_code%TYPE

676: --
677: Procedure chk_eic_filing_status_code
678: (p_emp_fed_tax_rule_id in number
679: ,p_eic_filing_status_code in
680: pay_us_emp_fed_tax_rules_f.eic_filing_status_code%TYPE
681: ,p_effective_date in date
682: ,p_validation_start_date in date
683: ,p_validation_end_date in date
684: ) is

Line 763: pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE

759: --
760: Procedure chk_fit_additional_tax
761: (p_emp_fed_tax_rule_id in number
762: ,p_fit_additional_tax in
763: pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
764: ) is
765: --
766: l_proc varchar2(72) := g_package||'chk_fit_additional_tax';
767: --

Line 829: pay_us_emp_fed_tax_rules_f.supp_tax_override_rate%TYPE

825: --
826: Procedure chk_supp_tax_override_rate
827: (p_emp_fed_tax_rule_id in number
828: ,p_supp_tax_override_rate in
829: pay_us_emp_fed_tax_rules_f.supp_tax_override_rate%TYPE
830: ) is
831: --
832: l_proc varchar2(72) := g_package||'chk_supp_tax_override_rate';
833: --

Line 874: -- Tax rules may be deleted from pay_us_emp_fed_tax_rules_f only when the

870: -- |------------------------------< chk_delete >------------------------------|
871: -- ----------------------------------------------------------------------------
872: --
873: -- Description
874: -- Tax rules may be deleted from pay_us_emp_fed_tax_rules_f only when the
875: -- assignment is being deleted.
876: --
877: -- Pre-Conditions
878: -- None

Line 1511: pay_us_emp_fed_tax_rules_f fed

1507: --
1508: cursor csr_leg_code is
1509: select bus.legislation_code
1510: from per_business_groups bus,
1511: pay_us_emp_fed_tax_rules_f fed
1512: where fed.emp_fed_tax_rule_id = p_emp_fed_tax_rule_id
1513: and bus.business_group_id = fed.business_group_id;
1514: --
1515: -- Declare local variables