APPS.PA_CLIENT_EXTN_GEN_ASSET_LINES dependencies on PA_PROJECT_ASSET_ASSIGNMENTS

Line 33: from pa_project_asset_assignments ppaa

29: x_asset_id IN OUT NOCOPY NUMBER) IS
30:
31: cursor get_project_asset_id is
32: select project_asset_id
33: from pa_project_asset_assignments ppaa
34: where ppaa.task_id = p_task_id
35: and ppaa.project_id = p_project_id
36: and nvl(ppaa.attribute8,'~!@#') = nvl(p_attribute8,'~!@#')
37: and nvl(ppaa.attribute9,'~!@#') = nvl(p_attribute9,'~!@#')