DBA Data[Home] [Help]

APPS.HZ_PURGE_GEN dependencies on OKS_BILLING_PROFILES_B

Line 2648: exists (select 'Y' from OKS_BILLING_PROFILES_B xx where xx.OWNED_PARTY_ID1 = to_char(temp.party_id)

2644: if(regid_proc = true) then
2645: insert into hz_application_trans_gt(app_id,party_id) select 515, temp.party_id from hz_purge_gt temp where
2646:
2647:
2648: exists (select 'Y' from OKS_BILLING_PROFILES_B xx where xx.OWNED_PARTY_ID1 = to_char(temp.party_id)
2649: )
2650:
2651: or exists (select 'Y' from OKS_K_DEFAULTS xx where xx.SEGMENT_ID1 = to_char(temp.party_id)
2652: and (JTOT_OBJECT_CODE = 'OKX_PARTY'))

Line 2660: exists (select 'Y' from OKS_BILLING_PROFILES_B xx where xx.OWNED_PARTY_ID1 = to_char(temp.party_id)

2656: else
2657: delete from hz_purge_gt temp where
2658:
2659:
2660: exists (select 'Y' from OKS_BILLING_PROFILES_B xx where xx.OWNED_PARTY_ID1 = to_char(temp.party_id)
2661: )
2662:
2663: or exists (select 'Y' from OKS_K_DEFAULTS xx where xx.SEGMENT_ID1 = to_char(temp.party_id)
2664: and (JTOT_OBJECT_CODE = 'OKX_PARTY'))