APPS.PAY_SE_TRNA_ARCHIVE dependencies on DUAL

Line 225: FROM dual;

221: p_sort_order := lr_parameter_info.sort_order;
222:
223: SELECT decode (lr_parameter_info.emp_catg, 'B', 'BC', 'W', 'WC', NULL)
224: INTO p_emp_catg
225: FROM dual;
226:
227: IF g_debug THEN
228: hr_utility.set_location (' Leaving Procedure GET_ALL_PARAMETERS', 30);
229: END IF;

Line 368: p_sql := 'select 1 from dual where to_char(:payroll_action_id) = dummy';

364: END IF;
365: EXCEPTION
366: WHEN OTHERS THEN
367: -- Return cursor that selects no rows
368: p_sql := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
369: END range_code;
370: /* ASSIGNMENT ACTION CODE */
371: PROCEDURE assignment_action_code (
372: p_payroll_action_id IN NUMBER,

Line 571: FROM dual;

567: END IF;
568:
569: SELECT pay_assignment_actions_s.NEXTVAL
570: INTO l_actid
571: FROM dual;
572:
573: --
574: g_index_assact := g_index_assact + 1;
575: g_lock_table (g_index_assact).archive_assact_id := l_actid;