88: WHERE cs_coverages.coverage_id = p_coverage_id;
89: l_cc_pk cc_pk_csr%ROWTYPE;
90: CURSOR csbp_pk_csr (p_business_process_id IN NUMBER) IS
91: SELECT *
92: FROM Cs_Business_Processes
93: WHERE cs_business_processes.business_process_id = p_business_process_id;
94: l_csbp_pk csbp_pk_csr%ROWTYPE;
95: CURSOR cs_time_zones_pk_csr (p_time_zone_id IN NUMBER) IS
96: SELECT *
89: l_cc_pk cc_pk_csr%ROWTYPE;
90: CURSOR csbp_pk_csr (p_business_process_id IN NUMBER) IS
91: SELECT *
92: FROM Cs_Business_Processes
93: WHERE cs_business_processes.business_process_id = p_business_process_id;
94: l_csbp_pk csbp_pk_csr%ROWTYPE;
95: CURSOR cs_time_zones_pk_csr (p_time_zone_id IN NUMBER) IS
96: SELECT *
97: FROM Cs_Time_Zones