APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_STREAM_BILLING_PVT

Line 779: -- OKL_STREAM_BILLING_PVT.get_printing_lead_days(khr.id)) -- Added for Bug#6794547

775: RA_TERMS TERM where KHR.BILL_TO_SITE_USE_ID = CP.SITE_USE_ID AND CP.STANDARD_TERMS = TERM.TERM_ID)
776: ),0)
777: )
778:
779: -- OKL_STREAM_BILLING_PVT.get_printing_lead_days(khr.id)) -- Added for Bug#6794547
780: AND KHR.authoring_org_id = NVL(TO_NUMBER(orgId),-99)
781: AND nvl(p_ia_contract_type, L_CONTRACT_TYPE) = L_CONTRACT_TYPE
782: AND NOT EXISTS
783: (SELECT '1'

Line 926: AND nbd.earliest_strm_bill_date <= (NVL(p_date, SYSDATE) + OKL_STREAM_BILLING_PVT.get_printing_lead_days(khr.id))

922: AND khr.sts_code = 'ACTIVE'
923: AND p_source = 'BILL_STREAMS'
924: AND nvl(p_ia_contract_type, L_IA_TYPE) = L_IA_TYPE
925: AND khr.id = nbd.khr_id
926: AND nbd.earliest_strm_bill_date <= (NVL(p_date, SYSDATE) + OKL_STREAM_BILLING_PVT.get_printing_lead_days(khr.id))
927: AND KHR.authoring_org_id = NVL(TO_NUMBER(orgId),-99)
928: AND NOT EXISTS
929: (SELECT '1'
930: FROM OKL_PARALLEL_PROCESSES opp

Line 980: -- STE.STREAM_ELEMENT_DATE <= (NVL(p_date_to, SYSDATE) + OKL_STREAM_BILLING_PVT.get_printing_lead_days(opp.khr_id)) AND -- Bug 6377127

976: AND KHR.BILL_TO_SITE_USE_ID = CP.SITE_USE_ID
977: AND CP.STANDARD_TERMS = TERM.TERM_ID),
978: 0)*/
979: ) and
980: -- STE.STREAM_ELEMENT_DATE <= (NVL(p_date_to, SYSDATE) + OKL_STREAM_BILLING_PVT.get_printing_lead_days(opp.khr_id)) AND -- Bug 6377127
981: STE.AMOUNT <> 0 AND
982: STM.ID = STE.STM_ID AND
983: STE.DATE_BILLED IS NULL AND
984: STM.ACTIVE_YN = 'Y' AND

Line 1390: -- + OKL_STREAM_BILLING_PVT.get_printing_lead_days(opp.khr_id)

1386: AND RULE.RULE_INFORMATION_CATEGORY = 'LAINVD'
1387: AND KHR.BILL_TO_SITE_USE_ID = CP.SITE_USE_ID
1388: AND CP.STANDARD_TERMS = TERM.TERM_ID),
1389: 0)*/
1390: -- + OKL_STREAM_BILLING_PVT.get_printing_lead_days(opp.khr_id)
1391: -- rmunjulu R12 Forward Port bug 5710903 Add ONE to account for scenario where these dates are same
1392: - nbd.earliest_strm_bill_date + 1)/30)
1393: from okl_k_control nbd
1394: where nbd.khr_id = opp.khr_id)