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.

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 698: pay_us_emp_state_tax_rules_f.sit_override_amount%TYPE

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

Line 764: pay_us_emp_state_tax_rules_f.sit_override_rate%TYPE

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

Line 830: pay_us_emp_state_tax_rules_f.remainder_percent%TYPE

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

Line 895: ,p_secondary_wa in pay_us_emp_state_tax_rules_f.secondary_wa%TYPE

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

Line 961: pay_us_emp_state_tax_rules_f.withholding_allowances%TYPE

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

Line 1027: pay_us_emp_state_tax_rules_f.sui_wage_base_override_amount%TYPE

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

Line 1093: pay_us_emp_state_tax_rules_f.supp_tax_override_rate%TYPE

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

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

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

Line 1882: pay_us_emp_state_tax_rules_f b

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