APPS.CS_CONTRACT_BILLING dependencies on CS_CONTRACTS_BILLING

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