DBA Data[Home] [Help]

APPS.PA_SCHEDULE_PUB dependencies on PA_RESOURCE_TXN_ATTRIBUTES

Line 994: FROM pa_resource_txn_attributes a, pa_project_assignments b

990: l_new_resource_id NUMBER; -- 4537865
991: -- For retrieving resource_source_id
992: CURSOR get_resource_source_id IS
993: SELECT a.person_id, b.resource_id
994: FROM pa_resource_txn_attributes a, pa_project_assignments b
995: WHERE a.resource_id = b.resource_id
996: AND b.assignment_id = p_assignment_id;
997:
998: l_resource_source_id NUMBER;