DBA Data[Home] [Help]

APPS.HZ_PURGE_GEN dependencies on OKE_K_FUNDING_SOURCES_PM_HV

Line 1092: exists (select 'Y' from OKE_K_FUNDING_SOURCES_PM_HV xx where xx.K_PARTY_ID = temp.party_id

1088: if(regid_proc = true) then
1089: insert into hz_application_trans_gt(app_id,party_id) select 777, temp.party_id from hz_purge_gt temp where
1090:
1091:
1092: exists (select 'Y' from OKE_K_FUNDING_SOURCES_PM_HV xx where xx.K_PARTY_ID = temp.party_id
1093: )
1094:
1095: or exists (select 'Y' from OKE_K_FUNDING_SOURCES xx where xx.K_PARTY_ID = temp.party_id
1096: );

Line 1101: exists (select 'Y' from OKE_K_FUNDING_SOURCES_PM_HV xx where xx.K_PARTY_ID = temp.party_id

1097: else
1098: delete from hz_purge_gt temp where
1099:
1100:
1101: exists (select 'Y' from OKE_K_FUNDING_SOURCES_PM_HV xx where xx.K_PARTY_ID = temp.party_id
1102: )
1103:
1104: or exists (select 'Y' from OKE_K_FUNDING_SOURCES xx where xx.K_PARTY_ID = temp.party_id
1105: );