DBA Data[Home] [Help]

APPS.PA_ASSIGNMENT_PROGRESS_PUB dependencies on PA_RESOURCE_ASSIGNMENTS

Line 506: FROM PA_RESOURCE_ASSIGNMENTS

502: l_cbs_element_id NUMBER(15);
503:
504: Cursor get_Cbs_element_id IS
505: SELECT CBS_ELEMENT_ID
506: FROM PA_RESOURCE_ASSIGNMENTS
507: WHERE project_id=p_project_id
508: AND resource_assignment_id = p_resource_assignment_id;
509:
510: BEGIN

Line 1125: FROM pa_resource_assignments pra,

1121: INTO l_rate_based_flag, l_resource_class_code, l_txn_currency_code,
1122: l_rbs_element_id, l_resource_list_member_id, l_scheduled_start_date,
1123: l_scheduled_finish_date,
1124: l_assignment_id -- Bug 4186007 : Derive res_assignment_id from AMG, it can be null
1125: FROM pa_resource_assignments pra,
1126: PA_PROJ_ELEMENT_VERSIONS PPEV
1127: where resource_list_member_id = l_resource_list_member_id
1128: AND PPEV.PROJECT_ID = p_project_id
1129: AND PPEV.PARENT_STRUCTURE_VERSION_ID = p_structure_version_id