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 569: FROM dual;

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