DBA Data[Home] [Help]

APPS.PAY_US_EMP_DT_TAX_RULES dependencies on FND_LOOKUP_VALUES

Line 5352: from FND_LOOKUP_VALUES

5348: */
5349:
5350: cursor csr_filing_status is
5351: select lookup_code
5352: from FND_LOOKUP_VALUES
5353: where lookup_type = 'US_FIT_FILING_STATUS'
5354: and upper(meaning) = 'SINGLE'
5355: and language = 'US';
5356:

Line 5367: from fnd_lookup_values

5363: */
5364:
5365: CURSOR csr_eic_fstatus is
5366: select lookup_code
5367: from fnd_lookup_values
5368: where lookup_type = 'US_EIC_FILING_STATUS'
5369: and upper(meaning) = 'NO EIC'
5370: and language = 'US';
5371:

Line 5553: from FND_LOOKUP_VALUES flv

5549: and peft.assignment_id = p_assignment ;
5550: */
5551: cursor csr_filing_status(p_assignment number, p_state varchar2) is
5552: select flv.lookup_code, peft.withholding_allowances
5553: from FND_LOOKUP_VALUES flv
5554: , PAY_US_EMP_FED_TAX_RULES_V peft
5555: where flv.lookup_type = 'US_FS_'||p_state
5556: and upper(flv.meaning) = decode(
5557: upper(substr(peft.filing_status,1,7)),

Line 5788: from FND_LOOKUP_VALUES

5784: */
5785:
5786: cursor csr_filing_status is
5787: select lookup_code
5788: from FND_LOOKUP_VALUES
5789: where lookup_type = 'US_LIT_FILING_STATUS'
5790: and upper(meaning) = 'SINGLE'
5791: and language = 'US';
5792:

Line 5959: from FND_LOOKUP_VALUES

5955: */
5956:
5957: cursor csr_filing_status is
5958: select lookup_code
5959: from FND_LOOKUP_VALUES
5960: where lookup_type = 'US_LIT_FILING_STATUS'
5961: and upper(meaning) = 'SINGLE'
5962: and language = 'US';
5963: