APPS.GL_EXCH_RATES_SYNC_PKG dependencies on GL_DAILY_RATES

Line 26: l_contra_currency gl_daily_rates.from_currency%TYPE;

22: l_dir_cr_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
23: l_inv_cr_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
24: l_pivot_currency gl_cross_rate_rules.pivot_currency%TYPE;
25: l_description gl_cross_rate_rules.description%TYPE;
26: l_contra_currency gl_daily_rates.from_currency%TYPE;
27: l_conversion_type gl_daily_conversion_types.conversion_type%TYPE;
28: l_to_date DATE;
29: l_n_dir_cntr NUMBER(7);
30: l_n_inv_cntr NUMBER(7);

Line 75: FROM gl_daily_rates gldr,

71: --decode(glcrs.pivot_currency,gldr.from_currency,gldr.from_currency,gldr.to_currency,gldr.to_currency,null) pivot_currency,
72: null pivot_currency,
73: --decode(glcrs.pivot_currency,gldr.from_currency,glcrs.description,gldr.to_currency,glcrs.description,null) description
74: null description
75: FROM gl_daily_rates gldr,
76: gl_cross_rate_rules glcrs,
77: gl_daily_conversion_types gdct
78: WHERE gldr.conversion_date between c_from_date and c_to_date
79: AND nvl2(c_conversion_rate_type,gldr.conversion_type,1) = nvl(c_conversion_rate_type,1)

Line 104: FROM gl_daily_rates gldr,

100: --decode(glcrs.pivot_currency,gldr.from_currency,gldr.from_currency,gldr.to_currency,gldr.to_currency,null) pivot_currency,
101: l_pivot_currency pivot_currency,
102: --decode(glcrs.pivot_currency,gldr.from_currency,glcrs.description,gldr.to_currency,glcrs.description,null) description
103: l_description description
104: FROM gl_daily_rates gldr,
105: gl_cross_rate_rules glcrs,
106: gl_daily_conversion_types gdct
107: WHERE gldr.conversion_date between c_from_date and c_to_date
108: AND nvl2(c_conversion_rate_type,gldr.conversion_type,1) = nvl(c_conversion_rate_type,1)

Line 136: FROM gl_daily_rates gldr,

132: --decode(glcrs.pivot_currency,gldr.from_currency,gldr.from_currency,gldr.to_currency,gldr.to_currency,null) pivot_currency,
133: l_pivot_currency pivot_currency,
134: --decode(glcrs.pivot_currency,gldr.from_currency,glcrs.description,gldr.to_currency,glcrs.description,null) description
135: l_description description
136: FROM gl_daily_rates gldr,
137: gl_cross_rate_rules glcrs,
138: gl_daily_conversion_types gdct
139: WHERE gldr.conversion_date between c_from_date and c_to_date
140: AND nvl2(c_conversion_rate_type,gldr.conversion_type,1) = nvl(c_conversion_rate_type,1)