DBA Data[Home] [Help]

APPS.PAY_CA_YEER_PKG dependencies on FND_LOOKUP_VALUES

Line 3060: fnd_lookup_values flv

3056: flv.meaning,
3057: 'CAEOY_RL1_NONBOX_FOOTNOTE'
3058: from pay_action_information pai,
3059: fnd_lookup_types flt,
3060: fnd_lookup_values flv
3061: where pai.action_context_id = cp_asgact_id
3062: and pai.action_context_type = 'AAP'
3063: and pai.jurisdiction_code = 'QC'
3064: and pai.action_information_category = 'CA FOOTNOTES'

Line 3496: fnd_lookup_values flv

3492: flv.meaning,
3493: 'CAEOY_T4A_NONBOX_FOOTNOTE'
3494: from pay_action_information pai,
3495: fnd_lookup_types flt,
3496: fnd_lookup_values flv
3497: where pai.action_context_id = cp_asgact_id
3498: and pai.action_context_type = 'AAP'
3499: and pai.action_information_category = 'CA FOOTNOTES'
3500: and pai.action_information6 = 'T4A'

Line 3727: fnd_lookup_values flv

3723: select flv.lookup_code,
3724: flv.meaning,
3725: flv.description
3726: from fnd_lookup_types flt,
3727: fnd_lookup_values flv
3728: where flt.lookup_type = 'PAY_CA_EOY_EXCEPTIONS'
3729: and flv.lookup_type = flt.lookup_type
3730: and flv.language = userenv('LANG');
3731: