DBA Data[Home] [Help]

APPS.PAY_US_EMP_TAX_RULES_PKG dependencies on HR_LOOKUPS

Line 1015: from hr_lookups

1011: P_id number;
1012: --
1013: CURSOR csr_filing_status is
1014: select lookup_code
1015: from hr_lookups
1016: where lookup_type = 'US_FIT_FILING_STATUS'
1017: and upper(meaning) = 'SINGLE';
1018: --
1019: CURSOR csr_eic_fstatus is

Line 1021: from hr_lookups

1017: and upper(meaning) = 'SINGLE';
1018: --
1019: CURSOR csr_eic_fstatus is
1020: select lookup_code
1021: from hr_lookups
1022: where lookup_type = 'US_EIC_FILING_STATUS'
1023: and upper(meaning) = 'NO EIC';
1024: --
1025:

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 1251: from hr_lookups

1247:
1248:
1249: CURSOR csr_filing_status is
1250: select lookup_code
1251: from hr_lookups
1252: where lookup_type = 'US_LIT_FILING_STATUS'
1253: and upper(meaning) = 'SINGLE';
1254: --
1255: CURSOR csr_get_county_sd IS