APPS.CS_CONTRACT_BILLING dependencies on CS_CONTRACTS

Line 150: CS_CONTRACTS CON,

146: SRV.END_DATE_ACTIVE END_DATE_ACTIVE,
147: SRV.BILL_ON BILL_ON,
148: SRV.SERVICE_INVENTORY_ITEM_ID INVENTORY_ITEM_ID
149: FROM
150: CS_CONTRACTS CON,
151: CS_CP_SERVICES SRV,
152: CS_CONTRACT_STATUSES STS
153: WHERE
154: CON.CONTRACT_ID = SRV.CONTRACT_ID AND

Line 187: CS_CONTRACTS CON,

183: SRV.BILL_ON BILL_ON,
184: SRV.SERVICE_INVENTORY_ITEM_ID INVENTORY_ITEM_ID,
185: PROD.QUANTITY QUANTITY
186: FROM
187: CS_CONTRACTS CON,
188: CS_CP_SERVICES SRV,
189: CS_CUSTOMER_PRODUCTS PROD,
190: CS_CONTRACT_COVERAGE_LEVELS COVL,
191: CS_COVERED_PRODUCTS COVP,

Line 377: maximum billed_until_date from CS_CONTRACTS_BILLING */

373: v_retcode NUMBER := SUCCESS;
374: BEGIN
375:
376: /* Select the sum of the invoice ammount for the service line and the
377: maximum billed_until_date from CS_CONTRACTS_BILLING */
378:
379: --FND_FILE.PUT_LINE(FND_FILE.LOG,'CONTRACT_ID ='||
380: -- to_char(p_contract_id));
381: --FND_FILE.PUT_LINE(FND_FILE.LOG,'CP_SERVICE_ID ='||

Line 386: FROM CS_CONTRACTS_BILLING

382: -- to_char(p_cp_service_id));
383:
384: SELECT SUM(TRX_PRE_TAX_AMOUNT), MAX(BILLED_UNTIL_DATE)
385: INTO p_invoiced_service_amount, p_billed_until_date
386: FROM CS_CONTRACTS_BILLING
387: WHERE CONTRACT_ID = p_contract_Id
388: AND CP_SERVICE_ID = p_cp_service_id;
389:
390: /* When no record exist in CS_CONTRACTS_BILLING for the specific

Line 390: /* When no record exist in CS_CONTRACTS_BILLING for the specific

386: FROM CS_CONTRACTS_BILLING
387: WHERE CONTRACT_ID = p_contract_Id
388: AND CP_SERVICE_ID = p_cp_service_id;
389:
390: /* When no record exist in CS_CONTRACTS_BILLING for the specific
391: Contract_Id and cs_cp_service_id , the total invoiced amount is ZERO
392: and the Billed_Until_Date is NULL */
393:
394: IF (p_invoiced_service_amount IS NULL ) THEN