APPS.GCS_DATA_PREP_PKG dependencies on GCS_DATA_SUB_DTLS

Line 130: FROM gcs_data_sub_dtls gdsd, fem_cal_periods_b fcpb

126: END IF;
127:
128: SELECT gdsd.cal_period_id, fcpb.calendar_id, fcpb.dimension_group_id
129: INTO l_src_cal_period_id, l_src_calendar_id, l_src_dimension_grp_id
130: FROM gcs_data_sub_dtls gdsd, fem_cal_periods_b fcpb
131: WHERE gdsd.entity_id = p_entity_id
132: AND gdsd.balance_type_code = p_balance_type_code
133: AND gdsd.cal_period_id = fcpb.cal_period_id
134: AND ROWNUM < 2;

Line 156: --no data found in gcs_data_sub_dtls..calendar period mapping is not required

152: END IF;
153:
154: EXCEPTION
155: WHEN OTHERS THEN
156: --no data found in gcs_data_sub_dtls..calendar period mapping is not required
157: p_period_mapping_required := 'N';
158: END;
159:
160: -- Bugfix 6037112: Added check to see if data preparation is required

Line 1315: gcs_data_sub_dtls gdsd ';

1311: FROM fem_balances fb,
1312: fem_ledgers_attr fla,
1313: gcs_entity_cctr_orgs geco,
1314: gcs_cons_impact_analyses gcia,
1315: gcs_data_sub_dtls gdsd ';
1316: l_where_gt_clause := '
1317: WHERE l_periods_list(counter) = fb.cal_period_id
1318: AND fb.source_system_code = l_source_system_code
1319: AND fb.ledger_id = p_source_ledger_id