DBA Data[Home] [Help]

APPS.HZ_PURGE_GEN dependencies on PA_CI_ACTIONS

Line 1748: exists (select 'Y' from PA_CI_ACTIONS xx where xx.ASSIGNED_TO = temp.party_id

1744: if(regid_proc = true) then
1745: insert into hz_application_trans_gt(app_id,party_id) select 275, temp.party_id from hz_purge_gt temp where
1746:
1747:
1748: exists (select 'Y' from PA_CI_ACTIONS xx where xx.ASSIGNED_TO = temp.party_id
1749: )
1750:
1751: or exists (select 'Y' from PA_CONTROL_ITEMS xx where xx.OWNER_ID = temp.party_id
1752: )

Line 1778: exists (select 'Y' from PA_CI_ACTIONS xx where xx.ASSIGNED_TO = temp.party_id

1774: else
1775: delete from hz_purge_gt temp where
1776:
1777:
1778: exists (select 'Y' from PA_CI_ACTIONS xx where xx.ASSIGNED_TO = temp.party_id
1779: )
1780:
1781: or exists (select 'Y' from PA_CONTROL_ITEMS xx where xx.OWNER_ID = temp.party_id
1782: )