15: /*new cursor for bug no 2413400*/
16: Cursor p_product_code_csr (p_pm_product_code IN VARCHAR2)
17: Is
18: Select 'X'
19: from pa_lookups
20: where lookup_type='PM_PRODUCT_CODE'
21: and lookup_code = p_pm_product_code;
22:
23: -- Added by Xin Liu 24-APR-03
9323:
9324: CURSOR l_budget_change_reason_csr ( p_change_reason_code VARCHAR2 )
9325: IS
9326: SELECT 'x'
9327: FROM pa_lookups
9328: WHERE lookup_type = 'BUDGET CHANGE REASON'
9329: AND lookup_code = p_change_reason_code;
9330:
9331: --needed for locking of budget rows