APPS.OPI_DBI_RES_EFF_JOB_DTL_PKG dependencies on BIS_ORGANIZATIONS_V

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

118:
119: IF (l_org is NULL) THEN
120:
121: select fnd_global.resp_id into l_respid from dual ;
122: select id into l_org from (select id from bis_organizations_v where responsibility_id = l_respid order by value asc) where rownum=1;
123:
124: ELSE
125:
126: select process_enabled_flag