DBA Data[Home] [Help]

APPS.HZ_PURGE_GEN dependencies on OKS_BILLING_PROFILES_B

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

2737: if(regid_proc = true) then
2738: insert into hz_application_trans_gt(app_id,party_id) select 515, temp.party_id from hz_purge_gt temp where
2739:
2740:
2741: exists (select 'Y' from OKS_BILLING_PROFILES_B xx where xx.OWNED_PARTY_ID1 = to_char(temp.party_id)
2742: )
2743:
2744: or exists (select 'Y' from OKS_K_DEFAULTS xx where xx.SEGMENT_ID1 = to_char(temp.party_id)
2745: and (JTOT_OBJECT_CODE = 'OKX_PARTY'))

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

2749: else
2750: delete from hz_purge_gt temp where
2751:
2752:
2753: exists (select 'Y' from OKS_BILLING_PROFILES_B xx where xx.OWNED_PARTY_ID1 = to_char(temp.party_id)
2754: )
2755:
2756: or exists (select 'Y' from OKS_K_DEFAULTS xx where xx.SEGMENT_ID1 = to_char(temp.party_id)
2757: and (JTOT_OBJECT_CODE = 'OKX_PARTY'))