APPS.CS_CALCULATE_CREDIT dependencies on CS_CP_SERVICE_TRANSACTIONS

Line 34: FROM cs_cp_service_transactions t

30: /* Why not INVOICED transactions only ? */
31:
32: SELECT MAX(t.cp_service_transaction_id)
33: INTO x_first_cp_service_txn_id
34: FROM cs_cp_service_transactions t
35: WHERE t.cp_service_id = x_cp_service_id
36: AND t.effective_start_date <= x_terminate_effective_date
37: AND t.effective_end_date >= x_terminate_effective_date
38: AND t.transaction_type_code in ('RENEW', 'ORDER');

Line 47: FROM cs_cp_service_transactions t

43: INTO days_in_original_service,
44: days_in_terminated_service,
45: txn_end,
46: current_end
47: FROM cs_cp_service_transactions t
48: WHERE t.cp_service_transaction_id = x_first_cp_service_txn_id;
49:
50: SELECT (MAX(t.service_selling_price * cp.quantity) -
51: SUM(NVL(t2.credit_amount,0)))

Line 53: FROM cs_cp_service_transactions t,

49:
50: SELECT (MAX(t.service_selling_price * cp.quantity) -
51: SUM(NVL(t2.credit_amount,0)))
52: INTO available_credit
53: FROM cs_cp_service_transactions t,
54: cs_cp_service_transactions t2,
55: cs_cp_services s,
56: cs_customer_products cp
57: WHERE t.cp_service_transaction_id = x_first_cp_service_txn_id

Line 54: cs_cp_service_transactions t2,

50: SELECT (MAX(t.service_selling_price * cp.quantity) -
51: SUM(NVL(t2.credit_amount,0)))
52: INTO available_credit
53: FROM cs_cp_service_transactions t,
54: cs_cp_service_transactions t2,
55: cs_cp_services s,
56: cs_customer_products cp
57: WHERE t.cp_service_transaction_id = x_first_cp_service_txn_id
58: AND t.cp_service_transaction_id = t2.terminated_transaction_id(+)

Line 67: FROM cs_cp_service_transactions

63: term_cp_serv_txn_id := x_first_cp_service_txn_id;
64: ELSE
65: SELECT MAX(cp_service_transaction_id)
66: INTO term_cp_serv_txn_id
67: FROM cs_cp_service_transactions
68: WHERE transaction_type_code = 'TERMINATE'
69: AND terminated_transaction_id = x_first_cp_service_txn_id
70: AND cp_service_id = x_cp_service_id;
71: END IF;

Line 76: FROM cs_cp_service_transactions t,

72:
73: SELECT NVL(SUM(NVL(t.service_selling_price * cp.quantity , 0)) -
74: SUM(NVL(t.credit_amount, 0)),0)
75: INTO remain_credit_amount
76: FROM cs_cp_service_transactions t,
77: cs_cp_services s,
78: cs_customer_products cp
79: WHERE t.cp_service_transaction_id > term_cp_serv_txn_id
80: AND t.cp_service_id = s.cp_service_id