eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_CON_COVERAGE_PVT dependencies on STANDARD

Line 235: and trunc(p_request_date) >= trunc(Get_BP_Line_Start_Offset(bpl.id,svl.start_date,bpl.start_date,ksl.Standard_Cov_YN))

231: and ksl.cle_id = svl.id
232: and bpl.cle_id = ksl.coverage_id
233: and bpl.id = cimbp.cle_id
234: and cimbp.object1_id1 = to_char(p_business_process_id)
235: and trunc(p_request_date) >= trunc(Get_BP_Line_Start_Offset(bpl.id,svl.start_date,bpl.start_date,ksl.Standard_Cov_YN))
236: and trunc(p_request_date) <= trunc(Get_grace_end_Date(ksl.dnz_chr_id,svl.end_date,bpl.end_date,ksl.Standard_Cov_YN))
237: and bpl.id = oksbpl.cle_id;
238:
239: -- new cursor added as part of bug 3141819 to take care of backward compatibility

Line 236: and trunc(p_request_date) <= trunc(Get_grace_end_Date(ksl.dnz_chr_id,svl.end_date,bpl.end_date,ksl.Standard_Cov_YN))

232: and bpl.cle_id = ksl.coverage_id
233: and bpl.id = cimbp.cle_id
234: and cimbp.object1_id1 = to_char(p_business_process_id)
235: and trunc(p_request_date) >= trunc(Get_BP_Line_Start_Offset(bpl.id,svl.start_date,bpl.start_date,ksl.Standard_Cov_YN))
236: and trunc(p_request_date) <= trunc(Get_grace_end_Date(ksl.dnz_chr_id,svl.end_date,bpl.end_date,ksl.Standard_Cov_YN))
237: and bpl.id = oksbpl.cle_id;
238:
239: -- new cursor added as part of bug 3141819 to take care of backward compatibility
240: -- related to p_txn_grp_id

Line 253: and trunc(p_request_date) >= trunc(Get_BP_Line_Start_Offset(bpl.id,svl.start_date,bpl.start_date,ksl.Standard_Cov_YN))

249: and svl.lse_id in (1,14,19)
250: and ksl.cle_id = svl.id
251: and bpl.cle_id = ksl.coverage_id
252: and bpl.id = p_txn_grp_id --bug 3141819
253: and trunc(p_request_date) >= trunc(Get_BP_Line_Start_Offset(bpl.id,svl.start_date,bpl.start_date,ksl.Standard_Cov_YN))
254: and trunc(p_request_date) <= trunc(Get_grace_end_Date(ksl.dnz_chr_id,svl.end_date,bpl.end_date,ksl.Standard_Cov_YN))
255: and bpl.id = oksbpl.cle_id;
256:
257: --

Line 254: and trunc(p_request_date) <= trunc(Get_grace_end_Date(ksl.dnz_chr_id,svl.end_date,bpl.end_date,ksl.Standard_Cov_YN))

250: and ksl.cle_id = svl.id
251: and bpl.cle_id = ksl.coverage_id
252: and bpl.id = p_txn_grp_id --bug 3141819
253: and trunc(p_request_date) >= trunc(Get_BP_Line_Start_Offset(bpl.id,svl.start_date,bpl.start_date,ksl.Standard_Cov_YN))
254: and trunc(p_request_date) <= trunc(Get_grace_end_Date(ksl.dnz_chr_id,svl.end_date,bpl.end_date,ksl.Standard_Cov_YN))
255: and bpl.id = oksbpl.cle_id;
256:
257: --
258: --

Line 423: and trunc(p_request_date) >= trunc(Get_BP_Line_Start_Offset(bpl.id, svl.start_date, bpl.start_date, KSL.Standard_Cov_YN))

419: and ksl.cle_id = svl.id
420: and bpl.cle_id = ksl.coverage_id
421: and bpl.id = cimbp.cle_id
422: and cimbp.object1_id1 = to_char(p_business_process_id)
423: and trunc(p_request_date) >= trunc(Get_BP_Line_Start_Offset(bpl.id, svl.start_date, bpl.start_date, KSL.Standard_Cov_YN))
424: and trunc(p_request_date) <= trunc(Get_grace_end_Date(svl.dnz_chr_id, svl.end_date, bpl.end_date,KSL.Standard_Cov_YN))
425: and btl.cle_id = bpl.id
426: and btl.id = cimbt.cle_id
427: and cimbt.object1_id1 = to_char(p_bill_type_id)

Line 424: and trunc(p_request_date) <= trunc(Get_grace_end_Date(svl.dnz_chr_id, svl.end_date, bpl.end_date,KSL.Standard_Cov_YN))

420: and bpl.cle_id = ksl.coverage_id
421: and bpl.id = cimbp.cle_id
422: and cimbp.object1_id1 = to_char(p_business_process_id)
423: and trunc(p_request_date) >= trunc(Get_BP_Line_Start_Offset(bpl.id, svl.start_date, bpl.start_date, KSL.Standard_Cov_YN))
424: and trunc(p_request_date) <= trunc(Get_grace_end_Date(svl.dnz_chr_id, svl.end_date, bpl.end_date,KSL.Standard_Cov_YN))
425: and btl.cle_id = bpl.id
426: and btl.id = cimbt.cle_id
427: and cimbt.object1_id1 = to_char(p_bill_type_id)
428: and oksbtl.cle_id = btl.id; --11.5.10 addition

