APPS.FEM_PL_INCR_PKG dependencies on FEM_OBJECT_CATALOG_B

Line 148: FROM fem_object_catalog_b

144: -- ----------------------------------------------------------------------
145:
146: SELECT object_type_code
147: INTO v_object_type
148: FROM fem_object_catalog_b
149: WHERE object_id = p_object_id;
150:
151: IF v_object_type = 'XGL_INTEGRATION' THEN
152: XGL_Obj_Exec_Lock_Exists

Line 372: fem_object_catalog_b c1

368: SELECT DISTINCT e.object_id, e.exec_object_definition_id
369: INTO v_precedent_obj_id, v_precedent_obj_def_id
370: FROM fem_pl_requests r,
371: fem_pl_object_executions e,
372: fem_object_catalog_b c1
373: WHERE r.ledger_id = p_ledger_id
374: AND r.cal_period_id = p_cal_period_id
375: AND r.output_dataset_code = p_dataset_code
376: AND e.request_id = r.request_id

Line 380: FROM fem_object_catalog_b c2

376: AND e.request_id = r.request_id
377: AND c1.object_id = e.object_id
378: AND c1.object_type_code =
379: (SELECT object_type_code
380: FROM fem_object_catalog_b c2
381: WHERE c2.object_id = p_object_id);
382:
383: EXCEPTION
384: WHEN NO_DATA_FOUND THEN

Line 946: fem_object_catalog_b o,

942: SELECT count(*)
943: INTO v_row_count
944: FROM fem_pl_requests r,
945: fem_pl_object_executions e,
946: fem_object_catalog_b o,
947: fem_cal_periods_attr a
948: WHERE r.ledger_id = p_ledger_id
949: AND r.output_dataset_code = p_dataset_code
950: AND r.exec_status_code = 'SUCCESS'