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.CS_EXP_TERMINATE_PVT dependencies on CS_CP_SERVICE_TRANSACTIONS

Line 283: from cs_cp_services_all, cs_cp_service_transactions

279: IF C1%NOTFOUND THEN
280: LOOPING := FALSE;
281: ELSE
282: select count(*) into v_counter
283: from cs_cp_services_all, cs_cp_service_transactions
284: where lcontract_rec.contract_id = cs_cp_services_all.contract_id
285: and cs_cp_services_all.cp_service_id = cs_cp_service_transactions.cp_service_id;
286:
287:

Line 285: and cs_cp_services_all.cp_service_id = cs_cp_service_transactions.cp_service_id;

281: ELSE
282: select count(*) into v_counter
283: from cs_cp_services_all, cs_cp_service_transactions
284: where lcontract_rec.contract_id = cs_cp_services_all.contract_id
285: and cs_cp_services_all.cp_service_id = cs_cp_service_transactions.cp_service_id;
286:
287:
288: IF v_counter = 0 THEN
289: v_status_id := FND_PROFILE.VALUE('CS_CONTRACTS_EXPIRED_STATUS');