334: -- See if the XGL Loader has loaded data successfully in Snapshot mode
335: -- for the given cal period, ledger and dataset.
336: SELECT COUNT(*)
337: INTO v_count
338: FROM fem_pl_requests r,
339: fem_pl_object_executions o
340: WHERE r.cal_period_id = p_cal_period_id
341: AND r.ledger_id = p_ledger_id
342: AND r.output_dataset_code = p_dataset_code
486: -- See if the Fact Data Loader has already processed at least one row
487: -- for the given cal period, ledger, dataset, source system and table.
488: SELECT COUNT(*)
489: INTO v_count
490: FROM fem_pl_requests r,
491: fem_pl_object_executions o,
492: fem_pl_tables t
493: WHERE r.cal_period_id = p_cal_period_id
494: AND r.ledger_id = p_ledger_id