DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_PVT dependencies on OKS_COVERAGE_TIMEZONES

Line 1236: FROM Oks_Coverage_Timezones OCT

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

Line 3636: oks_coverage_timezones oct

3632: oct.default_yn,
3633: okslb.APPLY_DEFAULT_TIMEZONE
3634: from okc_k_lines_b okclb,
3635: oks_k_lines_b okslb,
3636: oks_coverage_timezones oct
3637: where okclb.id = P_BPL_Id
3638: and okslb.cle_id = okclb.id
3639: and oct.cle_id = okclb.id;
3640:

Line 4963: oks_coverage_timezones oct

4959: oct.default_yn,
4960: okslb.APPLY_DEFAULT_TIMEZONE
4961: from okc_k_lines_b okclb,
4962: oks_k_lines_b okslb,
4963: oks_coverage_timezones oct
4964: where okclb.id = P_BPL_Id
4965: and okslb.cle_id = okclb.id
4966: and oct.cle_id = okclb.id;
4967: