APPS.OKS_ENTITLEMENTS_PVT dependencies on OKS_COVERAGE_TIMES

Line 1852: FROM Oks_Coverage_Times CVT

1848: IS
1849: SELECT LPAD(TO_CHAR(CVT.START_HOUR), 2, '0')||LPAD(TO_CHAR(CVT.START_MINUTE), 2, '0') BP_Cover_From
1850: ,LPAD(TO_CHAR(CVT.END_HOUR), 2, '0')||LPAD(TO_CHAR(CVT.END_MINUTE), 2, '0') BP_Cover_To
1851: ,((CVT.START_HOUR)*60+(CVT.START_MINUTE)) BP_Cover_From_num
1852: FROM Oks_Coverage_Times CVT
1853: WHERE CVT.cov_tze_line_id = Cx_BP_CVTLine_Id
1854: And (
1855: decode(Cx_sunday_flag,'Y',CVT.sunday_yn,'N','#') = decode(Cx_sunday_flag,'Y','Y','N','#')
1856: and decode(Cx_monday_flag,'Y', CVT.monday_yn,'N','#') = decode(Cx_monday_flag,'Y','Y','N','#')