eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_API dependencies on CN_CREDIT_CONV_FCTS_ALL

Line 2098: FROM cn_credit_conv_fcts_all

2094: l_repcurr_amount NUMBER;
2095:
2096: CURSOR get_closest_date IS
2097: SELECT start_date
2098: FROM cn_credit_conv_fcts_all
2099: WHERE from_credit_type_id = p_from_credit_type_id
2100: AND to_credit_type_id = -1000
2101: AND start_date <= p_conv_date
2102: AND org_id = p_org_id

Line 2118: FROM cn_credit_conv_fcts_all

2114: IF (l_monetary_flag = 'N') THEN
2115: BEGIN
2116: SELECT conversion_factor * Nvl(p_credit_unit,0)
2117: INTO l_conv_amount
2118: FROM cn_credit_conv_fcts_all
2119: WHERE from_credit_type_id = p_from_credit_type_id
2120: AND to_credit_type_id = -1000
2121: AND org_id = p_org_id
2122: AND p_conv_date between start_date and nvl(end_date, p_conv_date)

Line 2136: FROM cn_credit_conv_fcts_all

2132: RAISE NO_DATA_FOUND;
2133: ELSE
2134: SELECT conversion_factor * Nvl(p_credit_unit,0)
2135: INTO l_conv_amount
2136: FROM cn_credit_conv_fcts_all
2137: WHERE from_credit_type_id = p_from_credit_type_id
2138: AND to_credit_type_id = -1000
2139: AND org_id = p_org_id
2140: AND l_date between start_date and nvl(end_date, l_date)

Line 2193: FROM cn_credit_conv_fcts_all

2189: l_conv_amount NUMBER;
2190:
2191: CURSOR get_closest_date IS
2192: SELECT start_date
2193: FROM cn_credit_conv_fcts_all
2194: WHERE from_credit_type_id = p_from_credit_type_id
2195: AND to_credit_type_id = -1000
2196: AND Trunc(start_date) <= Trunc(p_conv_date)
2197: AND org_id = p_org_id

Line 2222: FROM cn_credit_conv_fcts_all

2218: IF (l_monetary_flag = 'N') THEN
2219: BEGIN
2220: SELECT conversion_factor * Nvl(p_credit_unit,0)
2221: INTO l_conv_amount
2222: FROM cn_credit_conv_fcts_all
2223: WHERE from_credit_type_id = p_from_credit_type_id
2224: AND to_credit_type_id = -1000
2225: AND org_id = p_org_id
2226: AND p_conv_date between start_date and nvl(end_date, p_conv_date)

Line 2244: FROM cn_credit_conv_fcts_all

2240: RAISE NO_DATA_FOUND;
2241: ELSE
2242: SELECT conversion_factor * Nvl(p_credit_unit,0)
2243: INTO l_conv_amount
2244: FROM cn_credit_conv_fcts_all
2245: WHERE from_credit_type_id = p_from_credit_type_id
2246: AND to_credit_type_id = -1000
2247: AND org_id = p_org_id
2248: AND l_date between start_date and nvl(end_date, l_date);