APPS.PAY_US_EMP_TAX_RULES_PKG dependencies on PAY_STATE_RULES

Line 907: PAY_STATE_RULES psr

903: pa.region_1,
904: pa.postal_code
905: from PER_ASSIGNMENTS_F paf,
906: PER_ADDRESSES pa,
907: PAY_STATE_RULES psr
908: where paf.assignment_id = P_assignment_id
909: and P_session_date between paf.effective_start_date and
910: paf.effective_end_date
911: and paf.person_id = pa.person_id

Line 930: PAY_STATE_RULES psr

926: hl.town_or_city,
927: hl.town_or_city
928: from PER_ASSIGNMENTS_F paf,
929: HR_LOCATIONS hl,
930: PAY_STATE_RULES psr
931: where paf.assignment_id = P_assignment_id
932: and P_session_date between paf.effective_start_date and
933: paf.effective_end_date
934: and paf.location_id = hl.location_id

Line 1106: from pay_state_rules

1102: l_allowances number;
1103: --
1104: CURSOR csr_get_jurisdiction is
1105: select jurisdiction_code
1106: from pay_state_rules
1107: where state_code = P_state_code;
1108:
1109: -- This cursor gets the filing status and exemptions from the federal record
1110: -- if needed

Line 1114: from hr_lookups hl, -- pay_state_rules(table in def. of view pay_emp_fed_tax_v1)

1110: -- if needed
1111:
1112: CURSOR csr_filing_status is
1113: select hl.lookup_code, peft.withholding_allowances -- Bug 3354046: Table pay_us_states is added to remove 2 MJC and FTS on table
1114: from hr_lookups hl, -- pay_state_rules(table in def. of view pay_emp_fed_tax_v1)
1115: pay_emp_fed_tax_v1 peft,
1116: pay_us_states pus
1117: where hl.lookup_type = 'US_FS_'||substr(p_jurisdiction,1,2)
1118: and upper(hl.meaning) = decode(

Line 1128: CURSOR csr_fed_or_def is -- Bug 3354046: Index has been forced on table pay_state_rules to remove FTS and

1124: and pus.state_code = substr(peft.sui_jurisdiction_code,1,2)
1125: and pus.state_abbrev = peft.sui_state_code
1126: and pus.state_name = peft.sui_state_name;
1127: --
1128: CURSOR csr_fed_or_def is -- Bug 3354046: Index has been forced on table pay_state_rules to remove FTS and
1129: select /*+ index (sr PAY_STATE_RULES_PK) -- MJC.
1130: ordered */hoi.org_information12
1131: from per_assignments_f paf,
1132: hr_soft_coding_keyflex hsck,

Line 1129: select /*+ index (sr PAY_STATE_RULES_PK) -- MJC.

1125: and pus.state_abbrev = peft.sui_state_code
1126: and pus.state_name = peft.sui_state_name;
1127: --
1128: CURSOR csr_fed_or_def is -- Bug 3354046: Index has been forced on table pay_state_rules to remove FTS and
1129: select /*+ index (sr PAY_STATE_RULES_PK) -- MJC.
1130: ordered */hoi.org_information12
1131: from per_assignments_f paf,
1132: hr_soft_coding_keyflex hsck,
1133: hr_organization_information hoi ,

Line 1134: pay_state_rules sr

1130: ordered */hoi.org_information12
1131: from per_assignments_f paf,
1132: hr_soft_coding_keyflex hsck,
1133: hr_organization_information hoi ,
1134: pay_state_rules sr
1135: where paf.assignment_id = p_assignment_id
1136: and SR.state_code = hoi.org_information1
1137: and hoi.organization_id = hsck.segment1
1138: and hoi.org_information_context = 'State Tax Rules'

Line 1149: hr_utility.set_message_token('LOOKUP_TYPE ','pay_state_rules');

1145: OPEN csr_get_jurisdiction;
1146: FETCH csr_get_jurisdiction into P_jurisdiction;
1147: IF csr_get_jurisdiction%NOTFOUND then
1148: hr_utility.set_message(801,'HR_6091_DEF_MISSING_LOOKUPS');
1149: hr_utility.set_message_token('LOOKUP_TYPE ','pay_state_rules');
1150: hr_utility.raise_error;
1151: end if;
1152: CLOSE csr_get_jurisdiction;
1153: hr_utility.set_location('pay_us_emp_tax_rules_pkg.ins_def_state',1.3);

Line 2360: PAY_STATE_RULES psr

2356: hl.postal_code,
2357: hl.town_or_city
2358: from PER_ASSIGNMENTS_F paf,
2359: HR_LOCATIONS hl,
2360: PAY_STATE_RULES psr
2361: where paf.assignment_id = P_assignment_id
2362: and P_date between paf.effective_start_date and
2363: paf.effective_end_date
2364: and paf.location_id = hl.location_id