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_CNT_BUS dependencies on PAY_US_EMP_COUNTY_TAX_RULES_F

Line 49: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE

45: --
46: --
47: procedure chk_assignment_id
48: (p_emp_county_tax_rule_id in
49: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE
50: ,p_assignment_id in
51: pay_us_emp_county_tax_rules_f.assignment_id%TYPE
52: ,p_business_group_id in
53: pay_us_emp_county_tax_rules_f.business_group_id%TYPE

Line 51: pay_us_emp_county_tax_rules_f.assignment_id%TYPE

47: procedure chk_assignment_id
48: (p_emp_county_tax_rule_id in
49: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE
50: ,p_assignment_id in
51: pay_us_emp_county_tax_rules_f.assignment_id%TYPE
52: ,p_business_group_id in
53: pay_us_emp_county_tax_rules_f.business_group_id%TYPE
54: ,p_effective_date in date
55: ,p_object_version_number in number

Line 53: pay_us_emp_county_tax_rules_f.business_group_id%TYPE

49: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE
50: ,p_assignment_id in
51: pay_us_emp_county_tax_rules_f.assignment_id%TYPE
52: ,p_business_group_id in
53: pay_us_emp_county_tax_rules_f.business_group_id%TYPE
54: ,p_effective_date in date
55: ,p_object_version_number in number
56: )
57: is

Line 165: p_state_code in pay_us_emp_county_tax_rules_f.state_code%TYPE

161: --
162: --
163: procedure chk_state_code
164: (
165: p_state_code in pay_us_emp_county_tax_rules_f.state_code%TYPE
166: )
167: is
168: --
169: l_proc varchar2(72) := g_package||'chk_state_code';

Line 170: l_state_code pay_us_emp_county_tax_rules_f.state_code%TYPE;

166: )
167: is
168: --
169: l_proc varchar2(72) := g_package||'chk_state_code';
170: l_state_code pay_us_emp_county_tax_rules_f.state_code%TYPE;
171: --
172: --
173: cursor csr_valid_state_code is
174: select state_code

Line 193: (p_constraint_name => 'PAY_US_EMP_COUNTY_TAX_RULES_FK1');

189: fetch csr_valid_state_code into l_state_code;
190: if csr_valid_state_code%notfound then
191: close csr_valid_state_code;
192: pay_cnt_shd.constraint_error
193: (p_constraint_name => 'PAY_US_EMP_COUNTY_TAX_RULES_FK1');
194: end if;
195: else
196: hr_utility.set_message(801,'PAY_72774_CNT_STA_NOT_NULL');
197: hr_utility.raise_error;

Line 234: (p_county_code in pay_us_emp_county_tax_rules_f.county_code%TYPE

230: -- Internal Row Handler Use Only.
231: --
232: --
233: procedure chk_county_code
234: (p_county_code in pay_us_emp_county_tax_rules_f.county_code%TYPE
235: ,p_state_code in pay_us_emp_county_tax_rules_f.state_code%TYPE
236: )
237: is
238: --

Line 235: ,p_state_code in pay_us_emp_county_tax_rules_f.state_code%TYPE

231: --
232: --
233: procedure chk_county_code
234: (p_county_code in pay_us_emp_county_tax_rules_f.county_code%TYPE
235: ,p_state_code in pay_us_emp_county_tax_rules_f.state_code%TYPE
236: )
237: is
238: --
239: l_proc varchar2(72) := g_package||'chk_county_code';

Line 240: l_county_code pay_us_emp_county_tax_rules_f.county_code%TYPE;

236: )
237: is
238: --
239: l_proc varchar2(72) := g_package||'chk_county_code';
240: l_county_code pay_us_emp_county_tax_rules_f.county_code%TYPE;
241: --
242: --
243: cursor csr_valid_county_code is
244: select county_code

Line 313: ,p_county_code in pay_us_emp_county_tax_rules_f.county_code%TYPE

309: --
310: --
311: procedure chk_jurisdiction_code
312: (p_jurisdiction_code in pay_state_rules.jurisdiction_code%TYPE
313: ,p_county_code in pay_us_emp_county_tax_rules_f.county_code%TYPE
314: ,p_state_code in pay_us_emp_county_tax_rules_f.state_code%TYPE)
315: is
316: --
317: l_proc varchar2(72) := g_package||'chk_jurisdiction_code';

Line 314: ,p_state_code in pay_us_emp_county_tax_rules_f.state_code%TYPE)

310: --
311: procedure chk_jurisdiction_code
312: (p_jurisdiction_code in pay_state_rules.jurisdiction_code%TYPE
313: ,p_county_code in pay_us_emp_county_tax_rules_f.county_code%TYPE
314: ,p_state_code in pay_us_emp_county_tax_rules_f.state_code%TYPE)
315: is
316: --
317: l_proc varchar2(72) := g_package||'chk_jurisdiction_code';
318: l_jurisdiction_code pay_state_rules.jurisdiction_code%TYPE;

Line 386: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE

382: --
383: --
384: procedure chk_additional_wa_rate
385: (p_emp_county_tax_rule_id in
386: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE
387: ,p_additional_wa_rate in
388: pay_us_emp_county_tax_rules_f.additional_wa_rate%TYPE
389: )
390: is

Line 388: pay_us_emp_county_tax_rules_f.additional_wa_rate%TYPE

384: procedure chk_additional_wa_rate
385: (p_emp_county_tax_rule_id in
386: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE
387: ,p_additional_wa_rate in
388: pay_us_emp_county_tax_rules_f.additional_wa_rate%TYPE
389: )
390: is
391: --
392: l_proc varchar2(72) := g_package||'chk_additional_wa_rate';

Line 461: pay_us_emp_county_tax_rules_f.filing_status_code%TYPE,

