eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_STA_BUS dependencies on PAY_US_EMP_STATE_TAX_RULES_F

Line 39: ,p_state_code in pay_us_emp_state_tax_rules_f.state_code%TYPE

35: -- Internal table handler use only.
36: --
37: Procedure chk_state_code
38: (p_emp_state_tax_rule_id in number
39: ,p_state_code in pay_us_emp_state_tax_rules_f.state_code%TYPE
40: ) is
41: --
42: l_proc varchar2(72) := g_package||'chk_state_code';
43: l_dummy varchar2(1);

Line 77: pay_sta_shd.constraint_error('PAY_US_EMP_STATE_TAX_RULES_FK1');

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

Line 123: pay_us_emp_state_tax_rules_f.assignment_id%TYPE

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

Line 125: pay_us_emp_state_tax_rules_f.business_group_id%TYPE

121: (p_emp_state_tax_rule_id in number
122: ,p_assignment_id in
123: pay_us_emp_state_tax_rules_f.assignment_id%TYPE
124: ,p_business_group_id in
125: pay_us_emp_state_tax_rules_f.business_group_id%TYPE
126: ,p_effective_date in date
127: ,p_object_version_number in number
128: ) is
129: --

Line 253: pay_us_emp_state_tax_rules_f.sit_optional_calc_ind%TYPE

249: --
250: Procedure chk_sit_optional_calc_ind
251: (p_emp_state_tax_rule_id in number
252: ,p_sit_optional_calc_ind in
253: pay_us_emp_state_tax_rules_f.sit_optional_calc_ind%TYPE
254: ,p_effective_date in date
255: ,p_object_version_number in number
256: ) is
257: --

Line 265: pay_us_emp_state_tax_rules_f str

261: --
262: cursor csr_get_state_abbrev is
263: select state_abbrev
264: from pay_us_states pus,
265: pay_us_emp_state_tax_rules_f str
266: where pus.state_code = str.state_code
267: and str.emp_state_tax_rule_id = p_emp_state_tax_rule_id;
268:
269: --

Line 308: pay_sta_shd.constraint_error('PAY_US_EMP_STATE_TAX_RULES_FK1');

304: -- table. Existence of state tax record was checked in a
305: -- previous step.
306: --
307:
308: pay_sta_shd.constraint_error('PAY_US_EMP_STATE_TAX_RULES_FK1');
309:
310: end If;
311: close csr_get_state_abbrev;
312: if hr_api.not_exists_in_hr_lookups

Line 360: pay_us_emp_state_tax_rules_f.jurisdiction_code%TYPE

356: --
357: Procedure chk_jurisdiction_code
358: (p_emp_state_tax_rule_id in number
359: ,p_jurisdiction_code in
360: pay_us_emp_state_tax_rules_f.jurisdiction_code%TYPE
361: ,p_state_code in pay_us_emp_state_tax_rules_f.state_code%TYPE
362: ) is
363: --
364: l_proc varchar2(72) := g_package||'chk_jurisdiction_code';

Line 361: ,p_state_code in pay_us_emp_state_tax_rules_f.state_code%TYPE

357: Procedure chk_jurisdiction_code
358: (p_emp_state_tax_rule_id in number
359: ,p_jurisdiction_code in
360: pay_us_emp_state_tax_rules_f.jurisdiction_code%TYPE
361: ,p_state_code in pay_us_emp_state_tax_rules_f.state_code%TYPE
362: ) is
363: --
364: l_proc varchar2(72) := g_package||'chk_jurisdiction_code';
365: l_dummy varchar2(1);

Line 447: pay_us_emp_state_tax_rules_f.additional_wa_amount%TYPE

443: --
444: Procedure chk_additional_wa_amount
445: (p_emp_state_tax_rule_id in number
446: ,p_additional_wa_amount in
447: pay_us_emp_state_tax_rules_f.additional_wa_amount%TYPE
448: ) is
449: --
450: l_proc varchar2(72) := g_package||'chk_additional_wa_amount';
451: --

Line 516: ,p_state_code in pay_us_emp_state_tax_rules_f.state_code%TYPE

512: -- Internal table handler use only.
513: --
514: Procedure chk_filing_status_code
515: (p_emp_state_tax_rule_id in number
516: ,p_state_code in pay_us_emp_state_tax_rules_f.state_code%TYPE
517: ,p_filing_status_code in
518: pay_us_emp_state_tax_rules_f.filing_status_code%TYPE
519: ,p_effective_date in date
520: ,p_validation_start_date in date

Line 518: pay_us_emp_state_tax_rules_f.filing_status_code%TYPE

514: Procedure chk_filing_status_code
515: (p_emp_state_tax_rule_id in number
516: ,p_state_code in pay_us_emp_state_tax_rules_f.state_code%TYPE
517: ,p_filing_status_code in
518: pay_us_emp_state_tax_rules_f.filing_status_code%TYPE
519: ,p_effective_date in date
520: ,p_validation_start_date in date
521: ,p_validation_end_date in date
522: ) is

Line 526: l_filing_status_code pay_us_emp_state_tax_rules_f.filing_status_code%TYPE;

522: ) is
523: --
524: l_proc varchar2(72) := g_package||'chk_filing_status_code';
525: l_fs_lookup_type pay_state_rules.fs_lookup_type%TYPE;
526: l_filing_status_code pay_us_emp_state_tax_rules_f.filing_status_code%TYPE;
527: --
528: cursor c1 is
529: select psr.fs_lookup_type
530: from pay_us_states pus, pay_state_rules psr

