DBA Data[Home] [Help]

APPS.BEN_CWB_WS_IMPORT_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 21: FROM PER_ASSIGNMENT_EXTRA_INFO ASS_EIT

17: ,p_assignment_extra_info_id out nocopy number
18: ,p_object_version_number out nocopy number) is
19: Cursor Csr_EIT_Dtls IS
20: SELECT 'Y'
21: FROM PER_ASSIGNMENT_EXTRA_INFO ASS_EIT
22: WHERE ASS_EIT.INFORMATION_TYPE = 'CWBRANK'
23: AND ASS_EIT.ASSIGNMENT_ID = p_assignment_Id
24: AND ASS_EIT.AEI_INFORMATION2 = p_rank_by_person_id
25: AND ASS_EIT.AEI_INFORMATION5 IS NULL

Line 74: FROM PER_ASSIGNMENT_EXTRA_INFO ASS_EIT

70: Cursor Csr_EIT_Dtls(l_assignment_Id IN NUMBER )
71: IS
72: SELECT ASS_EIT.ASSIGNMENT_EXTRA_INFO_ID ,
73: ASS_EIT.OBJECT_VERSION_NUMBER
74: FROM PER_ASSIGNMENT_EXTRA_INFO ASS_EIT
75: WHERE ASS_EIT.INFORMATION_TYPE = 'CWBRANK'
76: AND ASS_EIT.ASSIGNMENT_ID = l_assignment_Id
77: AND ASS_EIT.AEI_INFORMATION2 = P_USER_ID
78: AND ASS_EIT.AEI_INFORMATION5 IS NULL