49:
50: l_debug number := ASO_DEBUG_PUB.G_DEBUG_LEVEL ;
51:
52: l_rel_type_code csi_i_org_assignments.relationship_type_code%TYPE := 'SERVICED_BY';
53: l_rule_code cs_multi_org_rules.multi_org_rule_code%TYPE;
54: l_rule_order cs_multi_org_rules.multi_org_rule_order%TYPE;
55: l_account_id NUMBER;
56: l_party_site_id NUMBER;
57: i NUMBER := 0;
50: l_debug number := ASO_DEBUG_PUB.G_DEBUG_LEVEL ;
51:
52: l_rel_type_code csi_i_org_assignments.relationship_type_code%TYPE := 'SERVICED_BY';
53: l_rule_code cs_multi_org_rules.multi_org_rule_code%TYPE;
54: l_rule_order cs_multi_org_rules.multi_org_rule_order%TYPE;
55: l_account_id NUMBER;
56: l_party_site_id NUMBER;
57: i NUMBER := 0;
58: l_profile varchar2(100);
59:
60: Cursor Cs_Mulorg is
61: select multi_org_rule_code
62: ,multi_org_rule_order
63: from cs_multi_org_rules
64: order by multi_org_rule_order;
65:
66: CURSOR l_RC_csr IS
67: SELECT b.authoring_org_id