1703: ,p_status in out nocopy VARCHAR2
1704: ,p_assignment_status_id in out nocopy number) is
1705: cursor st1 is SELECT NVL(STATL.USER_STATUS,STTTL.USER_STATUS)
1706: , STT.ASSIGNMENT_STATUS_TYPE_ID
1707: FROM PER_ASSIGNMENT_STATUS_TYPES_TL STTTL
1708: , PER_ASSIGNMENT_STATUS_TYPES STT
1709: , PER_ASS_STATUS_TYPE_AMENDS_TL STATL
1710: , PER_ASS_STATUS_TYPE_AMENDS STA
1711: , PER_ALL_ASSIGNMENTS_F ASG
1704: ,p_assignment_status_id in out nocopy number) is
1705: cursor st1 is SELECT NVL(STATL.USER_STATUS,STTTL.USER_STATUS)
1706: , STT.ASSIGNMENT_STATUS_TYPE_ID
1707: FROM PER_ASSIGNMENT_STATUS_TYPES_TL STTTL
1708: , PER_ASSIGNMENT_STATUS_TYPES STT
1709: , PER_ASS_STATUS_TYPE_AMENDS_TL STATL
1710: , PER_ASS_STATUS_TYPE_AMENDS STA
1711: , PER_ALL_ASSIGNMENTS_F ASG
1712: WHERE ASG.PERSON_ID = p_person_id