DBA Data[Home] [Help]

APPS.CS_CONTRACT_BILLING dependencies on CS_CONTRACT_STATUSES

Line 152: CS_CONTRACT_STATUSES STS

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
155: CON.CONTRACT_NUMBER =
156: NVL(p_contract_number,CON.CONTRACT_NUMBER) AND

Line 192: CS_CONTRACT_STATUSES STS

188: CS_CP_SERVICES SRV,
189: CS_CUSTOMER_PRODUCTS PROD,
190: CS_CONTRACT_COVERAGE_LEVELS COVL,
191: CS_COVERED_PRODUCTS COVP,
192: CS_CONTRACT_STATUSES STS
193: WHERE
194: CON.CONTRACT_ID = SRV.CONTRACT_ID AND
195: STS.ELIGIBLE_FOR_INVOICING = 'Y' AND
196: (