APPS.CS_GET_REACTION_TIMES_PUB dependencies on CS_COVERAGE_TXN_GROUPS

Line 202: FROM CS_COVERAGE_TXN_GROUPS TXN

198: 5, To_Char(TXN.Thursday_End_Time ,'MI'),
199: 6, To_Char(TXN.Friday_End_Time ,'MI'),
200: 7, To_Char(TXN.Saturday_End_Time ,'MI'))
201: Cov_End_Time_Mts
202: FROM CS_COVERAGE_TXN_GROUPS TXN
203: WHERE TXN.Coverage_Txn_Group_Id = P_Coverage_Txn_Group_Id;
204: BEGIN
205:
206: -- DBMS_Output.Put_Line('In get next days coverage');

Line 412: CS_COVERAGE_TXN_GROUPS TXN

408: TXN.Coverage_Txn_Group_Id
409: FROM CS_COV_REACTION_TIMES CRT,
410: CS_INCIDENT_SEVERITIES INS,
411: CS_COVERAGES COV,
412: CS_COVERAGE_TXN_GROUPS TXN
413: WHERE COV.Coverage_id = l_coverage_id
414: AND COV.Coverage_id = TXN.Coverage_id
415: AND TXN.Business_Process_Id = p_business_process_id
416: AND TXN.Coverage_Txn_Group_Id = CRT.Coverage_Txn_Group_Id

Line 526: CS_COVERAGE_TXN_GROUPS TXN

522: TXN.Coverage_Txn_Group_Id
523: FROM CS_COV_REACTION_TIMES CRT,
524: CS_INCIDENT_SEVERITIES INS,
525: CS_COVERAGES COV,
526: CS_COVERAGE_TXN_GROUPS TXN
527: WHERE COV.Coverage_id = l_coverage_id
528: AND COV.Coverage_id = TXN.Coverage_id
529: AND TXN.Business_Process_Id = p_business_process_id
530: AND TXN.Coverage_Txn_Group_Id = CRT.Coverage_Txn_Group_Id