Line 632: pay_us_emp_state_tax_rules_f.sit_additional_tax%TYPE

628: --
629: Procedure chk_sit_additional_tax
630: (p_emp_state_tax_rule_id in number
631: ,p_sit_additional_tax in
632: pay_us_emp_state_tax_rules_f.sit_additional_tax%TYPE
633: ) is
634: --
635: l_proc varchar2(72) := g_package||'chk_sit_additional_tax';
636: --

Line 701: pay_us_emp_state_tax_rules_f.sit_override_amount%TYPE

697: --
698: Procedure chk_sit_override_amount
699: (p_emp_state_tax_rule_id in number
700: ,p_sit_override_amount in
701: pay_us_emp_state_tax_rules_f.sit_override_amount%TYPE
702: ) is
703: --
704: l_proc varchar2(72) := g_package||'chk_sit_override_amount';
705: --

Line 767: pay_us_emp_state_tax_rules_f.sit_override_rate%TYPE

763: --
764: Procedure chk_sit_override_rate
765: (p_emp_state_tax_rule_id in number
766: ,p_sit_override_rate in
767: pay_us_emp_state_tax_rules_f.sit_override_rate%TYPE
768: ) is
769: --
770: l_proc varchar2(72) := g_package||'chk_sit_override_rate';
771: --

Line 833: pay_us_emp_state_tax_rules_f.remainder_percent%TYPE

829: --
830: Procedure chk_remainder_percent
831: (p_emp_state_tax_rule_id in number
832: ,p_remainder_percent in
833: pay_us_emp_state_tax_rules_f.remainder_percent%TYPE
834: ) is
835: --
836: l_proc varchar2(72) := g_package||'chk_remainder_percent';
837: --

Line 898: ,p_secondary_wa in pay_us_emp_state_tax_rules_f.secondary_wa%TYPE

894: -- Internal table handler use only.
895: --
896: Procedure chk_secondary_wa
897: (p_emp_state_tax_rule_id in number
898: ,p_secondary_wa in pay_us_emp_state_tax_rules_f.secondary_wa%TYPE
899: ) is
900: --
901: l_proc varchar2(72) := g_package||'chk_secondary_wa';
902: --

Line 964: pay_us_emp_state_tax_rules_f.withholding_allowances%TYPE

960: --
961: Procedure chk_withholding_allowances
962: (p_emp_state_tax_rule_id in number
963: ,p_withholding_allowances in
964: pay_us_emp_state_tax_rules_f.withholding_allowances%TYPE
965: ) is
966: --
967: l_proc varchar2(72) := g_package||'chk_withholding_allowances';
968: --

Line 1030: pay_us_emp_state_tax_rules_f.sui_wage_base_override_amount%TYPE

1026: --
1027: Procedure chk_sui_wage_base_override_amo
1028: (p_emp_state_tax_rule_id in number
1029: ,p_sui_wage_base_override_amo in
1030: pay_us_emp_state_tax_rules_f.sui_wage_base_override_amount%TYPE
1031: ) is
1032: --
1033: l_proc varchar2(72) := g_package||'chk_sui_wage_base_override_amo';
1034: --

Line 1096: pay_us_emp_state_tax_rules_f.supp_tax_override_rate%TYPE

1092: --
1093: Procedure chk_supp_tax_override_rate
1094: (p_emp_state_tax_rule_id in number
1095: ,p_supp_tax_override_rate in
1096: pay_us_emp_state_tax_rules_f.supp_tax_override_rate%TYPE
1097: ) is
1098: --
1099: l_proc varchar2(72) := g_package||'chk_supp_tax_override_rate';
1100: --

Line 1235: -- Tax rules may be deleted from pay_us_emp_state_tax_rules_f when the

1231: -- |------------------------------< chk_delete >------------------------------|
1232: -- ----------------------------------------------------------------------------
1233: --
1234: -- Description
1235: -- Tax rules may be deleted from pay_us_emp_state_tax_rules_f when the
1236: -- following conditions are met:
1237: -- - no payroll has been run for this state
1238: -- - the state is not assigned to a work location
1239: -- - the state is not assigned to a primary resident address

Line 1885: pay_us_emp_state_tax_rules_f b

1881: --
1882: cursor csr_leg_code is
1883: select a.legislation_code
1884: from per_business_groups a,
1885: pay_us_emp_state_tax_rules_f b
1886: where b.emp_state_tax_rule_id = p_emp_state_tax_rule_id
1887: and a.business_group_id = b.business_group_id;
1888: --
1889: -- Declare local variables