APPS.HZ_PURGE_GEN dependencies on FND_ATTACHED_DOCUMENTS

Line 3046: --FND_ATTACHED_DOCUMENTS;PK1_VALUE

3042: in (select /*+ parallel(yy)*/ yy.EMPLOYMENT_HISTORY_ID from HZ_WORK_CLASS
3043: yy
3044: where nvl(STATUS, 'A') in ('A','I')));
3045: end if;
3046: --FND_ATTACHED_DOCUMENTS;PK1_VALUE
3047: appid:=222;
3048: if(regid_proc = true) then
3049: insert into hz_application_trans_gt(app_id,party_id) select 222, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 222 and appl.party_id=temp.party_id) and
3050:

Line 3051: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PK1_VALUE from FND_ATTACHED_DOCUMENTS xx

3047: appid:=222;
3048: if(regid_proc = true) then
3049: insert into hz_application_trans_gt(app_id,party_id) select 222, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 222 and appl.party_id=temp.party_id) and
3050:
3051: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PK1_VALUE from FND_ATTACHED_DOCUMENTS xx
3052: where (entity_name = 'HZ_PARTIES'));
3053: else
3054: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3055: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PK1_VALUE from FND_ATTACHED_DOCUMENTS xx

Line 3055: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PK1_VALUE from FND_ATTACHED_DOCUMENTS xx

3051: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PK1_VALUE from FND_ATTACHED_DOCUMENTS xx
3052: where (entity_name = 'HZ_PARTIES'));
3053: else
3054: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3055: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PK1_VALUE from FND_ATTACHED_DOCUMENTS xx
3056: where (entity_name = 'HZ_PARTIES'));
3057: end if;
3058: --HZ_EMAIL_DOMAINS;PARTY_ID
3059: appid:=222;