DBA Data[Home] [Help]

APPS.GCS_DATASUB_WF_PKG dependencies on FEM_OBJECT_DEFINITION_B

Line 405: fem_object_definition_b fodb,

401: l_cal_period_end_date,
402: l_cal_period_name
403: FROM fem_intg_bal_rule_defs fibrd,
404: fem_intg_bal_rules fibr,
405: fem_object_definition_b fodb,
406: fem_cal_periods_attr fcpa,
407: fem_cal_periods_vl fcpv
408: WHERE fibrd.bal_rule_obj_def_id = fodb.object_definition_id
409: AND fibr.bal_rule_obj_id = fodb.object_id

Line 628: fem_object_definition_b fodb

624: fodb.object_definition_id
625: INTO l_hier_obj_id,
626: l_hier_obj_definition_id
627: FROM fem_xdim_dimensions fxd,
628: fem_object_definition_b fodb
629: WHERE fxd.dimension_id = 8
630: AND fxd.default_mvs_hierarchy_obj_id = fodb.object_id
631: AND l_cal_period_end_date BETWEEN fodb.effective_start_date AND
632: fodb.effective_end_date;

Line 2464: fem_object_definition_b fodb,

2460: l_avg_bal_flag,
2461: l_cal_period_end_date
2462: FROM fem_intg_bal_rule_defs fibrd,
2463: fem_intg_bal_rules fibr,
2464: fem_object_definition_b fodb,
2465: gl_sets_of_books gsob,
2466: fem_cal_periods_attr fcpa
2467: WHERE gsob.set_of_books_id = fibr.ledger_id
2468: AND fibrd.bal_rule_obj_def_id = fodb.object_definition_id

Line 2814: fem_object_definition_b fodb

2810: BEGIN
2811: SELECT fodb.object_definition_id
2812: INTO l_hier_obj_definition_id
2813: FROM fem_xdim_dimensions fxd,
2814: fem_object_definition_b fodb
2815: WHERE fxd.dimension_id = 8
2816: AND fxd.default_mvs_hierarchy_obj_id = fodb.object_id
2817: AND l_cal_period_end_date BETWEEN fodb.effective_start_date AND
2818: fodb.effective_end_date;