APPS.HZ_CUSTOMER_INT dependencies on ZX_PARTY_TAX_PROFILE

Line 3157: MERGE INTO ZX_PARTY_TAX_PROFILE PTP

3153:
3154: BEGIN
3155:
3156: -- Import Party
3157: MERGE INTO ZX_PARTY_TAX_PROFILE PTP
3158: USING
3159: (SELECT 'THIRD_PARTY' PARTY_TYPE_CODE,
3160: party.party_id PARTY_ID,
3161: party.country COUNTRY_CODE, --4742586

Line 3217: ZX_PARTY_TAX_PROFILE_S.NEXTVAL,

3213: REQUEST_ID,
3214: OBJECT_VERSION_NUMBER,
3215: COUNTRY_CODE)--4742586
3216: VALUES (PTY.PARTY_TYPE_CODE,
3217: ZX_PARTY_TAX_PROFILE_S.NEXTVAL,
3218: PTY.PARTY_ID,
3219: PTY.PROGRAM_LOGIN_ID,
3220: PTY.TAX_REFERENCE,
3221: PTY.CREATION_DATE,

Line 3234: MERGE INTO ZX_PARTY_TAX_PROFILE PTP

3230: PTY.COUNTRY_CODE );--4742586
3231:
3232: -- Bug 6682585
3233: -- Insert Contact Person Parties
3234: MERGE INTO ZX_PARTY_TAX_PROFILE PTP
3235: USING
3236: (SELECT 'THIRD_PARTY' PARTY_TYPE_CODE,
3237: party.party_id PARTY_ID,
3238: party.country COUNTRY_CODE,

Line 3287: ZX_PARTY_TAX_PROFILE_S.NEXTVAL,

3283: REQUEST_ID,
3284: OBJECT_VERSION_NUMBER,
3285: COUNTRY_CODE)
3286: VALUES (PTY.PARTY_TYPE_CODE,
3287: ZX_PARTY_TAX_PROFILE_S.NEXTVAL,
3288: PTY.PARTY_ID,
3289: PTY.PROGRAM_LOGIN_ID,
3290: PTY.TAX_REFERENCE,
3291: PTY.CREATION_DATE,

Line 3305: MERGE INTO ZX_PARTY_TAX_PROFILE PTP

3301:
3302:
3303:
3304: -- Import Party Sites
3305: MERGE INTO ZX_PARTY_TAX_PROFILE PTP
3306: USING
3307: (SELECT 'THIRD_PARTY_SITE' PARTY_TYPE_CODE,
3308: ps.party_site_id PARTY_ID,
3309: loc.country COUNTRY_CODE,--4742586

Line 3360: ZX_PARTY_TAX_PROFILE_S.NEXTVAL,

3356: OBJECT_VERSION_NUMBER,
3357: COUNTRY_CODE)--4742586
3358: VALUES (
3359: PTY.PARTY_TYPE_CODE,
3360: ZX_PARTY_TAX_PROFILE_S.NEXTVAL,
3361: PTY.PARTY_ID,
3362: PTY.PROGRAM_LOGIN_ID,
3363: PTY.TAX_REFERENCE,
3364: PTY.CREATION_DATE,