DBA Data[Home] [Help]

APPS.PA_FP_CALC_PLAN_PUB dependencies on PA_RESOURCE_ASSIGNMENTS

Line 124: FROM PA_RESOURCE_ASSIGNMENTS

120: FROM DUAL
121: WHERE EXISTS
122: (
123: SELECT resource_assignment_id
124: FROM PA_RESOURCE_ASSIGNMENTS
125: WHERE PROJECT_ID = l_project_id
126: AND BUDGET_VERSION_ID = l_budget_version_id
127: AND RESOURCE_ASSIGNMENT_ID = l_resource_assignment_id
128: );

Line 136: pa_resource_assignments pra,

132: select
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