DBA Data[Home] [Help]

APPS.MSC_ORG_SECURITY dependencies on MSC_SELECTED_ORGS_V

Line 24: from msc_selected_orgs_v mso

20: -- org security record
21:
22: CURSOR current_orgs (p_resp_id varchar2) is
23: select organization_id, sr_instance_id
24: from msc_selected_orgs_v mso
25: where mso.responsibility_id = p_resp_id;
26:
27: CURSOR org_assigned_c(
28: lorg_id number,

Line 31: from msc_selected_orgs_v mso

27: CURSOR org_assigned_c(
28: lorg_id number,
29: linst_id number) IS
30: select organization_id
31: from msc_selected_orgs_v mso
32: where mso.responsibility_id = trim(p_resp_id)
33: and mso.organization_id = lorg_id
34: and mso.sr_instance_id = linst_id;
35: