DBA Data[Home] [Help]

APPS.OKS_PM_ENTITLEMENTS_PVT dependencies on OKS_PM_SCHEDULES

Line 767: Oks_PM_Schedules sch,

763: sch.SCHEDULE_DATE_FROM,
764: sch.SCHEDULE_DATE_TO,
765: cov.end_date cov_end_date
766: FROM Okc_K_lines_B cov,
767: Oks_PM_Schedules sch,
768: -- rule rearchitecure changes
769: -- okc_rule_groups_b rgp,
770: -- OKC_rules_b pmp
771: oks_k_lines_b okscov

Line 807: Oks_PM_Schedules sch,

803: sch.SCHEDULE_DATE_FROM,
804: sch.SCHEDULE_DATE_TO,
805: decode(okssrv.STANDARD_COV_YN,'Y',srv.end_date,cov.end_date) cov_end_date
806: FROM Okc_K_lines_B srv,
807: Oks_PM_Schedules sch,
808: oks_k_lines_b okssrv,
809: okc_k_lines_b cov
810: WHERE srv.Id = Cx_SrvLine_Id
811: AND srv.lse_id in (1,14,19)

Line 837: Oks_PM_Schedules sch,

833: sch.SCHEDULE_DATE_FROM,
834: sch.SCHEDULE_DATE_TO,
835: cov.end_date cov_end_date
836: FROM Okc_K_lines_B cov,
837: Oks_PM_Schedules sch,
838: -- rule rearchitecure changes
839: -- okc_rule_groups_b rgp,
840: -- OKC_rules_b pma
841: oks_k_lines_b okscov,

Line 882: Oks_PM_Schedules sch,

878: sch.SCHEDULE_DATE_TO,
879: decode(okssrv.STANDARD_COV_YN,'Y',srv.end_date,cov.end_date) cov_end_date
880: FROM Okc_K_lines_B srv,
881: Okc_K_lines_B cov,
882: Oks_PM_Schedules sch,
883: oks_k_lines_b okssrv,
884: oks_pm_activities pmact
885: WHERE srv.Id = Cx_SrvLine_Id
886: AND srv.lse_id in (1,14,19)

Line 916: Oks_PM_Schedules sch,

912: sch.SCHEDULE_DATE_FROM,
913: sch.SCHEDULE_DATE_TO,
914: cov.end_date cov_end_date
915: FROM Okc_K_lines_B cov,
916: Oks_PM_Schedules sch,
917: -- rule rearchitecture changes
918: -- okc_rule_groups_b rgp,
919: -- OKC_rules_b pma
920: oks_k_lines_b okscov,

Line 958: Oks_PM_Schedules sch,

954: sch.SCHEDULE_DATE_TO,
955: decode(okssrv.STANDARD_COV_YN,'Y',srv.end_date,cov.end_date) cov_end_date
956: FROM Okc_K_lines_B srv,
957: Okc_K_lines_B cov,
958: Oks_PM_Schedules sch,
959: oks_k_lines_b okssrv,
960: oks_pm_activities pmact
961: WHERE srv.Id = Cx_SrvLine_Id
962: AND srv.lse_id in (1,14,19)