APPS.PAY_INS_CUSTOM_TEMPLATE dependencies on DUAL

Line 168: FROM DUAL;

164: fnd_file.put_line(fnd_file.log,'Report Category Not Found : Please Contact Your Support Representative');
165: END;
166:
167: SELECT pay_report_categories_s.nextval INTO ln_report_category_id_new
168: FROM DUAL;
169: fnd_file.put_line(fnd_file.log,'New Category Id : ' || ln_report_category_id_new);
170: fnd_file.put_line(fnd_file.log,'+---------------------------------------------------------------------------+');
171:
172: OPEN csr_get_temp_codes(p_lookup_type_name);

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

387: l_proc_name := 'INSERT_REPORT_VARIABLE';
388: hr_utility.trace('Entering '||l_proc_name);
389: hr_utility.trace('Inserting report variable '|| p_name);
390:
391: SELECT pay_report_variables_s.nextval INTO p_report_variable_id FROM DUAL;
392:
393: IF DEBUG_MODE THEN
394: dbms_output.put_line('INSERT INTO pay_report_variables(report_variable_id,report_definition_id,definition_type,name,value,legislation_code,business_group_id) ' ||
395: 'VALUES(' ||p_report_variable_id||','||p_report_definition_id||','||p_definition_type||','||p_name||','||p_value||','||NULL||','||p_business_group_id||')');

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

429: l_proc_name := 'INSERT_REPORT_CATEGORY_COMPONENT';
430: hr_utility.trace('Entering '||l_proc_name);
431: hr_utility.trace('Deleting report category component.');
432:
433: SELECT pay_report_category_comp_s.nextval INTO p_report_category_comp_id FROM DUAL;
434:
435: hr_utility.trace('Inserting report category component.');
436:
437: IF DEBUG_MODE THEN