APPS.ZX_PTP_IMPORT dependencies on HZ_PARTIES

Line 1198: (SELECT 1 FROM hz_parties WHERE party_id = intf.party_id)

1194: AND party_type_code = 'THIRD_PARTY'
1195: AND dml_type = 'UPDATE'
1196: AND ( ( party_id IS NOT NULL
1197: AND NOT EXISTS
1198: (SELECT 1 FROM hz_parties WHERE party_id = intf.party_id)
1199: )
1200: OR
1201: ( party_id IS NULL
1202: AND party_name IS NOT NULL

Line 1204: (SELECT 1 FROM hz_parties WHERE party_name = intf.party_name)

1200: OR
1201: ( party_id IS NULL
1202: AND party_name IS NOT NULL
1203: AND NOT EXISTS
1204: (SELECT 1 FROM hz_parties WHERE party_name = intf.party_name)
1205: )
1206: OR
1207: ( party_id IS NULL
1208: AND party_name IS NULL

Line 1211: (SELECT 1 FROM hz_parties

1207: ( party_id IS NULL
1208: AND party_name IS NULL
1209: AND intf_party_reference IS NOT NULL
1210: AND NOT EXISTS
1211: (SELECT 1 FROM hz_parties
1212: WHERE orig_system_reference = intf.intf_party_reference)
1213: )
1214: );
1215:

Line 1224: FROM hz_parties

1220:
1221: UPDATE zx_party_tax_profile_int intf
1222: SET party_id = CASE WHEN party_id IS NULL AND party_name IS NOT NULL
1223: THEN (SELECT party_id
1224: FROM hz_parties
1225: WHERE party_name = intf.party_name)
1226: WHEN party_id is NULL
1227: AND party_name IS NULL
1228: AND intf_party_reference IS NOT NULL

Line 1230: FROM hz_parties

1226: WHEN party_id is NULL
1227: AND party_name IS NULL
1228: AND intf_party_reference IS NOT NULL
1229: THEN (SELECT 1
1230: FROM hz_parties
1231: WHERE orig_system_reference =
1232: intf.intf_party_reference)
1233: END
1234: WHERE record_status = G_RS_IN_PROCESS

Line 3215: FROM zx_party_tax_profile ptp, hz_parties pty

3211: WHERE (( tax_authority_id IS NOT NULL
3212: AND NOT EXISTS
3213: (
3214: SELECT 1
3215: FROM zx_party_tax_profile ptp, hz_parties pty
3216: WHERE ptp.party_type_code ='TAX_AUTHORITY'
3217: AND ptp.party_id = ptp.party_id
3218: AND pty.party_type = 'ORGANIZATION'
3219: AND ptp.party_tax_profile_id = reg_int.tax_authority_id

Line 3228: FROM zx_party_tax_profile ptp, hz_parties pty

3224: AND tax_authority_name IS NOT NULL
3225: AND NOT EXISTS
3226: (
3227: SELECT 1
3228: FROM zx_party_tax_profile ptp, hz_parties pty
3229: WHERE ptp.party_type_code ='TAX_AUTHORITY'
3230: AND ptp.party_id = PTY.party_id
3231: AND pty.party_type = 'ORGANIZATION'
3232: AND pty.party_name = reg_int.tax_authority_name

Line 3248: FROM zx_party_tax_profile ptp, hz_parties pty

3244: -- value to id conversion for tax_authority_id
3245: UPDATE zx_registrations_int reg_int
3246: SET tax_authority_id = (
3247: SELECT PTP.party_tax_profile_id
3248: FROM zx_party_tax_profile ptp, hz_parties pty
3249: WHERE ptp.party_type_code ='TAX_AUTHORITY'
3250: AND ptp.party_id = PTY.party_id
3251: AND pty.party_type = 'ORGANIZATION'
3252: AND pty.party_name = reg_int.tax_authority_name

Line 5064: hz_parties PTY

5060: AND NOT EXISTS
5061: (
5062: SELECT 1
5063: FROM zx_party_tax_profile PTP,
5064: hz_parties PTY
5065: WHERE PTP.party_type_code ='TAX_AUTHORITY'
5066: AND PTP.party_id = PTY.party_id
5067: AND PTP.party_tax_profile_id = exe_int.issuing_tax_authority_id
5068: )

Line 5077: hz_parties PTY

5073: AND NOT EXISTS
5074: (
5075: SELECT PTY.party_name
5076: FROM zx_party_tax_profile PTP,
5077: hz_parties PTY
5078: WHERE PTP.party_type_code ='TAX_AUTHORITY'
5079: AND PTP.party_id = PTY.party_id
5080: AND PTy.party_name = exe_int.issuing_tax_authority_name
5081: )

Line 5098: hz_parties PTY

5094: SET issuing_tax_authority_id =
5095: (
5096: SELECT PTP.party_tax_profile_id
5097: FROM zx_party_tax_profile PTP,
5098: hz_parties PTY
5099: WHERE PTP.party_type_code ='TAX_AUTHORITY'
5100: AND PTP.party_id = PTY.party_id
5101: AND PTY.party_name = exe_int.issuing_tax_authority_name
5102: )

Line 7806: -- FROM hz_parties

7802:
7803: -- sample code for p_sql_select_valid_party_id
7804: -- SELECT party_id, 'THIRD_PARTY' as party_type_code, orig_system_reference as intf_party_reference, NULL as intf_party_site_reference
7805: -- sample code for p_sql_from_valid_party_id
7806: -- FROM hz_parties
7807: -- WHERE request_id = G_REQUEST_ID
7808: -- AND .. ..
7809: l_date6 := SYSDATE;
7810: IF p_sql_select_valid_party_id IS NOT NULL

Line 7924: -- FROM hz_parties hz_insert

7920: -- sample code for p_sql_select_insert_ptp_prod
7921: -- SELECT party_id, 'THIRD_PARTY'
7922: --
7923: -- sample code for p_sql_from_insert_ptp_prod
7924: -- FROM hz_parties hz_insert
7925: -- WHERE request_id = G_REQUEST_ID
7926: BEGIN
7927:
7928: l_dynamic_sql := 'INSERT INTO ZX_PARTY_TAX_PROFILE'