DBA Data[Home] [Help]

APPS.PA_ASSIGNMENT_UTILS dependencies on PA_RESOURCES_DENORM

Line 840: ( p_person_id IN pa_resources_denorm.person_id%TYPE

836: -- U otherwise
837: -- x_error_message_code OUT
838: --
839: PROCEDURE Get_Person_Asgmt
840: ( p_person_id IN pa_resources_denorm.person_id%TYPE
841: ,p_project_id IN pa_project_assignments.project_id%TYPE
842: ,p_ei_date IN DATE
843: ,x_assignment_name IN OUT NOCOPY pa_project_assignments.assignment_name%TYPE --File.Sql.39 bug 4440895
844: ,x_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895

Line 1293: pa_resources_denorm rd,

1289: per_person_type_usages_f ptuf,
1290: per_person_types ppt,
1291: per_all_assignments_f aaf,
1292: pa_resource_txn_attributes rta,
1293: pa_resources_denorm rd,
1294: per_all_people_f peo
1295: where asgn.project_id = p_project_id
1296: and asgn.resource_id = rta.resource_id
1297: and rta.person_id = aaf.person_id