DBA Data[Home] [Help]

APPS.MSC_ORG_SECURITY dependencies on MSC_SELECTED_ORGS_V

Line 23: from msc_selected_orgs_v mso

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

Line 30: from msc_selected_orgs_v mso

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