APPS.GL_EXCH_RATES_SYNC_PKG dependencies on GL_CROSS_RATE_RULES

Line 24: l_pivot_currency gl_cross_rate_rules.pivot_currency%TYPE;

20: l_cur_conv_inv_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
21: l_cr_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
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;

Line 25: l_description gl_cross_rate_rules.description%TYPE;

21: l_cr_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
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);

Line 37: FROM gl_cross_rate_rules

33:
34: --Cursor to get the Pivot Currency for the given Conversion Type
35: CURSOR c_pivot_curr IS
36: SELECT pivot_currency,description
37: FROM gl_cross_rate_rules
38: WHERE conversion_type = l_conversion_type
39: AND (pivot_currency = p_from_currency OR pivot_currency = p_to_currency);
40:
41: --Cursor to get the Contra Currency of Conversion Type for the Entered Parameters

Line 76: gl_cross_rate_rules glcrs,

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

Line 105: gl_cross_rate_rules glcrs,

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

Line 137: gl_cross_rate_rules glcrs,

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