APPS.EDW_TRD_PARTNER_PKG dependencies on EDW_LOCAL_INSTANCE

Line 22: from edw_local_instance;

18: IF (p_instance_code is NOT NULL) then
19: l_instance := p_instance_code;
20: ELSE
21: select instance_code into l_instance
22: from edw_local_instance;
23: END IF;
24:
25: l_tp := p_vendor_site_id || '-' || p_org_id
26: || '-' || l_instance

Line 54: from edw_local_instance;

50: IF (p_instance_code is NOT NULL) then
51: l_instance := p_instance_code;
52: ELSE
53: select instance_code into l_instance
54: from edw_local_instance;
55: END IF;
56:
57: l_tp := p_vendor_id || '-' || l_instance
58: || '-' || 'SUPPLIER' || '-' || 'TPRT';

Line 84: from edw_local_instance;

80: IF (p_instance_code is NOT NULL) then
81: l_instance := p_instance_code;
82: ELSE
83: select instance_code into l_instance
84: from edw_local_instance;
85: END IF;
86:
87: l_tp := p_cust_account_id || '-' || l_instance
88: || '-' || 'CUST_ACCT' || '-' || 'TPRT';

Line 114: from edw_local_instance;

110: IF (p_instance_code is NOT NULL) then
111: l_instance := p_instance_code;
112: ELSE
113: select instance_code into l_instance
114: from edw_local_instance;
115: END IF;
116:
117: l_tp := p_site_use_id || '-' || l_instance || '-' || 'CUST_SITE_USE';
118:

Line 142: from edw_local_instance;

138: IF (p_instance_code is NOT NULL) then
139: l_instance := p_instance_code;
140: ELSE
141: select instance_code into l_instance
142: from edw_local_instance;
143: END IF;
144:
145: l_tp := p_party_id || '-' || l_instance || '-' || 'PARTY' || '-' || 'TPRT';
146: