APPS.OPI_DBI_OPEN_JOB_DTL_PKG dependencies on BIS_ORGANIZATIONS_V

Line 10: l_org bis_organizations_v.id%type;

6:
7: IS
8:
9: l_period_type VARCHAR2(255);
10: l_org bis_organizations_v.id%type;
11: l_item_org VARCHAR2(255);
12: l_item_cat VARCHAR2(255);
13: l_currency VARCHAR2(30);
14: l_jobstatus VARCHAR2(255);

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

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