APPS.FLM_KANBAN_PURGE dependencies on DUAL

Line 140: FROM DUAL

136: retcode := G_SUCCESS;
137:
138: SELECT count(*)
139: INTO l_records_found
140: FROM DUAL
141: WHERE EXISTS (
142: SELECT 1
143: FROM BOM_INVENTORY_COMPONENTS BIC,
144: BOM_BILL_OF_MATERIALS BBM

Line 160: FROM DUAL

156: l_stmt_num := 320;
157:
158: SELECT count(*)
159: INTO l_records_found
160: FROM DUAL
161: WHERE EXISTS (
162: SELECT 1
163: FROM BOM_INVENTORY_COMPONENTS BIC,
164: BOM_BILL_OF_MATERIALS BBM

Line 173: FROM DUAL

169:
170: if (l_records_found > 0) then
171: SELECT COUNT(*)
172: into l_records_found
173: FROM DUAL
174: WHERE EXISTS
175: ( SELECT 1
176: FROM MTL_SYSTEM_ITEMS
177: WHERE organization_id = arg_org_id

Line 192: FROM DUAL

188: l_stmt_num := 330;
189:
190: SELECT COUNT(*)
191: into l_records_found
192: FROM DUAL
193: WHERE EXISTS
194: ( SELECT 1
195: FROM MTL_KANBAN_PULL_SEQUENCES
196: WHERE organization_id = arg_org_id

Line 212: FROM DUAL

208: l_stmt_num := 340;
209:
210: SELECT COUNT(*)
211: into l_records_found
212: FROM DUAL
213: WHERE EXISTS
214: ( SELECT 1
215: FROM MTL_KANBAN_CARDS
216: WHERE organization_id = arg_org_id