DBA Data[Home] [Help]

APPS.GHG_ORGANIZATION_MAPPINGS_PKG dependencies on GHG_SEGMENT_MAPPINGS

Line 121: FROM GHG_SEGMENT_MAPPINGS;

117: v_map_segment27_flag,
118: v_map_segment28_flag,
119: v_map_segment29_flag,
120: v_map_segment30_flag
121: FROM GHG_SEGMENT_MAPPINGS;
122:
123: v_sqltext := 'SELECT xnfam.ghg_organization_id FROM gl_code_combinations gcc, GHG_ORG_ACCOUNT_MAPPINGS_V xnfam ';
124: v_sqltext := v_sqltext || 'WHERE gcc.code_combination_id = ' || x_code_combination_id || ' AND gcc.chart_of_accounts_id = ' || x_chart_of_accounts_id ;
125: v_sqltext := v_sqltext || ' AND ' || 'to_date(''' || to_char(x_gl_date, 'DD-MON-YYYY') || ''', ''DD-MON-YYYY'') BETWEEN NVL(xnfam.start_date, sysdate - 1) AND NVL(xnfam.end_date, sysdate + 1) ';