APPS.PAY_STATE_TAX_RULE_API dependencies on PAY_US_STATES

Line 262: from pay_state_rules psr, pay_us_states pus

258: and asg.effective_end_date;
259: --
260: cursor csr_state_jd is
261: select psr.jurisdiction_code
262: from pay_state_rules psr, pay_us_states pus
263: where pus.state_code = p_state_code
264: and pus.state_abbrev = psr.state_code;
265: --
266: /* cursor csr_filing_status is

Line 295: from PAY_US_STATES pus,

291: and flv.enabled_flag='Y';
292: --
293: cursor csr_fed_or_def is
294: select hoi.org_information12
295: from PAY_US_STATES pus,
296: HR_ORGANIZATION_INFORMATION hoi,
297: PER_ASSIGNMENTS_F paf,
298: HR_SOFT_CODING_KEYFLEX hsck
299: where paf.assignment_id = p_assignment_id