eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_CONTACT_USER_BATCH_PUB dependencies on HZ_PARTIES

Line 298: select partner_id, party_name from pv_partner_profiles,hz_parties where partner_party_id=l_party_id and party_id=partner_party_id;

294: from jtf_um_usertype_reg
295: where usertype_reg_id = to_number (l_user_reg_id);
296:
297: CURSOR CHECK_PARTNER(l_party_id VARCHAR2) IS
298: select partner_id, party_name from pv_partner_profiles,hz_parties where partner_party_id=l_party_id and party_id=partner_party_id;
299:
300: CURSOR USERTYPE_RESP(user_type VARCHAR2) is select FR.RESPONSIBILITY_ID, UT.APPLICATION_ID, FR.VERSION
301: FROM JTF_UM_USERTYPE_RESP UT,
302: FND_RESPONSIBILITY_VL FR,

Line 339: HZ_PARTIES.PARTY_ID

335:
336:
337: CURSOR get_party_id_from_ref(orig_system IN VARCHAR2, orig_system_ref IN VARCHAR2, l_party_type IN VARCHAR2) IS
338: SELECT
339: HZ_PARTIES.PARTY_ID
340: FROM
341: HZ_ORIG_SYS_REFERENCES,
342: HZ_PARTIES
343: WHERE

Line 342: HZ_PARTIES

338: SELECT
339: HZ_PARTIES.PARTY_ID
340: FROM
341: HZ_ORIG_SYS_REFERENCES,
342: HZ_PARTIES
343: WHERE
344: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
345: HZ_PARTIES.PARTY_TYPE = l_party_type AND
346: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND

Line 344: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND

340: FROM
341: HZ_ORIG_SYS_REFERENCES,
342: HZ_PARTIES
343: WHERE
344: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
345: HZ_PARTIES.PARTY_TYPE = l_party_type AND
346: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND
347: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND
348: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND

Line 345: HZ_PARTIES.PARTY_TYPE = l_party_type AND

341: HZ_ORIG_SYS_REFERENCES,
342: HZ_PARTIES
343: WHERE
344: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
345: HZ_PARTIES.PARTY_TYPE = l_party_type AND
346: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND
347: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND
348: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
349: HZ_PARTIES.STATUS = 'A';

Line 348: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND

344: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
345: HZ_PARTIES.PARTY_TYPE = l_party_type AND
346: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND
347: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND
348: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
349: HZ_PARTIES.STATUS = 'A';
350:
351:
352:

Line 349: HZ_PARTIES.STATUS = 'A';

345: HZ_PARTIES.PARTY_TYPE = l_party_type AND
346: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND
347: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND
348: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
349: HZ_PARTIES.STATUS = 'A';
350:
351:
352:
353: CURSOR get_party_id_all_data(orig_system IN VARCHAR2, orig_system_ref IN VARCHAR2,l_party_id VARCHAR2, l_party_type IN VARCHAR2) IS

Line 355: HZ_PARTIES.PARTY_ID

351:
352:
353: CURSOR get_party_id_all_data(orig_system IN VARCHAR2, orig_system_ref IN VARCHAR2,l_party_id VARCHAR2, l_party_type IN VARCHAR2) IS
354: SELECT
355: HZ_PARTIES.PARTY_ID
356: FROM
357: HZ_ORIG_SYS_REFERENCES,
358: HZ_PARTIES
359: WHERE

Line 358: HZ_PARTIES

354: SELECT
355: HZ_PARTIES.PARTY_ID
356: FROM
357: HZ_ORIG_SYS_REFERENCES,
358: HZ_PARTIES
359: WHERE
360: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
361: HZ_PARTIES.PARTY_TYPE = l_party_type AND
362: HZ_PARTIES.party_id = l_party_id and

Line 360: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND

356: FROM
357: HZ_ORIG_SYS_REFERENCES,
358: HZ_PARTIES
359: WHERE
360: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
361: HZ_PARTIES.PARTY_TYPE = l_party_type AND
362: HZ_PARTIES.party_id = l_party_id and
363: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND
364: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND

Line 361: HZ_PARTIES.PARTY_TYPE = l_party_type AND

357: HZ_ORIG_SYS_REFERENCES,
358: HZ_PARTIES
359: WHERE
360: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
361: HZ_PARTIES.PARTY_TYPE = l_party_type AND
362: HZ_PARTIES.party_id = l_party_id and
363: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND
364: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND
365: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND

