APPS.PAY_DK_MIA_REPORT_PKG dependencies on DUAL

Line 14: p_sqlstr := 'SELECT 1 FROM dual WHERE to_char(:payroll_action_id) = dummy';

10: PROCEDURE range_cursor(p_payroll_action_id IN NUMBER,
11: p_sqlstr OUT NOCOPY VARCHAR2)
12: IS
13: BEGIN
14: p_sqlstr := 'SELECT 1 FROM dual WHERE to_char(:payroll_action_id) = dummy';
15: END range_cursor;
16:
17: -----------------------------------------------------------------------------
18: --ASSIGNMENT ACTION CODE

Line 388: SELECT '1' FROM dual

384: p_end_date varchar2,
385: p_termination_date varchar2) RETURN varchar2 as
386:
387: CURSOR csr_check_termination(p_start_date DATE,p_end_date DATE,p_termination_date DATE) is
388: SELECT '1' FROM dual
389: WHERE p_termination_date BETWEEN p_start_date AND p_end_date;
390:
391: l_start_date DATE;
392: l_end_date DATE;