DBA Data[Home] [Help]

APPS.HXC_PROJ_MANAGER_APPROVAL_PKG dependencies on HXC_TIME_RECIPIENTS

Line 15: select TIME_RECIPIENT_ID from HXC_TIME_RECIPIENTs where APPLICATION_ID = 275 ;

11: -- Getting the Time recepient id for Projects application (APPLICATION_ID = 275 )
12:
13: cursor csr_get_recipient_id
14: is
15: select TIME_RECIPIENT_ID from HXC_TIME_RECIPIENTs where APPLICATION_ID = 275 ;
16:
17: cursor csr_get_ela_approval_comp(l_approval_style_id in number)
18: is
19: select APPROVAL_COMP_ID, OBJECT_VERSION_NUMBER from hxc_approval_comps where APPROVAL_MECHANISM = 'ENTRY_LEVEL_APPROVAL' and APPROVAL_STYLE_ID = l_approval_style_id;