Line 362: HZ_PARTIES.party_id = l_party_id and

358: HZ_PARTIES
359: WHERE
360: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
361: HZ_PARTIES.PARTY_TYPE = l_party_type AND
362: HZ_PARTIES.party_id = l_party_id and
363: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND
364: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND
365: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
366: HZ_PARTIES.STATUS = 'A';

Line 365: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND

361: HZ_PARTIES.PARTY_TYPE = l_party_type AND
362: HZ_PARTIES.party_id = l_party_id and
363: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND
364: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND
365: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
366: HZ_PARTIES.STATUS = 'A';
367:
368:
369:

Line 366: HZ_PARTIES.STATUS = 'A';

362: HZ_PARTIES.party_id = l_party_id and
363: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND
364: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND
365: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
366: HZ_PARTIES.STATUS = 'A';
367:
368:
369:
370:

Line 374: HZ_PARTIES.PARTY_ID

370:
371:
372: CURSOR get_party_id_only_sys(orig_system IN VARCHAR2, l_party_id VARCHAR2, l_party_type IN VARCHAR2) IS
373: SELECT
374: HZ_PARTIES.PARTY_ID
375: FROM
376: HZ_ORIG_SYS_REFERENCES,
377: HZ_PARTIES
378: WHERE

Line 377: HZ_PARTIES

373: SELECT
374: HZ_PARTIES.PARTY_ID
375: FROM
376: HZ_ORIG_SYS_REFERENCES,
377: HZ_PARTIES
378: WHERE
379: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
380: HZ_PARTIES.PARTY_TYPE = l_party_type AND
381: HZ_PARTIES.party_id = l_party_id and

Line 379: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND

375: FROM
376: HZ_ORIG_SYS_REFERENCES,
377: HZ_PARTIES
378: WHERE
379: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
380: HZ_PARTIES.PARTY_TYPE = l_party_type AND
381: HZ_PARTIES.party_id = l_party_id and
382: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND
383: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND

Line 380: HZ_PARTIES.PARTY_TYPE = l_party_type AND

376: HZ_ORIG_SYS_REFERENCES,
377: HZ_PARTIES
378: WHERE
379: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
380: HZ_PARTIES.PARTY_TYPE = l_party_type AND
381: HZ_PARTIES.party_id = l_party_id and
382: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND
383: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
384: HZ_PARTIES.STATUS = 'A';

Line 381: HZ_PARTIES.party_id = l_party_id and

377: HZ_PARTIES
378: WHERE
379: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
380: HZ_PARTIES.PARTY_TYPE = l_party_type AND
381: HZ_PARTIES.party_id = l_party_id and
382: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND
383: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
384: HZ_PARTIES.STATUS = 'A';
385:

Line 383: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND

379: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
380: HZ_PARTIES.PARTY_TYPE = l_party_type AND
381: HZ_PARTIES.party_id = l_party_id and
382: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND
383: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
384: HZ_PARTIES.STATUS = 'A';
385:
386:
387: CURSOR get_party_id_only_ref( orig_system_ref IN VARCHAR2,l_party_id VARCHAR2, l_party_type IN VARCHAR2) IS

Line 384: HZ_PARTIES.STATUS = 'A';

380: HZ_PARTIES.PARTY_TYPE = l_party_type AND
381: HZ_PARTIES.party_id = l_party_id and
382: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND
383: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
384: HZ_PARTIES.STATUS = 'A';
385:
386:
387: CURSOR get_party_id_only_ref( orig_system_ref IN VARCHAR2,l_party_id VARCHAR2, l_party_type IN VARCHAR2) IS
388: SELECT

Line 389: HZ_PARTIES.PARTY_ID

385:
386:
387: CURSOR get_party_id_only_ref( orig_system_ref IN VARCHAR2,l_party_id VARCHAR2, l_party_type IN VARCHAR2) IS
388: SELECT
389: HZ_PARTIES.PARTY_ID
390: FROM
391: HZ_ORIG_SYS_REFERENCES,
392: HZ_PARTIES
393: WHERE

Line 392: HZ_PARTIES

388: SELECT
389: HZ_PARTIES.PARTY_ID
390: FROM
391: HZ_ORIG_SYS_REFERENCES,
392: HZ_PARTIES
393: WHERE
394: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
395: HZ_PARTIES.PARTY_TYPE = l_party_type AND
396: HZ_PARTIES.party_id = l_party_id and

Line 394: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND

