431: -- begin raverma 04182003 change AR_PAY_SCHED_ALL to org enabled view
432: BEGIN
433: select round(ps.due_date - sysdate) into l_DueInDays
434: from okc_k_headers_b chr
435: ,okc_rules_b sll
436: ,okc_rules_b slh
437: ,okc_rule_groups_b rg
438: ,OKL_CNSLD_AR_STRMS_B ST
439: ,okl_strm_type_v strm
432: BEGIN
433: select round(ps.due_date - sysdate) into l_DueInDays
434: from okc_k_headers_b chr
435: ,okc_rules_b sll
436: ,okc_rules_b slh
437: ,okc_rule_groups_b rg
438: ,OKL_CNSLD_AR_STRMS_B ST
439: ,okl_strm_type_v strm
440: ,AR_PAYMENT_SCHEDULES PS