DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_PVT dependencies on OKS_COVERAGE_TIMEZONES

Line 1233: FROM Oks_Coverage_Timezones OCT

1229:
1230: CURSOR Lx_Csr_BP_CVT(Cx_BPL_Id IN Gx_OKS_Id) IS
1231: SELECT OCT.Id
1232: ,OCT.TimeZone_Id BP_Tzone_Id
1233: FROM Oks_Coverage_Timezones OCT
1234: WHERE OCT.CLE_ID = Cx_BPL_Id
1235: AND OCT.Default_YN = 'Y';
1236:
1237: Lx_BPL_Id CONSTANT Gx_OKS_Id := P_BPL_Id;

Line 3277: oks_coverage_timezones oct

3273: oct.default_yn,
3274: okslb.APPLY_DEFAULT_TIMEZONE
3275: from okc_k_lines_b okclb,
3276: oks_k_lines_b okslb,
3277: oks_coverage_timezones oct
3278: where okclb.id = P_BPL_Id
3279: and okslb.cle_id = okclb.id
3280: and oct.cle_id = okclb.id;
3281:

Line 4576: oks_coverage_timezones oct

4572: oct.default_yn,
4573: okslb.APPLY_DEFAULT_TIMEZONE
4574: from okc_k_lines_b okclb,
4575: oks_k_lines_b okslb,
4576: oks_coverage_timezones oct
4577: where okclb.id = P_BPL_Id
4578: and okslb.cle_id = okclb.id
4579: and oct.cle_id = okclb.id;
4580: