APPS.MSC_SECRULE_PKG dependencies on MSC_COMPANY_RELATIONSHIPS

Line 691: from msc_company_relationships mcr,

687: l_customer_flag:=true;
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

Line 747: from msc_company_relationships mcr,

743:
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

Line 803: from msc_company_relationships mcr,

799: l_customer_site_id:=l_cust_site_company_id;
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

Line 863: from msc_company_relationships mcr,

859: else
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