APPS.HZ_PURGE_GEN dependencies on FND_ATTACHED_DOCUMENTS

Line 3050: --FND_ATTACHED_DOCUMENTS;PK1_VALUE

3046: in (select /*+ parallel(yy)*/ yy.EMPLOYMENT_HISTORY_ID from HZ_WORK_CLASS
3047: yy
3048: where nvl(STATUS, 'A') in ('A','I')));
3049: end if;
3050: --FND_ATTACHED_DOCUMENTS;PK1_VALUE
3051: appid:=222;
3052: if(regid_proc = true) then
3053: 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
3054:

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

3051: appid:=222;
3052: if(regid_proc = true) then
3053: 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
3054:
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: else
3058: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3059: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PK1_VALUE from FND_ATTACHED_DOCUMENTS xx

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

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: else
3058: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3059: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PK1_VALUE from FND_ATTACHED_DOCUMENTS xx
3060: where (entity_name = 'HZ_PARTIES'));
3061: end if;
3062: --HZ_EMAIL_DOMAINS;PARTY_ID
3063: appid:=222;