DBA Data[Home] [Help]

APPS.FEM_LOADER_ENG_UTIL_PKG dependencies on FEM_PL_REQUESTS

Line 338: FROM fem_pl_requests r,

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

Line 490: FROM fem_pl_requests r,

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