DBA Data[Home] [Help]

APPS.PA_FP_CALC_PLAN_PUB dependencies on PA_BUDGET_LINES

Line 137: pa_budget_lines pbl

133: pra.resource_assignment_id raid,
134: pbl.txn_currency_code
135: from
136: pa_resource_assignments pra,
137: pa_budget_lines pbl
138: where pra.project_id = l_project_id
139: and pra.budget_version_id = l_budget_version_id
140: AND pra.resource_class_code = l_resource_class_code
141: and pra.resource_assignment_id = pbl.resource_assignment_id

Line 147: FROM pa_budget_lines

143: GROUP BY pra.resource_assignment_id, pbl.txn_currency_code;
144:
145: CURSOR c_get_txn_curr_code(l_resource_assignment_id NUMBER) IS
146: SELECT distinct txn_currency_code
147: FROM pa_budget_lines
148: WHERE resource_assignment_id = l_resource_assignment_id;
149:
150: CURSOR C_VALIDATE_FP_BUDGET_VERSION (l_budget_version_id NUMBER, l_project_id NUMBER )
151: IS

Line 164: FROM pa_budget_lines

160: FROM DUAL
161: WHERE EXISTS
162: (
163: SELECT TXN_CURRENCY_CODE
164: FROM pa_budget_lines
165: WHERE txn_currency_code = l_currency_code
166: AND resource_assignment_id = l_resource_assignment_id
167: AND budget_version_id = l_budget_version_id
168: );