DBA Data[Home] [Help]

APPS.HZ_PURGE_GEN dependencies on PA_CI_ACTIONS

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

1812: if(regid_proc = true) then
1813: insert into hz_application_trans_gt(app_id,party_id) select 275, temp.party_id from hz_purge_gt temp where
1814:
1815:
1816: exists (select 'Y' from PA_CI_ACTIONS xx where xx.ASSIGNED_TO = temp.party_id
1817: )
1818:
1819: or exists (select 'Y' from PA_CONTROL_ITEMS xx where xx.OWNER_ID = temp.party_id
1820: )

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

1842: else
1843: delete from hz_purge_gt temp where
1844:
1845:
1846: exists (select 'Y' from PA_CI_ACTIONS xx where xx.ASSIGNED_TO = temp.party_id
1847: )
1848:
1849: or exists (select 'Y' from PA_CONTROL_ITEMS xx where xx.OWNER_ID = temp.party_id
1850: )