APPS.OKL_PAY_INVOICES_MAN_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 51

    	   SELECT chr.authoring_org_id
    	   FROM okc_k_headers_b chr
    	   WHERE id =  p_khr_id;

Line: 56

    	   SELECT hru.set_of_books_id
    	   FROM HR_OPERATING_UNITS HRU
    	   WHERE ORGANIZATION_ID = p_org_id;

Line: 61

     	   SELECT id
    	   FROM okl_trx_types_tl
    	   WHERE name = 'Disbursement'
    	   AND language= 'US';

Line: 67

     	   SELECT khr.pdt_id
     	   FROM okl_k_headers khr
     	   WHERE khr.id =  p_khr_id;

Line: 81

        SELECT  currency_code
               ,currency_conversion_type
               ,currency_conversion_rate
               ,currency_conversion_date
        FROM    okl_k_headers_full_v
        WHERE   id = cp_khr_id;

Line: 134

	SELECT	hru.set_of_books_id
	INTO	lp_tapv_rec.set_of_books_id
	FROM	HR_OPERATING_UNITS HRU
	WHERE	ORGANIZATION_ID = lp_tapv_rec.org_id;

Line: 308

	 -- Populate inserted record details back
	 --------------------------------------------
	 x_man_inv_rec  := p_man_inv_rec;