APPS.OKS_UPGRADE_PRECHECK dependencies on CS_COVERAGE_TXN_GROUPS

Line 922: FROM CS_COVERAGE_TXN_GROUPS ctxg,

918: PROCEDURE Update_time_zone IS
919:
920: CURSOR Cur_tz IS
921: SELECT distinct dnz_chr_id
922: FROM CS_COVERAGE_TXN_GROUPS ctxg,
923: OKC_K_LINES_B cle
924: WHERE cle.upg_Orig_System_Ref='CS_COVERAGE_TXN_GROUPS'
925: AND cle.upg_Orig_System_Ref_Id = ctxg.Coverage_txn_Group_id
926: AND ctxg.Time_Zone_Id IS NULL;

Line 924: WHERE cle.upg_Orig_System_Ref='CS_COVERAGE_TXN_GROUPS'

920: CURSOR Cur_tz IS
921: SELECT distinct dnz_chr_id
922: FROM CS_COVERAGE_TXN_GROUPS ctxg,
923: OKC_K_LINES_B cle
924: WHERE cle.upg_Orig_System_Ref='CS_COVERAGE_TXN_GROUPS'
925: AND cle.upg_Orig_System_Ref_Id = ctxg.Coverage_txn_Group_id
926: AND ctxg.Time_Zone_Id IS NULL;
927:
928: l_cov_timezone_id Number;

Line 944: FROM CS_COVERAGE_TXN_GROUPS ctxg,

940: SET TIMEZONE_ID = l_cov_timezone_id --tz_rec.timezone_id
941: WHERE timezone_id = nvl(FND_PROFILE.value('CS_UPG_CONTRACTS_TIMEZONE'),47)
942: AND dnz_chr_id IN --= tz_rec.chr_id
943: ( SELECT distinct dnz_chr_id
944: FROM CS_COVERAGE_TXN_GROUPS ctxg,
945: OKC_K_LINES_B cle
946: WHERE cle.upg_Orig_System_Ref='CS_COVERAGE_TXN_GROUPS'
947: AND cle.upg_Orig_System_Ref_Id = ctxg.Coverage_txn_Group_id
948: AND ctxg.Time_Zone_Id IS NULL);

Line 946: WHERE cle.upg_Orig_System_Ref='CS_COVERAGE_TXN_GROUPS'

942: AND dnz_chr_id IN --= tz_rec.chr_id
943: ( SELECT distinct dnz_chr_id
944: FROM CS_COVERAGE_TXN_GROUPS ctxg,
945: OKC_K_LINES_B cle
946: WHERE cle.upg_Orig_System_Ref='CS_COVERAGE_TXN_GROUPS'
947: AND cle.upg_Orig_System_Ref_Id = ctxg.Coverage_txn_Group_id
948: AND ctxg.Time_Zone_Id IS NULL);
949:
950: -- End Changes TVCP Migration 31-OCT-2003 MCHOUDHA