[Home] [Help]
103: fem_ledgers_b flb,
104: gcs_entities_attr gea,
105: gcs_data_type_codes_b gdtcb,
106: fem_datasets_attr fda,
107: fem_cal_periods_attr fcpa
108: WHERE gdsd.load_id = p_load_id
109: AND gdsd.entity_id = feb.entity_id
110: AND feb.entity_id = gea.entity_id
111: AND gea.data_type_code = gdsd.balance_type_code
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
410: AND fodb.object_id = p_datasub_info.balances_rule_id
533: gdsd.status_code,
534: gdsd.balances_rule_id
535: FROM gcs_data_sub_dtls gdsd,
536: gcs_entities_attr gea,
537: fem_cal_periods_attr fcpa
538: WHERE gdsd.associated_request_id = FND_GLOBAL.CONC_REQUEST_ID
539: AND gea.entity_id <> p_datasub_info.entity_id
540: AND gea.balances_rule_id = gdsd.balances_rule_id
541: AND gea.data_type_code = gdsd.balance_type_code
2011: l_period_end_date,
2012: l_period_num
2013: FROM fem_cal_periods_b fcpb,
2014: fem_dimension_grps_b fdgb,
2015: fem_cal_periods_attr fcpa_end_date,
2016: fem_cal_periods_attr fcpa_period_num
2017: WHERE fcpb.cal_period_id = l_datasub_info.cal_period_id
2018: AND fcpb.dimension_group_id = fdgb.dimension_group_id
2019: AND fcpb.cal_period_id = fcpa_end_date.cal_period_id
2012: l_period_num
2013: FROM fem_cal_periods_b fcpb,
2014: fem_dimension_grps_b fdgb,
2015: fem_cal_periods_attr fcpa_end_date,
2016: fem_cal_periods_attr fcpa_period_num
2017: WHERE fcpb.cal_period_id = l_datasub_info.cal_period_id
2018: AND fcpb.dimension_group_id = fdgb.dimension_group_id
2019: AND fcpb.cal_period_id = fcpa_end_date.cal_period_id
2020: AND fcpa_end_date.attribute_id = l_period_end_date_attr
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
2469: AND fibr.bal_rule_obj_id = fodb.object_id
2470: AND fibrd.bal_rule_obj_def_id = l_bal_rule_version_id
2547: SELECT gea.entity_id BULK COLLECT
2548: INTO l_entity_list
2549: FROM gcs_entities_attr gea,
2550: fem_entities_b feb,
2551: fem_cal_periods_attr fcpa
2552: WHERE gea.balances_rule_id = l_bal_rule_id
2553: AND gea.source_system_code = 10
2554: AND gea.data_type_code = 'ACTUAL'
2555: AND gea.entity_id = feb.entity_id
2835: fem_cctr_orgs_attr fcoa,
2836: gcs_entity_cctr_orgs geco,
2837: gcs_entities_attr gea,
2838: fem_entities_b feb,
2839: fem_cal_periods_attr fcpa
2840: WHERE feb.entity_id = gea.entity_id
2841: AND geco.entity_id = gea.entity_id
2842: AND geco.company_cost_center_org_id = fcoa.company_cost_center_org_id
2843: AND fcoh.hierarchy_obj_def_id = l_hier_obj_definition_id
3370: gdsd.most_recent_flag
3371: BULK COLLECT INTO l_load_list
3372: FROM gcs_entities_attr gea,
3373: gcs_data_sub_dtls gdsd,
3374: fem_cal_periods_attr fcpa
3375: WHERE gea.ledger_id = l_ledger_id
3376: AND gdsd.cal_period_id = l_cal_period_id
3377: AND gdsd.balance_type_code IN ('ACTUAL', 'ADB')
3378: AND gdsd.balance_type_code = gea.data_type_code
3389: gdsd.most_recent_flag
3390: BULK COLLECT INTO l_load_list
3391: FROM gcs_entities_attr gea,
3392: gcs_data_sub_dtls gdsd,
3393: fem_cal_periods_attr fcpa
3394: WHERE gea.ledger_id = l_ledger_id
3395: AND gdsd.cal_period_id = l_cal_period_id
3396: AND gdsd.balance_type_code = l_data_type_code
3397: AND gdsd.balance_type_code = gea.data_type_code