DBA Data[Home] [Help]

APPS.HZ_PURGE_GEN dependencies on OKS_SERV_AVAIL_EXCEPTS

Line 2654: or exists (select 'Y' from OKS_SERV_AVAIL_EXCEPTS xx where xx.OBJECT1_ID1 = to_char(temp.party_id)

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'))
2653:
2654: or exists (select 'Y' from OKS_SERV_AVAIL_EXCEPTS xx where xx.OBJECT1_ID1 = to_char(temp.party_id)
2655: and (JTOT_OBJECT1_CODE = 'OKX_PARTY'));
2656: else
2657: delete from hz_purge_gt temp where
2658:

Line 2666: or exists (select 'Y' from OKS_SERV_AVAIL_EXCEPTS xx where xx.OBJECT1_ID1 = to_char(temp.party_id)

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'))
2665:
2666: or exists (select 'Y' from OKS_SERV_AVAIL_EXCEPTS xx where xx.OBJECT1_ID1 = to_char(temp.party_id)
2667: and (JTOT_OBJECT1_CODE = 'OKX_PARTY'));
2668: end if;
2669:
2670: