APPS.GL_CRM_UTILITIES_PKG dependencies on GL_CROSS_RATE_RULES

Line 278: FROM gl_cross_rate_rules

274: x_pivot_currency VARCHAR2(15);
275: BEGIN
276: SELECT pivot_currency
277: INTO x_pivot_currency
278: FROM gl_cross_rate_rules
279: WHERE conversion_type = p_conversion_type;
280:
281: SELECT DISTINCT from_currency
282: BULK COLLECT INTO existed_curr_rec.r_from_curr

Line 331: FROM gl_cross_rate_rules

327: x_pivot_currency VARCHAR2(15);
328: BEGIN
329: SELECT pivot_currency
330: INTO x_pivot_currency
331: FROM gl_cross_rate_rules
332: WHERE conversion_type = p_conversion_type;
333:
334: UPDATE gl_cross_rate_rule_dtls
335: SET from_currency = p_new_contra_currency,

Line 1405: gl_cross_rate_rules gcrs

1401: WHERE mode_flag IN('I', 'D', 'T', 'N')
1402: AND user_conversion_type IN(
1403: SELECT user_conversion_type
1404: FROM gl_daily_conversion_types gct,
1405: gl_cross_rate_rules gcrs
1406: WHERE gct.conversion_type = gcrs.conversion_type)
1407: AND batch_number = l_batch_number
1408: AND rownum < 2;
1409:

Line 1429: gl_cross_rate_rules gcrs

1425: AND batch_number = l_batch_number
1426: AND user_conversion_type NOT IN(
1427: SELECT user_conversion_type
1428: FROM gl_daily_conversion_types gct,
1429: gl_cross_rate_rules gcrs
1430: WHERE gct.conversion_type = gcrs.conversion_type);
1431:
1432: gl_message.func_ent('Cross Rates Calculation');
1433:

Line 1472: gl_cross_rate_rules glcrs,

1468: DECODE(gldri.mode_flag, 'D', 'D', 'I'),
1469: gldri.used_for_ab_translation
1470: FROM gl_daily_rates_interface gldri,
1471: gl_daily_conversion_types gldct,
1472: gl_cross_rate_rules glcrs,
1473: gl_cross_rate_rule_dtls glcrsd
1474: WHERE gldri.mode_flag IN('I', 'D', 'T', 'N')
1475: AND gldri.user_conversion_type = gldct.user_conversion_type
1476: AND gldct.conversion_type = glcrs.conversion_type