APPS.GL_CRM_UTILITIES_PKG dependencies on GL_CROSS_RATE_RULES

Line 269: FROM gl_cross_rate_rules

265: x_pivot_currency VARCHAR2(15);
266: BEGIN
267: SELECT pivot_currency
268: INTO x_pivot_currency
269: FROM gl_cross_rate_rules
270: WHERE conversion_type = p_conversion_type;
271:
272: SELECT DISTINCT from_currency
273: BULK COLLECT INTO existed_curr_rec.r_from_curr

Line 322: FROM gl_cross_rate_rules

318: x_pivot_currency VARCHAR2(15);
319: BEGIN
320: SELECT pivot_currency
321: INTO x_pivot_currency
322: FROM gl_cross_rate_rules
323: WHERE conversion_type = p_conversion_type;
324:
325: UPDATE gl_cross_rate_rule_dtls
326: SET from_currency = p_new_contra_currency,

Line 1200: gl_cross_rate_rules gcrs

1196: WHERE mode_flag IN('I', 'D', 'T', 'N')
1197: AND user_conversion_type IN(
1198: SELECT user_conversion_type
1199: FROM gl_daily_conversion_types gct,
1200: gl_cross_rate_rules gcrs
1201: WHERE gct.conversion_type = gcrs.conversion_type)
1202: AND rownum < 2;
1203:
1204: IF DEBUG_MODE THEN

Line 1222: gl_cross_rate_rules gcrs

1218: WHERE mode_flag IN('I', 'D', 'T', 'N')
1219: AND user_conversion_type NOT IN(
1220: SELECT user_conversion_type
1221: FROM gl_daily_conversion_types gct,
1222: gl_cross_rate_rules gcrs
1223: WHERE gct.conversion_type = gcrs.conversion_type);
1224:
1225: gl_message.func_ent('Cross Rates Calculation');
1226:

Line 1265: gl_cross_rate_rules glcrs,

1261: DECODE(gldri.mode_flag, 'D', 'D', 'I'),
1262: gldri.used_for_ab_translation
1263: FROM gl_daily_rates_interface gldri,
1264: gl_daily_conversion_types gldct,
1265: gl_cross_rate_rules glcrs,
1266: gl_cross_rate_rule_dtls glcrsd
1267: WHERE gldri.mode_flag IN('I', 'D', 'T', 'N')
1268: AND gldri.user_conversion_type = gldct.user_conversion_type
1269: AND gldct.conversion_type = glcrs.conversion_type