DBA Data[Home] [Help]

APPS.BEN_CWB_WS_IMPORT_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 20: FROM PER_ASSIGNMENT_EXTRA_INFO ASS_EIT

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

Line 73: FROM PER_ASSIGNMENT_EXTRA_INFO ASS_EIT

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