APPS.PAY_JP_IWHT_ARCH_PKG dependencies on DUAL

Line 726: FROM dual;

722: --
723: CURSOR lcu_next_action_id
724: IS
725: SELECT pay_assignment_actions_s.NEXTVAL
726: FROM dual;
727: --
728: -- Local Variables
729: lc_procedure VARCHAR2(200);
730: lc_subject_yyyymm VARCHAR2(240);

Line 1115: FROM dual;

1111: IS
1112: SELECT TO_CHAR(p_start_date, 'EYY.MM.DD', 'NLS_CALENDAR=''Japanese Imperial''')
1113: ||' - '||
1114: TO_CHAR(p_end_date, 'EYY.MM.DD', 'NLS_CALENDAR=''Japanese Imperial''')
1115: FROM dual;
1116: --
1117: CURSOR lcu_prev_archive (p_assignment_id per_all_assignments_f.assignment_id%TYPE)
1118: IS
1119: SELECT 'Y'