APPS.PAY_INS_CUSTOM_TEMPLATE dependencies on DUAL

Line 177: FROM DUAL;

173: fnd_file.put_line(fnd_file.log,'Report Category Not Found : Please Contact Your Support Representative');
174: END;
175:
176: SELECT pay_report_categories_s.nextval INTO ln_report_category_id_new
177: FROM DUAL;
178: fnd_file.put_line(fnd_file.log,'New Category Id : ' || ln_report_category_id_new);
179: fnd_file.put_line(fnd_file.log,'+---------------------------------------------------------------------------+');
180:
181: OPEN csr_get_temp_codes(p_lookup_type_name);

Line 400: SELECT pay_report_variables_s.nextval INTO p_report_variable_id FROM DUAL;

396: l_proc_name := 'INSERT_REPORT_VARIABLE';
397: hr_utility.trace('Entering '||l_proc_name);
398: hr_utility.trace('Inserting report variable '|| p_name);
399:
400: SELECT pay_report_variables_s.nextval INTO p_report_variable_id FROM DUAL;
401:
402: IF DEBUG_MODE THEN
403: hr_utility.trace('INSERT INTO pay_report_variables(report_variable_id,report_definition_id,definition_type,name,value,legislation_code,business_group_id) ' ||
404: 'VALUES(' ||p_report_variable_id||','||p_report_definition_id||','||p_definition_type||','||p_name||','||p_value||','||NULL||','||p_business_group_id||')');

Line 442: SELECT pay_report_category_comp_s.nextval INTO p_report_category_comp_id FROM DUAL;

438: l_proc_name := 'INSERT_REPORT_CATEGORY_COMPONENT';
439: hr_utility.trace('Entering '||l_proc_name);
440: hr_utility.trace('Deleting report category component.');
441:
442: SELECT pay_report_category_comp_s.nextval INTO p_report_category_comp_id FROM DUAL;
443:
444: hr_utility.trace('Inserting report category component.');
445:
446: IF DEBUG_MODE THEN