DBA Data[Home] [Help]

APPS.HZ_PURGE_GEN dependencies on AHL_DOCUMENTS_B

Line 1115: exists (select 'Y' from AHL_DOCUMENTS_B xx where xx.SOURCE_PARTY_ID = temp.party_id

1111: if(regid_proc = true) then
1112: insert into hz_application_trans_gt(app_id,party_id) select 867, temp.party_id from hz_purge_gt temp where
1113:
1114:
1115: exists (select 'Y' from AHL_DOCUMENTS_B xx where xx.SOURCE_PARTY_ID = temp.party_id
1116: )
1117:
1118: or exists (select 'Y' from AHL_SUPPLIER_DOCUMENTS xx where xx.SUPPLIER_ID = temp.party_id
1119: )

Line 1130: exists (select 'Y' from AHL_DOCUMENTS_B xx where xx.SOURCE_PARTY_ID = temp.party_id

1126: else
1127: delete from hz_purge_gt temp where
1128:
1129:
1130: exists (select 'Y' from AHL_DOCUMENTS_B xx where xx.SOURCE_PARTY_ID = temp.party_id
1131: )
1132:
1133: or exists (select 'Y' from AHL_SUPPLIER_DOCUMENTS xx where xx.SUPPLIER_ID = temp.party_id
1134: )