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 2120: FROM cn_credit_conv_fcts_all

2116: l_repcurr_amount NUMBER;
2117:
2118: CURSOR get_closest_date IS
2119: SELECT start_date
2120: FROM cn_credit_conv_fcts_all
2121: WHERE from_credit_type_id = p_from_credit_type_id
2122: AND to_credit_type_id = -1000
2123: AND start_date <= p_conv_date
2124: AND org_id = p_org_id

Line 2140: FROM cn_credit_conv_fcts_all

2136: IF (l_monetary_flag = 'N') THEN
2137: BEGIN
2138: SELECT conversion_factor * Nvl(p_credit_unit,0)
2139: INTO l_conv_amount
2140: FROM cn_credit_conv_fcts_all
2141: WHERE from_credit_type_id = p_from_credit_type_id
2142: AND to_credit_type_id = -1000
2143: AND org_id = p_org_id
2144: AND p_conv_date between start_date and nvl(end_date, p_conv_date)

Line 2158: FROM cn_credit_conv_fcts_all

2154: RAISE NO_DATA_FOUND;
2155: ELSE
2156: SELECT conversion_factor * Nvl(p_credit_unit,0)
2157: INTO l_conv_amount
2158: FROM cn_credit_conv_fcts_all
2159: WHERE from_credit_type_id = p_from_credit_type_id
2160: AND to_credit_type_id = -1000
2161: AND org_id = p_org_id
2162: AND l_date between start_date and nvl(end_date, l_date)

Line 2215: FROM cn_credit_conv_fcts_all

2211: l_conv_amount NUMBER;
2212:
2213: CURSOR get_closest_date IS
2214: SELECT start_date
2215: FROM cn_credit_conv_fcts_all
2216: WHERE from_credit_type_id = p_from_credit_type_id
2217: AND to_credit_type_id = -1000
2218: AND Trunc(start_date) <= Trunc(p_conv_date)
2219: AND org_id = p_org_id

Line 2244: FROM cn_credit_conv_fcts_all

2240: IF (l_monetary_flag = 'N') THEN
2241: BEGIN
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 p_conv_date between start_date and nvl(end_date, p_conv_date)

Line 2266: FROM cn_credit_conv_fcts_all

2262: RAISE NO_DATA_FOUND;
2263: ELSE
2264: SELECT conversion_factor * Nvl(p_credit_unit,0)
2265: INTO l_conv_amount
2266: FROM cn_credit_conv_fcts_all
2267: WHERE from_credit_type_id = p_from_credit_type_id
2268: AND to_credit_type_id = -1000
2269: AND org_id = p_org_id
2270: AND l_date between start_date and nvl(end_date, l_date);