DBA Data[Home] [Help]

APPS.PAY_INS_CUSTOM_TEMPLATE dependencies on FND_COMMON_LOOKUP_TYPES

Line 141: lv_lookup_type_meaning fnd_common_lookup_types.lookup_type_meaning%TYPE;

137: ln_definition_id pay_report_definitions.report_definition_id%TYPE;
138: ln_style_sheet_id pay_report_category_components.style_sheet_variable_id%TYPE;
139: ln_report_variable_id pay_report_variables.report_variable_id%TYPE;
140: pn_report_variable_id pay_report_variables.report_variable_id%TYPE;
141: lv_lookup_type_meaning fnd_common_lookup_types.lookup_type_meaning%TYPE;
142: pn_report_category_comp_id pay_report_category_components.report_category_comp_id%TYPE;
143:
144: BEGIN
145:

Line 167: FROM fnd_common_lookup_types

163: END;
164:
165: BEGIN
166: SELECT lookup_type_meaning INTO lv_lookup_type_meaning
167: FROM fnd_common_lookup_types
168: WHERE lookup_type = p_lookup_type_name;
169: fnd_file.put_line(fnd_file.log,'+---------------------------------------------------------------------------+');
170: fnd_file.put_line(fnd_file.log,'New Category Name : ' || lv_lookup_type_meaning);
171: EXCEPTION