APPS.MSC_SECRULE_PKG dependencies on MSC_COMPANIES

Line 554: from msc_companies mc

550: if p_company_name is not null then
551: BEGIN
552: --dbms_output.put_line('before the company id select'||p_company_name );
553: sql_statement :='Select mc.company_id
554: from msc_companies mc
555: where mc.company_name=:1';
556:
557: OPEN sec_cursor FOR sql_statement USING
558: p_company_name;

Line 677: from msc_companies where

673:
674: if p_customer_name is not null then
675: BEGIN
676: select company_id into l_cust_company_id
677: from msc_companies where
678: company_name=p_customer_name;
679: --dbms_output.put_line('Customer company id exists'|| l_cust_company_id );
680: exception when no_data_found then
681: p_return_code:=-1;

Line 692: msc_companies mc

688: else
689: BEGIN
690: Select mcr.subject_id into l_customer_id
691: from msc_company_relationships mcr,
692: msc_companies mc
693: where
694: mcr.subject_id = mc.company_id
695: and mcr.relationship_type = 2
696: and mcr.object_id =l_company_id

Line 732: from msc_companies

728: BEGIN
729: if p_supplier_name is not null then
730: BEGIN
731: Select company_id into l_supp_company_id
732: from msc_companies
733: where company_name=p_supplier_name;
734: --dbms_output.put_line('Suppliercompany id exists'|| l_supp_company_id );
735: exception when no_data_found then
736: p_return_code:=-1;

Line 748: msc_companies mc

744: else
745: BEGIN
746: Select mcr.subject_id into l_supplier_id
747: from msc_company_relationships mcr,
748: msc_companies mc
749: where
750: mcr.subject_id = mc.company_id
751: and mcr.relationship_type = 1
752: and mcr.object_id =l_company_id

Line 933: select company_id into l_grantee_key from msc_companies

929: if p_grantee_type = 'COMPANY' then
930:
931: if p_grantee_key is not null then
932: BEGIN
933: select company_id into l_grantee_key from msc_companies
934: where company_name=p_grantee_key;
935:
936: -- --dbms_output.put_line('grantee key Exists' ||l_item_id);
937: