APPS.PAY_JP_REPORT_PKG dependencies on DUAL

Line 65: from dual;

61: delete_session_date;
62:
63: insert into fnd_sessions(session_id,effective_date)
64: select userenv('sessionid'),trunc(p_effective_date)
65: from dual;
66: END INSERT_SESSION_DATE;
67:
68: --------------------------------------------------------------
69: -- DELETE_SESSION_DATE --

Line 1481: FROM dual

1477: --
1478: CURSOR cel_hi_dependent_exists
1479: IS
1480: SELECT 'Y'
1481: FROM dual
1482: WHERE EXISTS(
1483: SELECT /*+ ORDERED */
1484: NULL
1485: FROM per_contact_relationships pcr,

Line 3384: from dual;

3380: --
3381: cursor jp_era_date
3382: is
3383: select to_char(p_date,p_format,'nls_calendar=''Japanese Imperial''')
3384: from dual;
3385: --
3386: begin
3387: --
3388: open jp_era_date;