APPS.PAY_US_EMP_DT_TAX_RULES dependencies on FND_LOOKUP_VALUES

Line 5276: from FND_LOOKUP_VALUES

5272: */
5273:
5274: cursor csr_filing_status is
5275: select lookup_code
5276: from FND_LOOKUP_VALUES
5277: where lookup_type = 'US_FIT_FILING_STATUS'
5278: and upper(meaning) = 'SINGLE'
5279: and language = 'US';
5280:

Line 5291: from fnd_lookup_values

5287: */
5288:
5289: CURSOR csr_eic_fstatus is
5290: select lookup_code
5291: from fnd_lookup_values
5292: where lookup_type = 'US_EIC_FILING_STATUS'
5293: and upper(meaning) = 'NO EIC'
5294: and language = 'US';
5295:

Line 5477: from FND_LOOKUP_VALUES flv

5473: and peft.assignment_id = p_assignment ;
5474: */
5475: cursor csr_filing_status(p_assignment number, p_state varchar2) is
5476: select flv.lookup_code, peft.withholding_allowances
5477: from FND_LOOKUP_VALUES flv
5478: , PAY_US_EMP_FED_TAX_RULES_V peft
5479: where flv.lookup_type = 'US_FS_'||p_state
5480: and upper(flv.meaning) = decode(
5481: upper(substr(peft.filing_status,1,7)),

Line 5712: from FND_LOOKUP_VALUES

5708: */
5709:
5710: cursor csr_filing_status is
5711: select lookup_code
5712: from FND_LOOKUP_VALUES
5713: where lookup_type = 'US_LIT_FILING_STATUS'
5714: and upper(meaning) = 'SINGLE'
5715: and language = 'US';
5716:

Line 5883: from FND_LOOKUP_VALUES

5879: */
5880:
5881: cursor csr_filing_status is
5882: select lookup_code
5883: from FND_LOOKUP_VALUES
5884: where lookup_type = 'US_LIT_FILING_STATUS'
5885: and upper(meaning) = 'SINGLE'
5886: and language = 'US';
5887: