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_US_TAX_API dependencies on PAY_US_EMP_CITY_TAX_RULES_F

Line 66: state_code pay_us_emp_city_tax_rules_f.state_code%TYPE,

62: -- Declare types, cursors and local variables
63: --
64: TYPE gen_rec is RECORD
65: (
66: state_code pay_us_emp_city_tax_rules_f.state_code%TYPE,
67: county_code pay_us_emp_city_tax_rules_f.state_code%TYPE,
68: city_code pay_us_emp_city_tax_rules_f.state_code%TYPE,
69: object_version_number number
70: );

Line 67: county_code pay_us_emp_city_tax_rules_f.state_code%TYPE,

63: --
64: TYPE gen_rec is RECORD
65: (
66: state_code pay_us_emp_city_tax_rules_f.state_code%TYPE,
67: county_code pay_us_emp_city_tax_rules_f.state_code%TYPE,
68: city_code pay_us_emp_city_tax_rules_f.state_code%TYPE,
69: object_version_number number
70: );
71: --

Line 68: city_code pay_us_emp_city_tax_rules_f.state_code%TYPE,

64: TYPE gen_rec is RECORD
65: (
66: state_code pay_us_emp_city_tax_rules_f.state_code%TYPE,
67: county_code pay_us_emp_city_tax_rules_f.state_code%TYPE,
68: city_code pay_us_emp_city_tax_rules_f.state_code%TYPE,
69: object_version_number number
70: );
71: --
72: --

Line 79: from pay_us_emp_city_tax_rules_f

75: --
76: Cursor get_city_tax_rule_id(l_jurisdiction varchar2) is
77: select emp_city_tax_rule_id, object_version_number,
78: effective_start_date, effective_end_date
79: from pay_us_emp_city_tax_rules_f
80: where assignment_id = p_assignment_id
81: and jurisdiction_code = l_jurisdiction
82: and p_effective_date between effective_start_date
83: and effective_end_date;

Line 114: from pay_us_emp_city_tax_rules_f

110: --
111: cursor csr_city_parm_sel is
112: select state_code, county_code,
113: city_code, object_version_number
114: from pay_us_emp_city_tax_rules_f
115: where assignment_id = p_assignment_id
116: and state_code = p_state_code
117: and county_code = p_county_code
118: and (city_code <> '0000'

Line 168: pay_us_emp_city_tax_rules_f.object_version_number%TYPE;

164:
165: l_proc varchar2(72) := g_package||'delete_tax_rule';
166: l_jurisdiction_code pay_us_emp_state_tax_rules.jurisdiction_code%TYPE;
167: l_object_version_number
168: pay_us_emp_city_tax_rules_f.object_version_number%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

Line 169: l_effective_start_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;

165: l_proc varchar2(72) := g_package||'delete_tax_rule';
166: l_jurisdiction_code pay_us_emp_state_tax_rules.jurisdiction_code%TYPE;
167: l_object_version_number
168: pay_us_emp_city_tax_rules_f.object_version_number%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;

Line 170: l_effective_end_date pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;

166: l_jurisdiction_code pay_us_emp_state_tax_rules.jurisdiction_code%TYPE;
167: l_object_version_number
168: pay_us_emp_city_tax_rules_f.object_version_number%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

Line 171: l_emp_city_tax_rule_id pay_us_emp_city_tax_rules_f.emp_city_tax_rule_id%TYPE;

167: l_object_version_number
168: pay_us_emp_city_tax_rules_f.object_version_number%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;

Line 177: t_effective_start_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;

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;
178: l_effective_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
179: l_vertex_exist number;
180: l_delete_jurisdiction number;
181: l_parm_sel varchar2(2000);

Line 178: l_effective_date pay_us_emp_city_tax_rules_f.effective_start_date%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;
178: l_effective_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
179: l_vertex_exist number;
180: l_delete_jurisdiction number;
181: l_parm_sel varchar2(2000);
182: l_jurisdiction_rec gen_rec;

Line 278: hr_utility.set_message_token('table', 'pay_us_emp_city_tax_rules_f');

274: );
275: else
276: close get_city_tax_rule_id;
277: hr_utility.set_message(801, 'HR_7182_DT_NO_MIN_MAX_ROWS');
278: hr_utility.set_message_token('table', 'pay_us_emp_city_tax_rules_f');
279: hr_utility.set_message_token('step','45');
280: hr_utility.raise_error;
281: end if;
282: elsif l_delete_jurisdiction = COUNTY_JURISDICTION then