APPS.GL_EXCH_RATES_SYNC_PKG dependencies on GL_CROSS_RATE_RULE_DTLS

Line 46: FROM gl_cross_rate_rule_dtls

42: CURSOR c_con_curr IS
43: SELECT cr_cur_tbl.from_currency
44: FROM
45: (SELECT DISTINCT from_currency from_currency
46: FROM gl_cross_rate_rule_dtls
47: WHERE conversion_type = l_conversion_type
48: AND enabled_flag = 'Y')cr_cur_tbl
49: WHERE (cr_cur_tbl.from_currency = p_from_currency OR cr_cur_tbl.from_currency = p_to_currency);
50:

Line 113: FROM gl_cross_rate_rule_dtls

109: AND gldr.conversion_type = glcrs.conversion_type
110: AND gdct.conversion_type = gldr.conversion_type
111: AND gldr.from_currency = c_contra_currency
112: AND gldr.to_currency IN (SELECT DISTINCT from_currency
113: FROM gl_cross_rate_rule_dtls
114: WHERE nvl2(c_conversion_rate_type,conversion_type,1) = nvl(c_conversion_rate_type,1)
115: AND enabled_flag = 'Y');
116:
117: --Cursor to Fetch the Inverse cross rates for the Entered Parameters

Line 145: FROM gl_cross_rate_rule_dtls

141: AND gldr.conversion_type = glcrs.conversion_type
142: AND gdct.conversion_type = gldr.conversion_type
143: AND gldr.to_currency = c_contra_currency
144: AND gldr.from_currency IN (SELECT DISTINCT from_currency
145: FROM gl_cross_rate_rule_dtls
146: WHERE nvl2(c_conversion_rate_type,conversion_type,1) = nvl(c_conversion_rate_type,1)
147: AND enabled_flag = 'Y');
148:
149: