APPS.GCS_RULES_PROCESSOR dependencies on GL_DAILY_RATES

Line 4008: select --+ INDEX_DESC( r, GL_DAILY_RATES_U1 )

4004:
4005: entryId gcs_entry_headers.entry_id%TYPE := -1;
4006:
4007: Cursor getConversionRate(amt number) Is
4008: select --+ INDEX_DESC( r, GL_DAILY_RATES_U1 )
4009: (conversion_rate * amt)
4010: from gl_daily_rates r
4011: where from_currency = suspenseData.threshold_currency
4012: and to_currency = contextData.currencyCode

Line 4010: from gl_daily_rates r

4006:
4007: Cursor getConversionRate(amt number) Is
4008: select --+ INDEX_DESC( r, GL_DAILY_RATES_U1 )
4009: (conversion_rate * amt)
4010: from gl_daily_rates r
4011: where from_currency = suspenseData.threshold_currency
4012: and to_currency = contextData.currencyCode
4013: and conversion_date < SYSDATE
4014: and rownum < 2;

Line 4726: select --+ INDEX_DESC( r, GL_DAILY_RATES_U1 )

4722:
4723: entryId gcs_entry_headers.entry_id%TYPE := -1;
4724:
4725: Cursor getConversionRate(amt number) Is
4726: select --+ INDEX_DESC( r, GL_DAILY_RATES_U1 )
4727: (conversion_rate * amt)
4728: from gl_daily_rates r
4729: where from_currency = suspenseData.threshold_currency
4730: and to_currency = contextData.currencyCode

Line 4728: from gl_daily_rates r

4724:
4725: Cursor getConversionRate(amt number) Is
4726: select --+ INDEX_DESC( r, GL_DAILY_RATES_U1 )
4727: (conversion_rate * amt)
4728: from gl_daily_rates r
4729: where from_currency = suspenseData.threshold_currency
4730: and to_currency = contextData.currencyCode
4731: and conversion_date < SYSDATE
4732: and rownum < 2;