[Home] [Help]
50: SELECT p.party_id
51: FROM hz_parties p
52: WHERE p.party_name = l_initiator_name
53: and p.party_type='ORGANIZATION'
54: and exists (select u.party_usg_assignment_id from hz_party_usg_assignments u
55: where u.party_usage_code = 'INTERCOMPANY_ORG'
56: and u.party_id = p.party_id);
57:
58: Cursor c_Le_Id_per_name(l_From_le_name IN VARCHAR2) IS
297: SELECT p.party_id
298: FROM hz_parties p
299: WHERE p.party_name = l_recipient_name
300: and p.party_type='ORGANIZATION'
301: and exists (select u.party_usg_assignment_id from hz_party_usg_assignments u
302: where u.party_usage_code = 'INTERCOMPANY_ORG'
303: and u.party_id = p.party_id);
304:
305:
597: hz_org_contact_roles hcr
598: WHERE hzp.party_type = 'ORGANIZATION'
599: AND EXISTS
600: (SELECT 1
601: FROM hz_party_usg_assignments hua
602: WHERE hua.party_id = hzp.party_id
603: AND hua.party_usage_code = 'INTERCOMPANY_ORG'
604: AND hua.effective_start_date <= sysdate
605: AND(hua.effective_end_date >= sysdate OR effective_end_date IS NULL))
1328: AND FIB.FROM_LE_NAME=:FROM_LE_NAME
1329: AND HZP.PARTY_TYPE = ''ORGANIZATION''
1330: AND EXISTS
1331: (SELECT 1
1332: FROM HZ_PARTY_USG_ASSIGNMENTS HUA
1333: WHERE HUA.PARTY_ID = HZP.PARTY_ID
1334: AND HUA.PARTY_USAGE_CODE = ''INTERCOMPANY_ORG''
1335: AND HUA.EFFECTIVE_START_DATE <= SYSDATE
1336: AND(HUA.EFFECTIVE_END_DATE >= SYSDATE OR EFFECTIVE_END_DATE IS NULL))
1381: AND fib.from_le_name = rec3.from_le_name
1382: AND hzp.party_type = 'ORGANIZATION'
1383: AND EXISTS
1384: (SELECT 1
1385: FROM hz_party_usg_assignments hua
1386: WHERE hua.party_id = hzp.party_id
1387: AND hua.party_usage_code = 'INTERCOMPANY_ORG'
1388: AND hua.effective_start_date <= sysdate
1389: AND(hua.effective_end_date >= sysdate OR effective_end_date IS NULL))