DBA Data[Home] [Help]

APPS.PAY_CA_YEER_PKG dependencies on FND_LOOKUP_VALUES

Line 3429: fnd_lookup_values flv

3425: flv.meaning,
3426: 'CAEOY_RL1_NONBOX_FOOTNOTE'
3427: from pay_action_information pai,
3428: fnd_lookup_types flt,
3429: fnd_lookup_values flv
3430: where pai.action_context_id = cp_asgact_id
3431: and pai.action_context_type = 'AAP'
3432: and pai.jurisdiction_code = 'QC'
3433: and pai.action_information_category = 'CA FOOTNOTES'

Line 3988: fnd_lookup_values flv

3984: flv.meaning,
3985: 'CAEOY_T4A_NONBOX_FOOTNOTE'
3986: from pay_action_information pai,
3987: fnd_lookup_types flt,
3988: fnd_lookup_values flv
3989: where pai.action_context_id = cp_asgact_id
3990: and pai.action_context_type = 'AAP'
3991: and pai.action_information_category = 'CA FOOTNOTES'
3992: and pai.action_information6 = 'T4A'

Line 4284: fnd_lookup_values flv

4280: select flv.lookup_code,
4281: flv.meaning,
4282: flv.description
4283: from fnd_lookup_types flt,
4284: fnd_lookup_values flv
4285: where flt.lookup_type = 'PAY_CA_EOY_EXCEPTIONS'
4286: and flv.lookup_type = flt.lookup_type
4287: and flv.language = userenv('LANG');
4288: