DBA Data[Home] [Help]

APPS.PAY_US_TAX_API dependencies on PAY_US_EMP_COUNTY_TAX_RULES_F

Line 91: from pay_us_emp_county_tax_rules_f

87: --
88: Cursor get_county_tax_rule_id(l_jurisdiction varchar2) is
89: select emp_county_tax_rule_id, object_version_number,
90: effective_start_date, effective_end_date
91: from pay_us_emp_county_tax_rules_f
92: where assignment_id = p_assignment_id
93: and jurisdiction_code = l_jurisdiction
94: and p_effective_date between effective_start_date
95: and effective_end_date;

Line 129: from pay_us_emp_county_tax_rules_f

125: --
126: cursor csr_county_parm_sel is
127: select state_code, county_code,
128: '0000' city_code, object_version_number
129: from pay_us_emp_county_tax_rules_f
130: where assignment_id = p_assignment_id
131: and state_code = p_state_code
132: and (county_code <> '000'
133: and county_code is not null)

Line 173: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE;

169: l_effective_start_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
170: l_effective_end_date pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
171: l_emp_city_tax_rule_id pay_us_emp_city_tax_rules_f.emp_city_tax_rule_id%TYPE;
172: l_emp_county_tax_rule_id
173: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE;
174: l_emp_state_tax_rule_id
175: pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
176: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
177: t_effective_start_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;

Line 309: hr_utility.set_message_token('table', 'pay_us_emp_county_tax_rules_f');

305: );
306: else
307: close get_county_tax_rule_id;
308: hr_utility.set_message(801, 'HR_7182_DT_NO_MIN_MAX_ROWS');
309: hr_utility.set_message_token('table', 'pay_us_emp_county_tax_rules_f');
310: hr_utility.set_message_token('step','55');
311: hr_utility.raise_error;
312: end if;
313: elsif l_delete_jurisdiction = STATE_JURISDICTION then