APPS.PA_FP_CALC_PLAN_PUB dependencies on DUAL

Line 120: FROM DUAL

116: ( l_project_id NUMBER , l_budget_version_id NUMBER
117: , l_resource_assignment_id NUMBER
118: ) IS
119: SELECT '1'
120: FROM DUAL
121: WHERE EXISTS
122: (
123: SELECT resource_assignment_id
124: FROM PA_RESOURCE_ASSIGNMENTS

Line 160: FROM DUAL

156: AND bv.ci_id IS NULL;
157:
158: CURSOR c_validate_curr_code(l_currency_code VARCHAR2 , l_resource_assignment_id NUMBER, l_budget_version_id NUMBER) IS
159: SELECT 'Y'
160: FROM DUAL
161: WHERE EXISTS
162: (
163: SELECT TXN_CURRENCY_CODE
164: FROM pa_budget_lines