DBA Data[Home] [Help]

APPS.OPI_DBI_RES_VAR_JOB_DTL_PKG dependencies on BIS_ORGANIZATIONS_V

Line 130: select id into l_org from (select id from bis_organizations_v where responsibility_id = l_respid order by value asc) where rownum=1;

126:
127: IF (l_org is NULL) THEN
128:
129: select fnd_global.resp_id into l_respid from dual ;
130: select id into l_org from (select id from bis_organizations_v where responsibility_id = l_respid order by value asc) where rownum=1;
131:
132: ELSE
133:
134: select process_enabled_flag