APPS.OKS_ENTITLEMENTS_PVT dependencies on OKS_COVERAGE_TIMES

Line 1846: FROM Oks_Coverage_Times CVT

1842: IS
1843: SELECT LPAD(TO_CHAR(CVT.START_HOUR), 2, '0')||LPAD(TO_CHAR(CVT.START_MINUTE), 2, '0') BP_Cover_From
1844: ,LPAD(TO_CHAR(CVT.END_HOUR), 2, '0')||LPAD(TO_CHAR(CVT.END_MINUTE), 2, '0') BP_Cover_To
1845: ,((CVT.START_HOUR)*60+(CVT.START_MINUTE)) BP_Cover_From_num
1846: FROM Oks_Coverage_Times CVT
1847: WHERE CVT.cov_tze_line_id = Cx_BP_CVTLine_Id
1848: And (
1849: decode(Cx_sunday_flag,'Y',CVT.sunday_yn,'N','#') = decode(Cx_sunday_flag,'Y','Y','N','#')
1850: and decode(Cx_monday_flag,'Y', CVT.monday_yn,'N','#') = decode(Cx_monday_flag,'Y','Y','N','#')