1624:
1625: CURSOR l_budget_change_reason_csr ( p_change_reason_code VARCHAR2 )
1626: IS
1627: SELECT 'x'
1628: FROM pa_lookups
1629: WHERE lookup_type = 'BUDGET CHANGE REASON'
1630: AND lookup_code = p_change_reason_code;
1631:
1632: CURSOR l_budget_version_csr
6329:
6330: CURSOR l_budget_change_reason_csr ( p_change_reason_code VARCHAR2 )
6331: IS
6332: SELECT 'x'
6333: FROM pa_lookups
6334: WHERE lookup_type = 'BUDGET CHANGE REASON'
6335: AND lookup_code = p_change_reason_code;
6336:
6337: --needed for locking of budget rows
6962: -- needed to validate the change reason code for the Budget Line
6963: CURSOR l_budget_change_reason_csr ( p_change_reason_code VARCHAR2 )
6964: IS
6965: SELECT 'x'
6966: FROM pa_lookups
6967: WHERE lookup_type = 'BUDGET CHANGE REASON'
6968: AND lookup_code = p_change_reason_code;
6969:
6970: -- needed to get the budget_start_date of a period