DBA Data[Home] [Help]

APPS.CS_MULTIORG_PVT dependencies on CS_MULTI_ORG_RULES

Line 53: l_rule_code cs_multi_org_rules.multi_org_rule_code%TYPE;

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;

Line 54: l_rule_order cs_multi_org_rules.multi_org_rule_order%TYPE;

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);

Line 63: from cs_multi_org_rules

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