APPS.HRI_OPL_SPRTN_RSNS dependencies on DUAL

Line 64: FROM dual

60: AND hrl.lookup_type = 'LEAV_REAS'
61: UNION ALL
62: SELECT 'NA_EDW' lookup_code,
63: 'N' exists_flag
64: FROM dual
65: WHERE NOT EXISTS
66: (SELECT -1
67: FROM hri_inv_sprtn_rsns spr
68: WHERE spr.reason = 'NA_EDW')

Line 72: FROM dual

68: WHERE spr.reason = 'NA_EDW')
69: UNION ALL
70: SELECT 'NA_EDW' lookup_code,
71: 'Y' exists_flag
72: FROM dual
73: WHERE EXISTS
74: (SELECT -1
75: FROM hri_inv_sprtn_rsns spr
76: WHERE spr.reason = 'NA_EDW');

Line 218: dual;

214: , l_user
215: , l_user
216: , l_sysdate
217: FROM
218: dual;
219: --
220: COMMIT;
221: --
222: dbg('exiting load_sprtn_rsns_shared_hrms');