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
343: AND r.exec_mode_code = G_SNAPSHOT
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
495: AND r.output_dataset_code = p_dataset_code