APPS.PA_CLIENT_EXTN_BUDGET dependencies on PA_RESOURCE_ASSIGNMENTS

Line 28: SELECT resource_assignment_id FROM pa_resource_assignments

24: p_project_id in NUMBER,
25: p_task_id in NUMBER,
26: p_resource_list_member_id in NUMBER)
27: IS
28: SELECT resource_assignment_id FROM pa_resource_assignments
29: WHERE budget_version_id = p_budget_version_id AND
30: project_id = p_project_id AND
31: task_id = p_task_id AND
32: resource_list_member_id = p_resource_list_member_id;

Line 77: SELECT resource_assignment_id FROM pa_resource_assignments

73: p_project_id in NUMBER,
74: p_task_id in NUMBER,
75: p_resource_list_member_id in NUMBER)
76: IS
77: SELECT resource_assignment_id FROM pa_resource_assignments
78: WHERE budget_version_id = p_budget_version_id AND
79: project_id = p_project_id AND
80: task_id = p_task_id AND
81: resource_list_member_id = p_resource_list_member_id;

Line 129: SELECT resource_assignment_id FROM pa_resource_assignments

125: p_project_id in NUMBER,
126: p_task_id in NUMBER,
127: p_resource_list_member_id in NUMBER)
128: IS
129: SELECT resource_assignment_id FROM pa_resource_assignments
130: WHERE budget_version_id = p_budget_version_id AND
131: project_id = p_project_id AND
132: task_id = p_task_id AND
133: resource_list_member_id = p_resource_list_member_id;