DBA Data[Home] [Help]

APPS.PAY_US_EMP_TAX_RULES_PKG dependencies on PAY_EMP_FED_TAX_V1

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 1115: pay_emp_fed_tax_v1 peft,

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(
1119: upper(substr(peft.filing_status,1,7)),