DBA Data[Home] [Help]

APPS.GMS_BUDGET_PUB dependencies on PA_LOOKUPS

Line 1627: FROM pa_lookups

1623:
1624: CURSOR l_budget_change_reason_csr ( p_change_reason_code VARCHAR2 )
1625: IS
1626: SELECT 'x'
1627: FROM pa_lookups
1628: WHERE lookup_type = 'BUDGET CHANGE REASON'
1629: AND lookup_code = p_change_reason_code;
1630:
1631: CURSOR l_budget_version_csr

Line 6332: FROM pa_lookups

6328:
6329: CURSOR l_budget_change_reason_csr ( p_change_reason_code VARCHAR2 )
6330: IS
6331: SELECT 'x'
6332: FROM pa_lookups
6333: WHERE lookup_type = 'BUDGET CHANGE REASON'
6334: AND lookup_code = p_change_reason_code;
6335:
6336: --needed for locking of budget rows

Line 6965: FROM pa_lookups

6961: -- needed to validate the change reason code for the Budget Line
6962: CURSOR l_budget_change_reason_csr ( p_change_reason_code VARCHAR2 )
6963: IS
6964: SELECT 'x'
6965: FROM pa_lookups
6966: WHERE lookup_type = 'BUDGET CHANGE REASON'
6967: AND lookup_code = p_change_reason_code;
6968:
6969: -- needed to get the budget_start_date of a period