APPS.HZ_PURGE_GEN dependencies on AMW_ASSESSMENTS_B

Line 4072: --AMW_ASSESSMENTS_B;ASSESSMENT_OWNER_ID

4068: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4069: temp.party_id in (select /*+ parallel(xx)*/ xx.REFERRED_BY from AS_SALES_LEADS xx
4070: );
4071: end if;
4072: --AMW_ASSESSMENTS_B;ASSESSMENT_OWNER_ID
4073: appid:=242;
4074: if(regid_proc = true) then
4075: insert into hz_application_trans_gt(app_id,party_id) select 242, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 242 and appl.party_id=temp.party_id) and
4076:

Line 4077: temp.party_id in (select /*+ parallel(xx)*/ xx.ASSESSMENT_OWNER_ID from AMW_ASSESSMENTS_B xx

4073: appid:=242;
4074: if(regid_proc = true) then
4075: insert into hz_application_trans_gt(app_id,party_id) select 242, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 242 and appl.party_id=temp.party_id) and
4076:
4077: temp.party_id in (select /*+ parallel(xx)*/ xx.ASSESSMENT_OWNER_ID from AMW_ASSESSMENTS_B xx
4078: );
4079: else
4080: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4081: temp.party_id in (select /*+ parallel(xx)*/ xx.ASSESSMENT_OWNER_ID from AMW_ASSESSMENTS_B xx

Line 4081: temp.party_id in (select /*+ parallel(xx)*/ xx.ASSESSMENT_OWNER_ID from AMW_ASSESSMENTS_B xx

4077: temp.party_id in (select /*+ parallel(xx)*/ xx.ASSESSMENT_OWNER_ID from AMW_ASSESSMENTS_B xx
4078: );
4079: else
4080: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4081: temp.party_id in (select /*+ parallel(xx)*/ xx.ASSESSMENT_OWNER_ID from AMW_ASSESSMENTS_B xx
4082: );
4083: end if;
4084: --AMW_AP_EXECUTIONS;EXECUTED_BY
4085: appid:=242;