APPS.PO_CHANGEORDERWF_PVT dependencies on FND_RESPONSIBILITY

Line 8067: fnd_responsibility fr,

8063: cursor l_get_user_info_csr
8064: is
8065: select fr.responsibility_id,fu.user_id
8066: from wf_local_user_roles wur,
8067: fnd_responsibility fr,
8068: financials_system_params_all fsp,
8069: fnd_user fu
8070: where wur.user_name = fu.user_name
8071: and wur.role_orig_system = 'FND_RESP'

Line 8132: fnd_responsibility fr,

8128: l_progress := '002';
8129: select fr.responsibility_id
8130: into l_resp_id
8131: from wf_local_user_roles wur,
8132: fnd_responsibility fr,
8133: financials_system_params_all fsp
8134: where
8135: wur.role_orig_system = 'FND_RESP'
8136: and wur.role_orig_system_id = fr.responsibility_id

Line 8191: fnd_responsibility fr,

8187:
8188: select MIN(fr.responsibility_id)
8189: into l_resp_id
8190: from wf_local_user_roles wur,
8191: fnd_responsibility fr,
8192: financials_system_params_all fsp,
8193: fnd_user fu
8194: where wur.user_name = fu.user_name
8195: and fu.user_id = l_user_id

Line 8230: fnd_responsibility fr,

8226: BEGIN
8227: select MIN(fr.responsibility_id),fu.user_id
8228: into l_resp_id,l_user_id
8229: from wf_local_user_roles wur,
8230: fnd_responsibility fr,
8231: financials_system_params_all fsp,
8232: fnd_user fu
8233: where wur.user_name = fu.user_name
8234: and wur.role_orig_system = 'FND_RESP'