390: FROM
391: HZ_ORIG_SYS_REFERENCES,
392: HZ_PARTIES
393: WHERE
394: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
395: HZ_PARTIES.PARTY_TYPE = l_party_type AND
396: HZ_PARTIES.party_id = l_party_id and
397: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND
398: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND

Line 395: HZ_PARTIES.PARTY_TYPE = l_party_type AND

391: HZ_ORIG_SYS_REFERENCES,
392: HZ_PARTIES
393: WHERE
394: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
395: HZ_PARTIES.PARTY_TYPE = l_party_type AND
396: HZ_PARTIES.party_id = l_party_id and
397: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND
398: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
399: HZ_PARTIES.STATUS = 'A';

Line 396: HZ_PARTIES.party_id = l_party_id and

392: HZ_PARTIES
393: WHERE
394: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
395: HZ_PARTIES.PARTY_TYPE = l_party_type AND
396: HZ_PARTIES.party_id = l_party_id and
397: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND
398: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
399: HZ_PARTIES.STATUS = 'A';
400:

Line 398: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND

394: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
395: HZ_PARTIES.PARTY_TYPE = l_party_type AND
396: HZ_PARTIES.party_id = l_party_id and
397: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND
398: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
399: HZ_PARTIES.STATUS = 'A';
400:
401:
402:

Line 399: HZ_PARTIES.STATUS = 'A';

395: HZ_PARTIES.PARTY_TYPE = l_party_type AND
396: HZ_PARTIES.party_id = l_party_id and
397: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND
398: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
399: HZ_PARTIES.STATUS = 'A';
400:
401:
402:
403:

Line 620: l_party_rel_rec.subject_table_name := 'HZ_PARTIES';

616: if l_rel_party_id is null then
617:
618: l_party_rel_rec.subject_id := l_person_party_ID;
619: l_party_rel_rec.subject_type := 'PERSON';
620: l_party_rel_rec.subject_table_name := 'HZ_PARTIES';
621:
622: -- pass organization_party_id as object_id
623: l_party_rel_rec.object_id := l_partner_party_ID;
624: l_party_rel_rec.object_type := 'ORGANIZATION';

Line 625: l_party_rel_rec.object_table_name := 'HZ_PARTIES';

621:
622: -- pass organization_party_id as object_id
623: l_party_rel_rec.object_id := l_partner_party_ID;
624: l_party_rel_rec.object_type := 'ORGANIZATION';
625: l_party_rel_rec.object_table_name := 'HZ_PARTIES';
626:
627: l_party_rel_rec.relationship_type := 'EMPLOYMENT';
628: l_party_rel_rec.relationship_code := 'EMPLOYEE_OF';
629:

Line 796: l_contact_details_rec.phone_contact_point_rec.owner_table_name := 'HZ_PARTIES';

792:
793:
794:
795: l_contact_details_rec.phone_contact_point_rec.status := 'A';
796: l_contact_details_rec.phone_contact_point_rec.owner_table_name := 'HZ_PARTIES';
797: l_contact_details_rec.phone_contact_point_rec.owner_table_id := l_rel_party_id;
798: l_contact_details_rec.phone_contact_point_rec.created_by_module := 'PV';
799: l_contact_details_rec.phone_contact_point_rec.application_id := 691;
800: l_contact_details_rec.phone_contact_point_rec.primary_flag :='Y';

Line 849: l_contact_details_rec.email_contact_point_rec.owner_table_name := 'HZ_PARTIES';

845:
846:
847:
848: l_contact_details_rec.email_contact_point_rec.status := 'A';
849: l_contact_details_rec.email_contact_point_rec.owner_table_name := 'HZ_PARTIES';
850: l_contact_details_rec.email_contact_point_rec.owner_table_id := l_rel_party_id;
851: l_contact_details_rec.email_contact_point_rec.created_by_module := 'PV';
852: l_contact_details_rec.email_contact_point_rec.application_id := 691;
853: l_contact_details_rec.email_contact_point_rec.primary_flag :='Y';

Line 1439: select hzp.status from hz_parties hzp where hzp.party_id=rel_party_id ;

1435: select relationship_code from hz_relationships hzr where hzr.party_id=rel_party_id and hzr.directional_flag='F';
1436:
1437:
1438: CURSOR get_status(rel_party_id NUMBER) IS
1439: select hzp.status from hz_parties hzp where hzp.party_id=rel_party_id ;
1440:
1441:
1442: CURSOR get_email_address(rel_party_id NUMBER) IS
1443: select email_address from hz_parties hzp where hzp.party_id=rel_party_id ;

