DBA Data[Home] [Help]

APPS.PER_PERIODS_OF_SERVICE_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES_TL

Line 1707: FROM PER_ASSIGNMENT_STATUS_TYPES_TL STTTL

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