APPS.ZX_TCM_BES_REGISTRATION_PVT dependencies on HZ_PARTY_SITES

Line 159: l_party_site_id HZ_PARTY_SITES.party_site_id%TYPE;

155: p_event IN OUT NOCOPY wf_event_t) RETURN VARCHAR2
156: IS
157:
158: l_party_id HZ_PARTIES.party_id%TYPE;
159: l_party_site_id HZ_PARTY_SITES.party_site_id%TYPE;
160:
161: l_tax_code ZX_PARTY_TAX_PROFILE.TAX_CLASSIFICATION_CODE%TYPE;
162: l_tax_header_level_flag ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE;
163: l_tax_rounding_rule ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE;

Line 193: FROM HZ_PARTY_SITES party

189: FND_GLOBAL.User_ID CREATED_BY,
190: SYSDATE LAST_UPDATE_DATE,
191: FND_GLOBAL.User_ID LAST_UPDATED_BY,
192: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
193: FROM HZ_PARTY_SITES party
194: WHERE PARTY_SITE_ID = l_party_site_id) PTY
195: ON (PTY.PARTY_SITE_ID = PTP.PARTY_ID)
196: WHEN MATCHED THEN UPDATE SET
197: PTP.REP_REGISTRATION_NUMBER = PTY.TAX_REFERENCE,

Line 322: FROM HZ_PARTY_SITES party

318: FND_GLOBAL.User_ID CREATED_BY,
319: SYSDATE LAST_UPDATE_DATE,
320: FND_GLOBAL.User_ID LAST_UPDATED_BY,
321: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
322: FROM HZ_PARTY_SITES party
323: WHERE party.request_id = p_request_id ) PTY
324: ON (PTY.PARTY_ID = PTP.PARTY_ID)
325: WHEN MATCHED THEN UPDATE SET
326: PTP.LAST_UPDATE_DATE=PTY.LAST_UPDATE_DATE,