APPS.ZX_PARTY_TAX_PROFILE_PKG dependencies on HZ_PARTIES

Line 52: L_CREATED_BY_MODULE HZ_PARTIES.CREATED_BY_MODULE%TYPE;

48: X_RETURN_STATUS out NOCOPY VARCHAR2
49: ) is
50: L_PARTY_TAX_PROFILE_ID ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
51: L_EFFECTIVE_FROM_USE_LE ZX_PARTY_TAX_PROFILE.EFFECTIVE_FROM_USE_LE%TYPE := P_EFFECTIVE_FROM_USE_LE;
52: L_CREATED_BY_MODULE HZ_PARTIES.CREATED_BY_MODULE%TYPE;
53: CURSOR ptp_cur IS SELECT PARTY_TAX_PROFILE_ID FROM ZX_PARTY_TAX_PROFILE
54: WHERE PARTY_TAX_PROFILE_ID = L_PARTY_TAX_PROFILE_ID;
55: begin
56: --Initialise x_return_status variable

Line 65: from hz_parties where party_id = P_PARTY_ID;

61: BEGIN
62: -- Check created module name
63: select nvl(substr(created_by_module,1,3),'ZX') created_by_module
64: into L_CREATED_BY_MODULE
65: from hz_parties where party_id = P_PARTY_ID;
66: IF L_CREATED_BY_MODULE = 'XLE' THEN
67: return;
68: END IF;
69: EXCEPTION

Line 254: L_CREATED_BY_MODULE HZ_PARTIES.CREATED_BY_MODULE%TYPE;

250: P_COUNTRY_CODE IN VARCHAR2
251: ) is
252: L_PARTY_TAX_PROFILE_ID ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
253: L_EFFECTIVE_FROM_USE_LE ZX_PARTY_TAX_PROFILE.EFFECTIVE_FROM_USE_LE%TYPE := P_EFFECTIVE_FROM_USE_LE;
254: L_CREATED_BY_MODULE HZ_PARTIES.CREATED_BY_MODULE%TYPE;
255: CURSOR ptp_cur IS SELECT PARTY_TAX_PROFILE_ID FROM ZX_PARTY_TAX_PROFILE
256: WHERE PARTY_TAX_PROFILE_ID = L_PARTY_TAX_PROFILE_ID;
257: begin
258: --Initialise x_return_status variable

Line 265: from hz_parties where party_id = P_PARTY_ID;

261: BEGIN
262: -- Check created module name
263: select nvl(substr(created_by_module,1,3),'ZX') created_by_module
264: into L_CREATED_BY_MODULE
265: from hz_parties where party_id = P_PARTY_ID;
266: IF L_CREATED_BY_MODULE = 'XLE' THEN
267: return;
268: END IF;
269: EXCEPTION