457: --
458: procedure chk_filing_status_code
459: (p_emp_county_tax_rule_id in number,
460: p_filing_status_code in
461: pay_us_emp_county_tax_rules_f.filing_status_code%TYPE,
462: p_state_code in
463: pay_us_emp_county_tax_rules_f.state_code%TYPE,
464: p_effective_date in date,
465: p_validation_start_date in date,

Line 463: pay_us_emp_county_tax_rules_f.state_code%TYPE,

459: (p_emp_county_tax_rule_id in number,
460: p_filing_status_code in
461: pay_us_emp_county_tax_rules_f.filing_status_code%TYPE,
462: p_state_code in
463: pay_us_emp_county_tax_rules_f.state_code%TYPE,
464: p_effective_date in date,
465: p_validation_start_date in date,
466: p_validation_end_date in date,
467: p_object_version_number in number

Line 562: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE

558: --
559: --
560: procedure chk_lit_additional_tax
561: (p_emp_county_tax_rule_id in
562: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE
563: ,p_lit_additional_tax in
564: pay_us_emp_county_tax_rules_f.lit_additional_tax%TYPE
565: )
566: is

Line 564: pay_us_emp_county_tax_rules_f.lit_additional_tax%TYPE

560: procedure chk_lit_additional_tax
561: (p_emp_county_tax_rule_id in
562: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE
563: ,p_lit_additional_tax in
564: pay_us_emp_county_tax_rules_f.lit_additional_tax%TYPE
565: )
566: is
567: --
568: l_proc varchar2(72) := g_package||'chk_lit_additional_tax';

Line 629: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE

625: --
626: --
627: procedure chk_lit_override_amount
628: (p_emp_county_tax_rule_id in
629: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE
630: ,p_lit_override_amount in
631: pay_us_emp_county_tax_rules_f.lit_override_amount%TYPE
632: )
633: is

Line 631: pay_us_emp_county_tax_rules_f.lit_override_amount%TYPE

627: procedure chk_lit_override_amount
628: (p_emp_county_tax_rule_id in
629: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE
630: ,p_lit_override_amount in
631: pay_us_emp_county_tax_rules_f.lit_override_amount%TYPE
632: )
633: is
634: --
635: l_proc varchar2(72) := g_package||'chk_lit_override_amount';

Line 697: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE

693: --
694: --
695: procedure chk_lit_override_rate
696: (p_emp_county_tax_rule_id in
697: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE
698: ,p_lit_override_rate in
699: pay_us_emp_county_tax_rules_f.lit_override_rate%TYPE
700: )
701: is

Line 699: pay_us_emp_county_tax_rules_f.lit_override_rate%TYPE

695: procedure chk_lit_override_rate
696: (p_emp_county_tax_rule_id in
697: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE
698: ,p_lit_override_rate in
699: pay_us_emp_county_tax_rules_f.lit_override_rate%TYPE
700: )
701: is
702: --
703: l_proc varchar2(72) := g_package||'chk_lit_override_rate';

Line 765: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE

761: --
762: --
763: procedure chk_withholding_allowances
764: (p_emp_county_tax_rule_id in
765: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE
766: ,p_withholding_allowances in
767: pay_us_emp_county_tax_rules_f.withholding_allowances%TYPE
768: )
769: is

Line 767: pay_us_emp_county_tax_rules_f.withholding_allowances%TYPE

763: procedure chk_withholding_allowances
764: (p_emp_county_tax_rule_id in
765: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE
766: ,p_withholding_allowances in
767: pay_us_emp_county_tax_rules_f.withholding_allowances%TYPE
768: )
769: is
770: --
771: l_proc varchar2(72) := g_package||'chk_withholding_allowances';

Line 847: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE,

843: --
844: procedure chk_school_district_code
845: (
846: p_emp_county_tax_rule_id in
847: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE,
848: p_assignment_id in
849: pay_us_emp_county_tax_rules_f.assignment_id%TYPE,
850: p_school_district_code in
851: pay_us_emp_county_tax_rules_f.school_district_code%TYPE,

Line 849: pay_us_emp_county_tax_rules_f.assignment_id%TYPE,

845: (
846: p_emp_county_tax_rule_id in
847: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE,
848: p_assignment_id in
849: pay_us_emp_county_tax_rules_f.assignment_id%TYPE,
850: p_school_district_code in
851: pay_us_emp_county_tax_rules_f.school_district_code%TYPE,
852: p_state_code in
853: pay_us_emp_county_tax_rules_f.state_code%TYPE,

Line 851: pay_us_emp_county_tax_rules_f.school_district_code%TYPE,

847: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE,
848: p_assignment_id in
849: pay_us_emp_county_tax_rules_f.assignment_id%TYPE,
850: p_school_district_code in
851: pay_us_emp_county_tax_rules_f.school_district_code%TYPE,
852: p_state_code in
853: pay_us_emp_county_tax_rules_f.state_code%TYPE,
854: p_county_code in
855: pay_us_emp_county_tax_rules_f.county_code%TYPE,

Line 853: pay_us_emp_county_tax_rules_f.state_code%TYPE,

849: pay_us_emp_county_tax_rules_f.assignment_id%TYPE,
850: p_school_district_code in
851: pay_us_emp_county_tax_rules_f.school_district_code%TYPE,
852: p_state_code in
853: pay_us_emp_county_tax_rules_f.state_code%TYPE,
854: p_county_code in
855: pay_us_emp_county_tax_rules_f.county_code%TYPE,
856: p_effective_date in date,
857: p_validation_start_date in date,

Line 855: pay_us_emp_county_tax_rules_f.county_code%TYPE,

851: pay_us_emp_county_tax_rules_f.school_district_code%TYPE,
852: p_state_code in
853: pay_us_emp_county_tax_rules_f.state_code%TYPE,
854: p_county_code in
855: pay_us_emp_county_tax_rules_f.county_code%TYPE,
856: p_effective_date in date,
857: p_validation_start_date in date,
858: p_validation_end_date in date,
859: p_object_version_number in

Line 860: pay_us_emp_county_tax_rules_f.object_version_number%TYPE

856: p_effective_date in date,
857: p_validation_start_date in date,
858: p_validation_end_date in date,
859: p_object_version_number in
860: pay_us_emp_county_tax_rules_f.object_version_number%TYPE
861: )
862: is
863: --
864: l_proc varchar2(72) := g_package||'chk_school_district_code';

Line 866: pay_us_emp_county_tax_rules_f.school_district_code%TYPE;

862: is
863: --
864: l_proc varchar2(72) := g_package||'chk_school_district_code';
865: l_school_district_code
866: pay_us_emp_county_tax_rules_f.school_district_code%TYPE;
867: l_cty_schl_dist_code
868: pay_us_emp_city_tax_rules_f.school_district_code%TYPE;
869: l_cnt_schl_dist_code
870: pay_us_emp_county_tax_rules_f.school_district_code%TYPE;

Line 870: pay_us_emp_county_tax_rules_f.school_district_code%TYPE;

866: pay_us_emp_county_tax_rules_f.school_district_code%TYPE;
867: l_cty_schl_dist_code
868: pay_us_emp_city_tax_rules_f.school_district_code%TYPE;
869: l_cnt_schl_dist_code
870: pay_us_emp_county_tax_rules_f.school_district_code%TYPE;
871: l_api_updating boolean;
872: --
873: cursor csr_school_district_code (p_sta_code varchar2,
874: p_cnt_code varchar2,

Line 902: from pay_us_emp_county_tax_rules_f ctr

898: p_sta_code varchar2,
899: p_cnt_code varchar2,
900: p_tax_rules_id number) is
901: select school_district_code
902: from pay_us_emp_county_tax_rules_f ctr
903: where ctr.assignment_id = p_asg_id
904: and ctr.effective_end_date >= p_validation_start_date
905: and ctr.effective_start_date <= p_validation_end_date
906: and ctr.school_district_code is not null

Line 1089: -- Tax rules may be deleted from pay_us_emp_county_tax_rules_f when the

1085: -- ---------------------------------------------------------------------------
1086: --
1087: --
1088: -- Description:
1089: -- Tax rules may be deleted from pay_us_emp_county_tax_rules_f when the
1090: -- following conditions are met:
1091: -- - no payroll has been run for this county
1092: -- - the county is not assigned to a work location
1093: -- - the county is not assigned to a primary resident address

Line 1118: p_state_code in pay_us_emp_county_tax_rules_f.state_code%TYPE,

1114: --
1115: procedure chk_delete
1116: (p_effective_date in date,
1117: p_assignment_id in per_assignments_f.assignment_id%TYPE,
1118: p_state_code in pay_us_emp_county_tax_rules_f.state_code%TYPE,
1119: p_county_code in pay_us_emp_county_tax_rules_f.county_code%TYPE,
1120: p_delete_mode in varchar2,
1121: p_delete_routine in varchar2 default null
1122: )

Line 1119: p_county_code in pay_us_emp_county_tax_rules_f.county_code%TYPE,

1115: procedure chk_delete
1116: (p_effective_date in date,
1117: p_assignment_id in per_assignments_f.assignment_id%TYPE,
1118: p_state_code in pay_us_emp_county_tax_rules_f.state_code%TYPE,
1119: p_county_code in pay_us_emp_county_tax_rules_f.county_code%TYPE,
1120: p_delete_mode in varchar2,
1121: p_delete_routine in varchar2 default null
1122: )
1123: is

Line 1697: pay_us_emp_county_tax_rules_f b

1693: --
1694: cursor csr_leg_code is
1695: select a.legislation_code
1696: from per_business_groups a,
1697: pay_us_emp_county_tax_rules_f b
1698: where b.emp_county_tax_rule_id = p_emp_county_tax_rule_id
1699: and a.business_group_id = b.business_group_id;
1700: --
1701: -- Declare local variables