APPS.ZX_TCM_BES_REGISTRATION_PVT dependencies on HZ_PARTIES

Line 59: l_party_id HZ_PARTIES.party_id%TYPE;

55: FUNCTION PARTY_TAX_PROF_TRD_PARTY(
56: p_subscription_guid IN RAW,
57: p_event IN OUT NOCOPY wf_event_t) RETURN VARCHAR2
58: IS
59: l_party_id HZ_PARTIES.party_id%TYPE;
60:
61: l_tax_code ZX_PARTY_TAX_PROFILE.TAX_CLASSIFICATION_CODE%TYPE;
62: l_tax_header_level_flag ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE;
63: l_tax_rounding_rule ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE;

Line 101: FROM HZ_PARTIES party

97: FND_GLOBAL.User_ID CREATED_BY,
98: SYSDATE LAST_UPDATE_DATE,
99: FND_GLOBAL.User_ID LAST_UPDATED_BY,
100: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
101: FROM HZ_PARTIES party
102: WHERE PARTY_ID = l_party_id) PTY
103: ON (PTY.PARTY_ID = PTP.PARTY_ID)
104: WHEN MATCHED THEN UPDATE SET
105: PTP.REP_REGISTRATION_NUMBER = PTY.TAX_REFERENCE,

Line 158: l_party_id HZ_PARTIES.party_id%TYPE;

154: p_subscription_guid IN RAW,
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;

Line 265: FROM HZ_PARTIES party

261: FND_GLOBAL.User_ID CREATED_BY,
262: SYSDATE LAST_UPDATE_DATE,
263: FND_GLOBAL.User_ID LAST_UPDATED_BY,
264: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
265: FROM HZ_PARTIES party
266: WHERE party.request_id = p_request_id
267: AND (party.party_type ='ORGANIZATION' OR party.party_type ='PERSON')) PTY
268: ON (PTY.PARTY_ID = PTP.PARTY_ID)
269: WHEN MATCHED THEN UPDATE SET