APPS.PAY_FED_BUS dependencies on PAY_US_STATES

Line 45: from pay_us_states pus

41: l_dummy varchar2(1);
42: --
43: cursor csr_state_code is
44: select null
45: from pay_us_states pus
46: where pus.state_code = p_sui_state_code;
47: --
48: Begin
49: --

Line 66: -- check if sui_state_code value exists in pay_us_states table

62: hr_utility.set_message(801, 'PAY_72797_FED_SUI_STA_NOT_NULL');
63: hr_utility.raise_error;
64: end if;
65: --
66: -- check if sui_state_code value exists in pay_us_states table
67: --
68: open csr_state_code;
69: --
70: fetch csr_state_code into l_dummy;

Line 75: -- raise error as FK does not relate to PK in pay_us_states table.

71: if csr_state_code%notfound then
72: --
73: close csr_state_code;
74: --
75: -- raise error as FK does not relate to PK in pay_us_states table.
76: --
77: pay_fed_shd.constraint_error('PAY_US_EMP_FED_TAX_RULES_FK1');
78: --
79: end if;

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: --