DBA Data[Home] [Help]

APPS.PA_BUDGET_PUB dependencies on PA_LOOKUPS

Line 19: from pa_lookups

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

Line 9146: FROM pa_lookups

9142:
9143: CURSOR l_budget_change_reason_csr ( p_change_reason_code VARCHAR2 )
9144: IS
9145: SELECT 'x'
9146: FROM pa_lookups
9147: WHERE lookup_type = 'BUDGET CHANGE REASON'
9148: AND lookup_code = p_change_reason_code;
9149:
9150: --needed for locking of budget rows