APPS.MSC_ORG_SECURITY dependencies on MSC_ORG_ACCESS

Line 40: from msc_org_access

36: CURSOR record_exists_c(
37: lorg_id1 number,
38: linst_id1 number) IS
39: select 1
40: from msc_org_access
41: where responsibility_id = to_number(trim(p_resp_id))
42: and organization_id = lorg_id1
43: and sr_instance_id = linst_id1;
44: BEGIN

Line 193: v_statement := 'insert into msc_org_access(' ||

189: if (l_resp_appl_id is null) then
190: l_resp_appl_id := p_resp_appl_id;
191: end if;
192:
193: v_statement := 'insert into msc_org_access(' ||
194: 'ORGANIZATION_ID' ||
195: ',SR_INSTANCE_ID' ||
196: ',RESPONSIBILITY_ID' ||
197: ',RESP_APPLICATION_ID' ||

Line 270: v_statement := 'update msc_org_access set' ;

266: if (l_resp_appl_id is null) then
267: l_resp_appl_id := p_resp_appl_id;
268: end if;
269:
270: v_statement := 'update msc_org_access set' ;
271: if p_action = 'ADD' then
272: v_statement := v_statement ||' effective_from_date= :1,';
273: end if;
274: