DBA Data[Home] [Help]

APPS.PAY_CA_WF_PKG dependencies on FND_LOOKUP_VALUES

Line 922: from fnd_lookup_values flv, fnd_lookup_types flt

918: between effective_start_date and effective_end_date;
919:
920: cursor cur_reg_dimension is
921: select flv.meaning
922: from fnd_lookup_values flv, fnd_lookup_types flt
923: where flv.lookup_code = p_reg_reporting_dim
924: and flt.lookup_type = 'CA_DIMENSION'
925: and flt.application_id = 800
926: and flt.lookup_type = flv.lookup_type;

Line 3051: from fnd_lookup_values flv, fnd_lookup_types flt

3047: between effective_start_date and effective_end_date;
3048:
3049: cursor cur_reg_dimension is
3050: select flv.meaning
3051: from fnd_lookup_values flv, fnd_lookup_types flt
3052: where flv.lookup_code = p_reg_reporting_dim
3053: and flt.lookup_type = 'CA_DIMENSION'
3054: and flt.application_id = 800
3055: and flt.lookup_type = flv.lookup_type;