DBA Data[Home] [Help]

APPS.HR_US_OSHA dependencies on DUAL

Line 57: from sys.dual

53: l_dummy varchar2(1);
54: --
55: cursor c1 is
56: select null
57: from sys.dual
58: where exists (select null
59: from per_analysis_criteria pac,
60: fnd_id_flex_structures fif
61: where pac.id_flex_num = fif.id_flex_num

Line 76: from sys.dual;

72: begin
73: --
74: select per_osha_case_number_s.nextval
75: into v_case_number
76: from sys.dual;
77: --
78: -- If the value is taken then use the max value + sequence, that will be
79: -- unique, otherwise use the sequence number to fill in some of the gaps.
80: -- Gradually using this technique we would be able to fill in all the

Line 80: -- Gradually using this technique we would be able to fill in all the

76: from sys.dual;
77: --
78: -- If the value is taken then use the max value + sequence, that will be
79: -- unique, otherwise use the sequence number to fill in some of the gaps.
80: -- Gradually using this technique we would be able to fill in all the
81: -- gaps.
82: --
83: open c1;
84: --