DBA Data[Home] [Help]

APPS.BIS_RESPONSIBILITY_PVT dependencies on FND_RESPONSIBILITY_VL

Line 42: from fnd_responsibility_vl a,

38: cursor rsp_cur is
39: select a.responsibility_id,
40: a.responsibility_key,
41: a.responsibility_name
42: from fnd_responsibility_vl a,
43: fnd_user_resp_groups b
44: where b.user_id = p_user_id
45: and b.responsibility_id = a.responsibility_id
46: and b.start_date <= sysdate

Line 99: from fnd_responsibility_vl a,

95: cursor rsp_cur(p_version VARCHAR2) is
96: select a.responsibility_id,
97: a.responsibility_key,
98: a.responsibility_name
99: from fnd_responsibility_vl a,
100: fnd_user_resp_groups b
101: where b.user_id = p_user_id
102: and b.responsibility_id = a.responsibility_id
103: and b.start_date <= sysdate

Line 160: from fnd_responsibility_vl

156: cursor resp_cur is
157: select RESPONSIBILITY_ID
158: , RESPONSIBILITY_KEY
159: , RESPONSIBILITY_NAME
160: from fnd_responsibility_vl
161: where VERSION='W'
162: and start_date <= sysdate
163: and nvl(end_date, sysdate) >= sysdate
164: order by RESPONSIBILITY_NAME;

Line 215: from fnd_responsibility_vl

211: , RESPONSIBILITY_NAME
212: into x_Responsibility_Rec.RESPONSIBILITY_ID
213: , x_Responsibility_Rec.RESPONSIBILITY_SHORT_NAME
214: , x_Responsibility_Rec.RESPONSIBILITY_NAME
215: from fnd_responsibility_vl
216: where VERSION='W'
217: and start_date <= sysdate
218: and nvl(end_date, sysdate) >= sysdate
219: and RESPONSIBILITY_ID=p_Responsibility_Rec.RESPONSIBILITY_ID;