DBA Data[Home] [Help]

APPS.JTF_MSITE_RESP_MGR_PVT dependencies on JTF_MSITE_RESPS_VL

Line 401: FROM jtf_msite_resps_vl MR, fnd_responsibility_vl R, fnd_application_vl A

397: MR.object_version_number, R.responsibility_id, R.application_id,
398: MR.display_name, A.application_name,
399: R.responsibility_key, R.responsibility_name, MR.start_date_active,
400: MR.end_date_active, MR.sort_order
401: FROM jtf_msite_resps_vl MR, fnd_responsibility_vl R, fnd_application_vl A
402: WHERE MR.msite_id = p_msite_id
403: AND MR.responsibility_id = R.responsibility_id
404: AND MR.application_id = R.application_id
405: AND R.application_id = A.application_id;

Line 414: FROM jtf_msite_resps_vl MR, fnd_responsibility_vl R, fnd_application_vl A

410: MR.object_version_number, R.responsibility_id, R.application_id,
411: MR.display_name, A.application_name,
412: R.responsibility_key, R.responsibility_name, MR.start_date_active,
413: MR.end_date_active, MR.sort_order
414: FROM jtf_msite_resps_vl MR, fnd_responsibility_vl R, fnd_application_vl A
415: WHERE MR.msite_id = p_msite_id
416: AND MR.application_id = p_application_id
417: AND MR.responsibility_id = R.responsibility_id
418: AND MR.application_id = R.application_id