Line 1443: select email_address from hz_parties hzp where hzp.party_id=rel_party_id ;

1439: select hzp.status from hz_parties hzp where hzp.party_id=rel_party_id ;
1440:
1441:
1442: CURSOR get_email_address(rel_party_id NUMBER) IS
1443: select email_address from hz_parties hzp where hzp.party_id=rel_party_id ;
1444:
1445:
1446:
1447:

Line 1451: from HZ_PARTIES PERSON_HZP, HZ_RELATIONSHIPS HZR, PV_PARTNER_PROFILES pvpp, hz_org_contacts hzoc, HZ_PARTIES ORG_HZP,

1447:
1448: cursor get_contact_details(rel_party_id NUMBER) IS
1449: select pvpp.partner_id, pvpp.PARTNER_GROUP_ID , person_hzp.PERSON_FIRST_NAME, person_hzp.person_last_name,
1450: hzoc.org_contact_id, org_hzp.party_name, rel_hzp.email_address
1451: from HZ_PARTIES PERSON_HZP, HZ_RELATIONSHIPS HZR, PV_PARTNER_PROFILES pvpp, hz_org_contacts hzoc, HZ_PARTIES ORG_HZP,
1452: hz_parties REL_HZP
1453: where HZR.party_id = rel_party_id
1454: and HZR.directional_flag = 'F'
1455: and hzr.relationship_code = 'EMPLOYEE_OF'

Line 1452: hz_parties REL_HZP

1448: cursor get_contact_details(rel_party_id NUMBER) IS
1449: select pvpp.partner_id, pvpp.PARTNER_GROUP_ID , person_hzp.PERSON_FIRST_NAME, person_hzp.person_last_name,
1450: hzoc.org_contact_id, org_hzp.party_name, rel_hzp.email_address
1451: from HZ_PARTIES PERSON_HZP, HZ_RELATIONSHIPS HZR, PV_PARTNER_PROFILES pvpp, hz_org_contacts hzoc, HZ_PARTIES ORG_HZP,
1452: hz_parties REL_HZP
1453: where HZR.party_id = rel_party_id
1454: and HZR.directional_flag = 'F'
1455: and hzr.relationship_code = 'EMPLOYEE_OF'
1456: and HZR.subject_table_name ='HZ_PARTIES'

Line 1456: and HZR.subject_table_name ='HZ_PARTIES'

1452: hz_parties REL_HZP
1453: where HZR.party_id = rel_party_id
1454: and HZR.directional_flag = 'F'
1455: and hzr.relationship_code = 'EMPLOYEE_OF'
1456: and HZR.subject_table_name ='HZ_PARTIES'
1457: and HZR.object_table_name ='HZ_PARTIES'
1458: and hzr.start_date <= SYSDATE
1459: and (hzr.end_date is null or hzr.end_date > SYSDATE)
1460: and hzr.status = 'A'

Line 1457: and HZR.object_table_name ='HZ_PARTIES'

1453: where HZR.party_id = rel_party_id
1454: and HZR.directional_flag = 'F'
1455: and hzr.relationship_code = 'EMPLOYEE_OF'
1456: and HZR.subject_table_name ='HZ_PARTIES'
1457: and HZR.object_table_name ='HZ_PARTIES'
1458: and hzr.start_date <= SYSDATE
1459: and (hzr.end_date is null or hzr.end_date > SYSDATE)
1460: and hzr.status = 'A'
1461: and hzr.subject_id = person_hzp.party_id

Line 1470: select hzr.subject_id from hz_parties rel,hz_relationships hzr ,pv_partner_profiles pvpp

1466: and hzr.object_id = org_hzp.party_id and
1467: rel_hzp.party_id=hzr.party_id;
1468:
1469: CURSOR CHECK_CONTACT(rel_party_id VARCHAR2) is
1470: select hzr.subject_id from hz_parties rel,hz_relationships hzr ,pv_partner_profiles pvpp
1471: where rel.party_id=rel_party_id and
1472: hzr.party_id=rel.party_id and
1473: hzr.relationship_code in ('EMPLOYEE_OF' ) and
1474: hzr.object_id=pvpp.partner_party_id;

Line 2045: select hzp.status from hz_parties hzp where hzp.party_id=rel_party_id ;

2041: select relationship_code from hz_relationships hzr where hzr.party_id=rel_party_id and hzr.directional_flag='F';
2042:
2043:
2044: CURSOR get_status(rel_party_id NUMBER) IS
2045: select hzp.status from hz_parties hzp where hzp.party_id=rel_party_id ;
2046:
2047:
2048: CURSOR get_email_address(rel_party_id NUMBER) IS
2049: select email_address from hz_parties hzp where hzp.party_id=rel_party_id ;

Line 2049: select email_address from hz_parties hzp where hzp.party_id=rel_party_id ;

2045: select hzp.status from hz_parties hzp where hzp.party_id=rel_party_id ;
2046:
2047:
2048: CURSOR get_email_address(rel_party_id NUMBER) IS
2049: select email_address from hz_parties hzp where hzp.party_id=rel_party_id ;
2050:
2051:
2052:
2053:

Line 2057: from HZ_PARTIES PERSON_HZP, HZ_RELATIONSHIPS HZR, PV_PARTNER_PROFILES pvpp, hz_org_contacts hzoc, HZ_PARTIES ORG_HZP,

2053:
2054: cursor get_contact_details(rel_party_id NUMBER) IS
2055: select pvpp.partner_id, pvpp.PARTNER_GROUP_ID , person_hzp.PERSON_FIRST_NAME, person_hzp.person_last_name,
2056: hzoc.org_contact_id, org_hzp.party_name, rel_hzp.email_address
2057: from HZ_PARTIES PERSON_HZP, HZ_RELATIONSHIPS HZR, PV_PARTNER_PROFILES pvpp, hz_org_contacts hzoc, HZ_PARTIES ORG_HZP,
2058: hz_parties REL_HZP
2059: where HZR.party_id = rel_party_id
2060: and HZR.directional_flag = 'F'
2061: and hzr.relationship_code = 'EMPLOYEE_OF'

Line 2058: hz_parties REL_HZP

2054: cursor get_contact_details(rel_party_id NUMBER) IS
2055: select pvpp.partner_id, pvpp.PARTNER_GROUP_ID , person_hzp.PERSON_FIRST_NAME, person_hzp.person_last_name,
2056: hzoc.org_contact_id, org_hzp.party_name, rel_hzp.email_address
2057: from HZ_PARTIES PERSON_HZP, HZ_RELATIONSHIPS HZR, PV_PARTNER_PROFILES pvpp, hz_org_contacts hzoc, HZ_PARTIES ORG_HZP,
2058: hz_parties REL_HZP
2059: where HZR.party_id = rel_party_id
2060: and HZR.directional_flag = 'F'
2061: and hzr.relationship_code = 'EMPLOYEE_OF'
2062: and HZR.subject_table_name ='HZ_PARTIES'

Line 2062: and HZR.subject_table_name ='HZ_PARTIES'

2058: hz_parties REL_HZP
2059: where HZR.party_id = rel_party_id
2060: and HZR.directional_flag = 'F'
2061: and hzr.relationship_code = 'EMPLOYEE_OF'
2062: and HZR.subject_table_name ='HZ_PARTIES'
2063: and HZR.object_table_name ='HZ_PARTIES'
2064: and hzr.start_date <= SYSDATE
2065: and (hzr.end_date is null or hzr.end_date > SYSDATE)
2066: and hzr.status = 'A'

Line 2063: and HZR.object_table_name ='HZ_PARTIES'

2059: where HZR.party_id = rel_party_id
2060: and HZR.directional_flag = 'F'
2061: and hzr.relationship_code = 'EMPLOYEE_OF'
2062: and HZR.subject_table_name ='HZ_PARTIES'
2063: and HZR.object_table_name ='HZ_PARTIES'
2064: and hzr.start_date <= SYSDATE
2065: and (hzr.end_date is null or hzr.end_date > SYSDATE)
2066: and hzr.status = 'A'
2067: and hzr.subject_id = person_hzp.party_id

Line 2076: select hzr.subject_id from hz_parties rel,hz_relationships hzr ,pv_partner_profiles pvpp, fnd_user fu

2072: and hzr.object_id = org_hzp.party_id and
2073: rel_hzp.party_id=hzr.party_id;
2074:
2075: CURSOR CHECK_CONTACT(rel_party_id VARCHAR2,l_user_name VARCHAR2) is
2076: select hzr.subject_id from hz_parties rel,hz_relationships hzr ,pv_partner_profiles pvpp, fnd_user fu
2077: where rel.party_id=rel_party_id and
2078: hzr.party_id=rel.party_id and
2079: hzr.relationship_code in ('EMPLOYEE_OF') and
2080: fu.user_name=l_user_name and