Line 447: and trunc(p_request_date) >= trunc(Get_BP_Line_Start_Offset(bpl.id, svl.start_date, bpl.start_date, KSL.Standard_Cov_YN))

443: and svl.lse_id in (1,14,19)
444: and ksl.cle_id = svl.id
445: and bpl.cle_id = ksl.coverage_id
446: and bpl.id = p_txngrp_id
447: and trunc(p_request_date) >= trunc(Get_BP_Line_Start_Offset(bpl.id, svl.start_date, bpl.start_date, KSL.Standard_Cov_YN))
448: and trunc(p_request_date) <= trunc(Get_grace_end_Date(svl.dnz_chr_id, svl.end_date, bpl.end_date,KSL.Standard_Cov_YN))
449: and btl.cle_id = bpl.id
450: and btl.id = cimbt.cle_id
451: and cimbt.object1_id1 = to_char(p_bill_type_id)

Line 448: and trunc(p_request_date) <= trunc(Get_grace_end_Date(svl.dnz_chr_id, svl.end_date, bpl.end_date,KSL.Standard_Cov_YN))

444: and ksl.cle_id = svl.id
445: and bpl.cle_id = ksl.coverage_id
446: and bpl.id = p_txngrp_id
447: and trunc(p_request_date) >= trunc(Get_BP_Line_Start_Offset(bpl.id, svl.start_date, bpl.start_date, KSL.Standard_Cov_YN))
448: and trunc(p_request_date) <= trunc(Get_grace_end_Date(svl.dnz_chr_id, svl.end_date, bpl.end_date,KSL.Standard_Cov_YN))
449: and btl.cle_id = bpl.id
450: and btl.id = cimbt.cle_id
451: and cimbt.object1_id1 = to_char(p_bill_type_id)
452: and oksbtl.cle_id = btl.id; --11.5.10 addition

Line 841: and trunc(p_request_date) >= trunc(Get_BP_Line_Start_Offset(bpl.id,svl.start_date,bpl.start_date,ksl.Standard_Cov_YN))

837: and bpl.cle_id = ksl.coverage_id
838: and oksbpl.cle_id = bpl.id
839: and bpl.id = cimbp.cle_id
840: and cimbp.object1_id1 = nvl(to_char(p_business_process_id),cimbp.object1_id1)
841: and trunc(p_request_date) >= trunc(Get_BP_Line_Start_Offset(bpl.id,svl.start_date,bpl.start_date,ksl.Standard_Cov_YN))
842: and trunc(p_request_date) <= trunc(Get_grace_end_Date(ksl.dnz_chr_id,svl.end_date,bpl.end_date,ksl.Standard_Cov_YN));
843:
844: --
845: --

Line 842: and trunc(p_request_date) <= trunc(Get_grace_end_Date(ksl.dnz_chr_id,svl.end_date,bpl.end_date,ksl.Standard_Cov_YN));

838: and oksbpl.cle_id = bpl.id
839: and bpl.id = cimbp.cle_id
840: and cimbp.object1_id1 = nvl(to_char(p_business_process_id),cimbp.object1_id1)
841: and trunc(p_request_date) >= trunc(Get_BP_Line_Start_Offset(bpl.id,svl.start_date,bpl.start_date,ksl.Standard_Cov_YN))
842: and trunc(p_request_date) <= trunc(Get_grace_end_Date(ksl.dnz_chr_id,svl.end_date,bpl.end_date,ksl.Standard_Cov_YN));
843:
844: --
845: --
846:

Line 946: and trunc(nvl(p_request_date,sysdate)) >= trunc(Get_BP_Line_Start_Offset(bpl.id,svl.start_date,bpl.start_date,ksl.Standard_Cov_YN))

942: and svl.lse_id in (1,14,19)
943: and ksl.cle_id = svl.id
944: and bpl.cle_id = ksl.coverage_id
945: and bpl.id = cimbp.cle_id
946: and trunc(nvl(p_request_date,sysdate)) >= trunc(Get_BP_Line_Start_Offset(bpl.id,svl.start_date,bpl.start_date,ksl.Standard_Cov_YN))
947: and trunc(nvl(p_request_date,sysdate)) <= trunc(Get_grace_end_Date(ksl.dnz_chr_id,svl.end_date,bpl.end_date,ksl.Standard_Cov_YN))
948: and cimbp.object1_id1 = to_char(p_busi_proc_id)
949: and btl.cle_id = bpl.id
950: and btl.lse_id in (5,59,23)

Line 947: and trunc(nvl(p_request_date,sysdate)) <= trunc(Get_grace_end_Date(ksl.dnz_chr_id,svl.end_date,bpl.end_date,ksl.Standard_Cov_YN))

943: and ksl.cle_id = svl.id
944: and bpl.cle_id = ksl.coverage_id
945: and bpl.id = cimbp.cle_id
946: and trunc(nvl(p_request_date,sysdate)) >= trunc(Get_BP_Line_Start_Offset(bpl.id,svl.start_date,bpl.start_date,ksl.Standard_Cov_YN))
947: and trunc(nvl(p_request_date,sysdate)) <= trunc(Get_grace_end_Date(ksl.dnz_chr_id,svl.end_date,bpl.end_date,ksl.Standard_Cov_YN))
948: and cimbp.object1_id1 = to_char(p_busi_proc_id)
949: and btl.cle_id = bpl.id
950: and btl.lse_id in (5,59,23)
951: and btl.id = cimbt.cle_id