DBA Data[Home] [Help]

APPS.CS_GET_REACTION_TIMES_PUB dependencies on CS_COVERAGES

Line 305: l_coverage_id CS_COVERAGES.COVERAGE_ID%TYPE;

301: x_return_status OUT VARCHAR2,
302: x_msg_count OUT NUMBER,
303: x_msg_data OUT VARCHAR2 ) IS
304:
305: l_coverage_id CS_COVERAGES.COVERAGE_ID%TYPE;
306:
307: CURSOR Reaction_Times_csr IS
308: SELECT CRT.Reaction_time_id,
309: CRT.Name Reaction_Time,

Line 411: CS_COVERAGES COV,

407: TXN.Time_Zone_Id ,
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

Line 525: CS_COVERAGES COV,

521: TXN.Time_Zone_Id ,
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