APPS.PAY_STA_BUS dependencies on PAY_US_STATES

Line 47: from pay_us_states a

43: l_dummy varchar2(1);
44: --
45: cursor c1 is
46: select null
47: from pay_us_states a
48: where a.state_code = p_state_code;
49: --
50: Begin
51: --

Line 65: -- check if state_code value exists in pay_us_states table

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

Line 74: -- raise error as FK does not relate to PK in pay_us_states

70: if c1%notfound then
71: --
72: close c1;
73: --
74: -- raise error as FK does not relate to PK in pay_us_states
75: -- table.
76: --
77: pay_sta_shd.constraint_error('PAY_US_EMP_STATE_TAX_RULES_FK1');
78: --

Line 260: lv_state_abbrev pay_us_states.state_abbrev%type;

256: ) is
257: --
258: l_proc varchar2(72) := g_package||'chk_sit_optional_calc_ind';
259: l_api_updating boolean;
260: lv_state_abbrev pay_us_states.state_abbrev%type;
261: --
262: cursor csr_get_state_abbrev is
263: select state_abbrev
264: from pay_us_states pus,

Line 264: from pay_us_states pus,

260: lv_state_abbrev pay_us_states.state_abbrev%type;
261: --
262: cursor csr_get_state_abbrev is
263: select state_abbrev
264: from pay_us_states pus,
265: pay_us_emp_state_tax_rules_f str
266: where pus.state_code = str.state_code
267: and str.emp_state_tax_rule_id = p_emp_state_tax_rule_id;
268:

Line 303: -- Raise error as FK does not relate to PK in pay_us_states

299: fetch csr_get_state_abbrev into lv_state_abbrev;
300: if csr_get_state_abbrev%notfound then
301: close csr_get_state_abbrev;
302: --
303: -- Raise error as FK does not relate to PK in pay_us_states
304: -- table. Existence of state tax record was checked in a
305: -- previous step.
306: --
307:

Line 369: from pay_us_states pus, pay_state_rules psr

365: l_dummy varchar2(1);
366: --
367: cursor c1 is
368: select null
369: from pay_us_states pus, pay_state_rules psr
370: where pus.state_code = p_state_code
371: and pus.state_abbrev = psr.state_code
372: and psr.jurisdiction_code = p_jurisdiction_code;
373: --

Line 530: from pay_us_states pus, pay_state_rules psr

526: l_filing_status_code pay_us_emp_state_tax_rules_f.filing_status_code%TYPE;
527: --
528: cursor c1 is
529: select psr.fs_lookup_type
530: from pay_us_states pus, pay_state_rules psr
531: where pus.state_code = p_state_code
532: and pus.state_abbrev = psr.state_code;
533: --
534: Begin

Line 1300: from pay_us_states pus

1296: where asg.assignment_id = pay_sta_shd.g_old_rec.assignment_id
1297: and hrl.location_id = asg.location_id
1298: and asg.effective_end_date > p_csr_tmp_date
1299: and exists (select null
1300: from pay_us_states pus
1301: where pus.state_abbrev = hrl.region_2
1302: and pus.state_code = pay_sta_shd.g_old_rec.state_code);
1303: --
1304: cursor csr_check_residence_loc(p_csr_tmp_date in date) is

Line 1313: from pay_us_states pus

1309: and pad.person_id = asg.person_id
1310: and pad.primary_flag = 'Y'
1311: and nvl(pad.date_to, hr_api.g_eot) > p_csr_tmp_date
1312: and exists (select null
1313: from pay_us_states pus
1314: where pus.state_abbrev = pad.region_2
1315: and pus.state_code = pay_sta_shd.g_old_rec.state_code);
1316: --
1317: -- Cursor to check for existing county tax rules