APPS.GL_EXCH_RATES_SYNC_PKG dependencies on GL_DAILY_CONVERSION_TYPES

Line 27: l_conversion_type gl_daily_conversion_types.conversion_type%TYPE;

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);
31: l_n_dir_cr_cntr NUMBER(7);

Line 54: FROM gl_daily_conversion_types

50:
51: --Cursor to fetch the Conversion Type
52: CURSOR c_get_conv_type IS
53: SELECT conversion_type
54: FROM gl_daily_conversion_types
55: WHERE user_conversion_type = p_conversion_rate_type;
56:
57: --Cursor to Fetch the Direct Rates and Inverse Rates for the Entered Parameters
58: CURSOR c_get_rates(c_from_currency VARCHAR2,

Line 77: gl_daily_conversion_types gdct

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)
80: AND gldr.conversion_type = glcrs.conversion_type(+)
81: AND gdct.conversion_type = gldr.conversion_type

Line 106: gl_daily_conversion_types gdct

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)
109: AND gldr.conversion_type = glcrs.conversion_type
110: AND gdct.conversion_type = gldr.conversion_type

Line 138: gl_daily_conversion_types gdct

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)
141: AND gldr.conversion_type = glcrs.conversion_type
142: AND gdct.conversion_type = gldr.conversion_type