[Home] [Help]
84:
85: -- This cursor is used to make sure that the profile does not already exist for a contract.
86: CURSOR l_oklprtfl_csr IS
87: SELECT 'x'
88: FROM okl_prtfl_cntrcts_b
89: WHERE khr_id = p_contract_id;
90:
91: BEGIN
92:
796:
797: -- This cursor is used to get the contracts that need to be updated.
798: CURSOR l_cntrctprtfl_csr IS
799: SELECT h.id header_id, l.id line_id , l.fma_id fma_id, h.khr_id khr_id, l.budget_amount
800: FROM okl_prtfl_cntrcts_b h, okl_prtfl_lines_b l
801: WHERE h.id = l.pfc_id
802: AND l.fma_id IS NOT NULL -- profiles that use budget amount formula
803: AND ((p_contract_id IS NOT NULL AND h.khr_id = p_contract_id) OR (p_contract_id IS NULL));
804:
1196:
1197: -- This cursor is used to get the portfolios that need to be executed.
1198: CURSOR l_cntrctprtfl_csr(p_date DATE) IS
1199: SELECT h.id header_id, l.id line_id , h.khr_id khr_id, khr.contract_number contract_number, l.tmb_id
1200: FROM okl_prtfl_cntrcts_b h, okl_prtfl_lines_b l, okc_k_headers_b khr
1201: WHERE h.id = l.pfc_id
1202: AND h.khr_id = khr.id
1203: AND l.date_strategy_executed IS NULL
1204: AND khr.sts_code = 'BOOKED'