APPS.CS_GET_COVERAGE_VALUES_PUB dependencies on CS_COVERAGE_TXN_GROUPS

Line 51: CS_COVERAGE_TXN_GROUPS CTG,

47: CURSOR Bill_Rate_UOM_csr IS
48: SELECT CBR.Flat_Rate,
49: CBR.Percent_Rate
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

Line 70: CS_COVERAGE_TXN_GROUPS CTG,

66: CURSOR Bill_Rate_Null_UOM_csr IS
67: SELECT CBR.Flat_Rate,
68: CBR.Percent_Rate
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

Line 225: FROM CS_COVERAGE_TXN_GROUPS TXN

221:
222: CURSOR Preferred_Engineer_csr IS
223: SELECT TXN.Preferred_Engineer1,
224: TXN.Preferred_Engineer2
225: FROM CS_COVERAGE_TXN_GROUPS TXN
226: WHERE TXN.Coverage_id = l_coverage_id
227: AND TXN.Business_Process_Id = p_business_Process_id;
228:
229: l_api_name CONSTANT VARCHAR2(30) := 'Get_Preferred_Engineer';