DBA Data[Home] [Help]

APPS.PAY_CA_YEER_PKG dependencies on FND_LOOKUP_TYPES

Line 3059: fnd_lookup_types flt,

3055: select pai.action_information5,
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'

Line 3495: fnd_lookup_types flt,

3491: select pai.action_information5,
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'

Line 3726: from fnd_lookup_types flt,

3722: cursor cur_lkup is
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');