DBA Data[Home] [Help]

APPS.CS_GET_COVERAGE_VALUES_PUB dependencies on CS_LOOKUPS

Line 54: CS_LOOKUPS LKT

50: FROM CS_COV_BILL_RATES CBR,
51: CS_COVERAGE_TXN_GROUPS CTG,
52: CS_COV_BILLING_TYPES CBT,
53: CS_TXN_BILLING_TYPES TBT,
54: CS_LOOKUPS LKT
55: WHERE CTG.Coverage_id = l_coverage_id
56: AND CTG.Business_Process_Id = p_business_process_id
57: AND CTG.Coverage_Txn_Group_Id = CBT.Coverage_Txn_Group_Id
58: AND TBT.Txn_Billing_Type_Id = CBT.Txn_Billing_Type_Id

Line 73: CS_LOOKUPS LKT

69: FROM CS_COV_BILL_RATES CBR,
70: CS_COVERAGE_TXN_GROUPS CTG,
71: CS_COV_BILLING_TYPES CBT,
72: CS_TXN_BILLING_TYPES TBT,
73: CS_LOOKUPS LKT
74: WHERE CTG.Coverage_id = l_coverage_id
75: AND CTG.Business_Process_Id = p_business_process_id
76: AND CTG.Coverage_Txn_Group_Id = CBT.Coverage_Txn_Group_Id
77: AND TBT.Txn_Billing_Type_Id = CBT.Txn_Billing_Type_Id