1824:
1825: or exists (select 'Y' from PA_PROJECT_REQUESTS xx where xx.CUST_PARTY_ID = temp.party_id
1826: )
1827:
1828: or exists (select 'Y' from PA_PROJECT_SETS_B xx where xx.PARTY_ID = temp.party_id
1829: )
1830:
1831: or exists (select 'Y' from PA_RESOURCE_TXN_ATTRIBUTES xx where xx.PARTY_ID = temp.party_id
1832: )
1854:
1855: or exists (select 'Y' from PA_PROJECT_REQUESTS xx where xx.CUST_PARTY_ID = temp.party_id
1856: )
1857:
1858: or exists (select 'Y' from PA_PROJECT_SETS_B xx where xx.PARTY_ID = temp.party_id
1859: )
1860:
1861: or exists (select 'Y' from PA_RESOURCE_TXN_ATTRIBUTES xx where xx.PARTY_ID = temp.party_id
1862: )