APPS.GCS_TRANSLATION_PKG dependencies on GCS_DIMENSION_TEMPLATES

Line 348: FROM GCS_DIMENSION_TEMPLATES

344: line_item_id, project_id, customer_id, task_id, user_dim1_id,
345: user_dim2_id, user_dim3_id, user_dim4_id, user_dim5_id,
346: user_dim6_id, user_dim7_id, user_dim8_id, user_dim9_id,
347: user_dim10_id
348: FROM GCS_DIMENSION_TEMPLATES
349: WHERE hierarchy_id = c_hierarchy_id
350: AND template_code = 'RE';
351:
352: -- Used to get the minimum accountable unit for the currency given.

Line 406: FROM gcs_dimension_templates

402:
403: -- Bugfix 5707630: Cursor returns the line item id slected for retained earnings on hierarchy page.
404: CURSOR re_line_item_cur (p_hier_id NUMBER) IS
405: SELECT line_item_id
406: FROM gcs_dimension_templates
407: WHERE hierarchy_id = p_hier_id
408: AND template_code = 'RE';
409:
410:

Line 633: 'FROM GCS_DIMENSION_TEMPLATES' || g_nl ||

629: 'natural_account_id, channel_id, line_item_id, project_id, customer_id, ' ||
630: 'task_id, user_dim1_id, user_dim2_id, user_dim3_id, user_dim4_id, ' ||
631: 'user_dim5_id, user_dim6_id, user_dim7_id, user_dim8_id, user_dim9_id, ' ||
632: 'user_dim10_id' || g_nl ||
633: 'FROM GCS_DIMENSION_TEMPLATES' || g_nl ||
634: 'WHERE hierarchy_id = ' || x_hierarchy_id || g_nl ||
635: 'AND template_code = ''RE''');
636:
637: -- Get the retained earnings template.