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_FED_BUS dependencies on PAY_STATE_RULES

Line 211: -- This procedure validates the sui_jurisdiction_code against PAY_STATE_RULES

207: -- |------< chk_sui_jurisdiction_code >------|
208: -- ----------------------------------------------------------------------------
209: --
210: -- Description
211: -- This procedure validates the sui_jurisdiction_code against PAY_STATE_RULES
212: -- where the state is the same as the sui_state_code
213: --
214: -- Pre-Conditions
215: -- Valid sui_state_code

Line 243: from pay_us_states pus, pay_state_rules psr

239: l_dummy varchar2(1);
240: --
241: cursor csr_sui_jd is
242: select null
243: from pay_us_states pus, pay_state_rules psr
244: where pus.state_code = p_sui_state_code
245: and pus.state_abbrev = psr.state_code
246: and psr.jurisdiction_code = p_sui_jurisdiction_code;
247: --

Line 274: -- check if sui_jurisdiction_code value exists in pay_state_rules table

270: hr_utility.set_message(801, 'PAY_72796_FED_SUI_JD_NOT_NULL');
271: hr_utility.raise_error;
272: end if;
273: --
274: -- check if sui_jurisdiction_code value exists in pay_state_rules table
275: --
276: open csr_sui_jd;
277: --
278: fetch csr_sui_jd into l_dummy;

Line 283: -- raise error as code does not exist in pay_state_rules table.

279: if csr_sui_jd%notfound then
280: --
281: close csr_sui_jd;
282: --
283: -- raise error as code does not exist in pay_state_rules table.
284: --
285: hr_utility.set_message(801, 'PAY_8003_1099R_JU_CODE');
286: hr_utility.raise_error;
287: --