APPS.HR_JP_STANDARD_PKG dependencies on DUAL

Line 619: from dual;

615: if p_date is not null then
616: if p_date_format is not null then
617: select to_char(p_date, p_date_format, 'NLS_CALENDAR=''Japanese Imperial''')
618: into l_str
619: from dual;
620: else
621: select to_char(p_date, sys_context('USERENV', 'NLS_DATE_FORMAT'), 'NLS_CALENDAR=''Japanese Imperial''')
622: into l_str
623: from dual;

Line 623: from dual;

619: from dual;
620: else
621: select to_char(p_date, sys_context('USERENV', 'NLS_DATE_FORMAT'), 'NLS_CALENDAR=''Japanese Imperial''')
622: into l_str
623: from dual;
624: end if;
625: end if;
626: --
627: return l_str;

Line 646: from dual;

642: if p_str is not null then
643: if p_date_format is not null then
644: select to_date(p_str, p_date_format, 'NLS_CALENDAR=''Japanese Imperial''')
645: into l_date
646: from dual;
647: else
648: select to_date(p_str, sys_context('USERENV', 'NLS_DATE_FORMAT'), 'NLS_CALENDAR=''Japanese Imperial''')
649: into l_date
650: from dual;

Line 650: from dual;

646: from dual;
647: else
648: select to_date(p_str, sys_context('USERENV', 'NLS_DATE_FORMAT'), 'NLS_CALENDAR=''Japanese Imperial''')
649: into l_date
650: from dual;
651: end if;
652: end if;
653: --
654: return l_date;