SELECT asgn.assignment_id ,asgn.assignment_name ,asgn.start_date ,asgn.project_id ,res.person_id ,sch.start_date ,sch.end_date FROM pa_project_assignments asgn, pa_schedules sch, pa_resource_txn_attributes res WHERE asgn.assignment_type <> 'OPEN_ASSIGNMENT' AND asgn.resource_id = res.resource_id AND asgn.assignment_id = sch.assignment_id AND sch.assignment_id > -1 AND PA_PROJECT_UTILS.check_prj_stus_action_allowed(sch.status_code, 'STAFFED_ASGMT_NEW_TRANS') = 'Y'
SELECT ASGN.ASSIGNMENT_ID
, ASGN.ASSIGNMENT_NAME
, ASGN.START_DATE
, ASGN.PROJECT_ID
, RES.PERSON_ID
, SCH.START_DATE
, SCH.END_DATE
FROM PA_PROJECT_ASSIGNMENTS ASGN
, PA_SCHEDULES SCH
, PA_RESOURCE_TXN_ATTRIBUTES RES
WHERE ASGN.ASSIGNMENT_TYPE <> 'OPEN_ASSIGNMENT'
AND ASGN.RESOURCE_ID = RES.RESOURCE_ID
AND ASGN.ASSIGNMENT_ID = SCH.ASSIGNMENT_ID
AND SCH.ASSIGNMENT_ID > -1
AND PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(SCH.STATUS_CODE
, 'STAFFED_ASGMT_NEW_TRANS') = 'Y'
|
|
|