APPS.MSC_SECRULE_PKG dependencies on MSC_COMPANY_SITES

Line 789: from msc_company_sites

785: if (p_customer_site_name is not null ) and (l_customer_flag= true) then
786:
787: BEGIN
788: select company_site_id into l_cust_site_company_id
789: from msc_company_sites
790: where company_id=l_company_id
791: and company_site_name=p_customer_site_name;
792: --dbms_output.put_line('Customer company id exists'|| l_cust_company_id );
793: exception when no_data_found then

Line 804: msc_company_sites cs

800: else
801: BEGIN
802: select cs.company_site_id into l_customer_site_id
803: from msc_company_relationships mcr,
804: msc_company_sites cs
805: where mcr.subject_id = cs.company_id
806: and mcr.relationship_type = 2
807: and mcr.object_id=l_company_id
808: and cs.company_site_name=p_customer_site_name

Line 848: from msc_company_sites

844: if (p_supplier_site_name is not null) and (l_supplier_flag=true) then
845:
846: BEGIN
847: select company_site_id into l_supp_site_company_id
848: from msc_company_sites
849: where company_id=l_company_id
850: and company_site_name=p_supplier_site_name;
851: --dbms_output.put_line('Supplier company id exists'|| l_cust_company_id );
852: exception when no_data_found then

Line 864: msc_company_sites cs

860:
861: BEGIN
862: select cs.company_site_id into l_supplier_site_id
863: from msc_company_relationships mcr,
864: msc_company_sites cs
865: where mcr.subject_id = cs.company_id
866: and mcr.relationship_type = 1--( 'supplier of ' )
867: and mcr.object_id=l_company_id
868: and cs.company_site_name=p_supplier_site_name

Line 904: from msc_company_sites

900: BEGIN
901: if p_org_name is not null then
902: BEGIN
903: select company_site_id into l_org_id
904: from msc_company_sites
905: where company_id=l_company_id
906: and company_site_name=p_org_name;
907:
908: -- --dbms_output.put_line('Org Name Exists' ||l_item_id);