APPS.EAM_PN_EXTRACTION_PUB dependencies on DUAL

Line 11: from dual

7: l_asset_exists varchar2(1) := 'N';
8: begin
9:
10: select 'Y' into l_asset_exists
11: from dual
12: where exists
13: ( select * from csi_item_instances
14: where pn_location_id = p_location_id
15: and nvl(active_start_date, sysdate-1) < sysdate

Line 117: select 'Y' into l_parent_exists_in_eam from dual

113: x_insert_mode := 1;
114: x_insert_status := 4;
115:
116: begin
117: select 'Y' into l_parent_exists_in_eam from dual
118: where exists
119: (select * from csi_item_instances where
120: pn_location_id = p_parent_location_id);
121:

Line 134: select 'Y' into l_hr_exists from dual

130: x_insert_mode := 1;
131: x_insert_status := 4;
132: else
133: begin
134: select 'Y' into l_hr_exists from dual
135: where exists
136: (select * from mtl_object_genealogy
137: where object_id = l_gen_object_id);
138: exception