APPS.IEX_WF_BAN_STATUS_PUB dependencies on HZ_PARTIES

Line 117: SELECT party_name INTO l_party_name from hz_parties

113: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..P_Party_id=' ||p_party_id);
114: end if;
115:
116: begin
117: SELECT party_name INTO l_party_name from hz_parties
118: where party_id = p_party_id;
119: exception
120: when others then
121: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow party_name exception');

Line 524: WHERE CONTACT_LEVEL_TABLE = 'HZ_PARTIES'

520: l_contact_preference_rec HZ_CONTACT_PREFERENCE_V2PUB.contact_preference_rec_type;
521:
522: CURSOR C_DO_PARTY(p_person_id NUMBER) IS
523: SELECT contact_preference_id FROM HZ_CONTACT_PREFERENCES
524: WHERE CONTACT_LEVEL_TABLE = 'HZ_PARTIES'
525: AND CONTACT_LEVEL_TABLE_ID = P_PERSON_ID
526: AND PREFERENCE_CODE = 'DO';
527:
528: CURSOR C_DO_NOT_PARTY(p_person_id NUMBER) IS

Line 530: WHERE CONTACT_LEVEL_TABLE = 'HZ_PARTIES'

526: AND PREFERENCE_CODE = 'DO';
527:
528: CURSOR C_DO_NOT_PARTY(p_person_id NUMBER) IS
529: SELECT contact_preference_id FROM HZ_CONTACT_PREFERENCES
530: WHERE CONTACT_LEVEL_TABLE = 'HZ_PARTIES'
531: AND CONTACT_LEVEL_TABLE_ID = P_PERSON_ID
532: AND PREFERENCE_CODE = 'DO_NOT';
533:
534: --Begin Bug#4597394 schekuri 08-Sep-2005

Line 543: , HZ_PARTIES C

539: P.PARTY_ID
540: -- , P.PARTY_NAME
541: FROM
542: HZ_RELATIONSHIPS REL
543: , HZ_PARTIES C
544: , HZ_PARTIES P
545: , HZ_PARTIES O
546: WHERE O.PARTY_TYPE = 'ORGANIZATION'
547: AND O.PARTY_ID = REL.OBJECT_ID

Line 544: , HZ_PARTIES P

540: -- , P.PARTY_NAME
541: FROM
542: HZ_RELATIONSHIPS REL
543: , HZ_PARTIES C
544: , HZ_PARTIES P
545: , HZ_PARTIES O
546: WHERE O.PARTY_TYPE = 'ORGANIZATION'
547: AND O.PARTY_ID = REL.OBJECT_ID
548: AND P.PARTY_TYPE = 'PERSON'

Line 545: , HZ_PARTIES O

541: FROM
542: HZ_RELATIONSHIPS REL
543: , HZ_PARTIES C
544: , HZ_PARTIES P
545: , HZ_PARTIES O
546: WHERE O.PARTY_TYPE = 'ORGANIZATION'
547: AND O.PARTY_ID = REL.OBJECT_ID
548: AND P.PARTY_TYPE = 'PERSON'
549: AND P.PARTY_ID = REL.SUBJECT_ID

Line 552: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

548: AND P.PARTY_TYPE = 'PERSON'
549: AND P.PARTY_ID = REL.SUBJECT_ID
550: AND C.PARTY_TYPE = 'PARTY_RELATIONSHIP'
551: AND REL.PARTY_ID = C.PARTY_ID
552: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
553: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
554: AND REL.DIRECTIONAL_FLAG = 'F'
555: AND O.PARTY_ID = p_org_party_id;
556:

Line 553: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

549: AND P.PARTY_ID = REL.SUBJECT_ID
550: AND C.PARTY_TYPE = 'PARTY_RELATIONSHIP'
551: AND REL.PARTY_ID = C.PARTY_ID
552: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
553: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
554: AND REL.DIRECTIONAL_FLAG = 'F'
555: AND O.PARTY_ID = p_org_party_id;
556:
557:

Line 564: , HZ_PARTIES C

560: P.PARTY_ID
561: -- , P.PARTY_NAME
562: FROM
563: HZ_PARTY_RELATIONSHIPS REL
564: , HZ_PARTIES C
565: , HZ_PARTIES P
566: , HZ_PARTIES O
567: WHERE O.PARTY_TYPE = 'ORGANIZATION'
568: AND O.PARTY_ID = REL.OBJECT_ID

Line 565: , HZ_PARTIES P

561: -- , P.PARTY_NAME
562: FROM
563: HZ_PARTY_RELATIONSHIPS REL
564: , HZ_PARTIES C
565: , HZ_PARTIES P
566: , HZ_PARTIES O
567: WHERE O.PARTY_TYPE = 'ORGANIZATION'
568: AND O.PARTY_ID = REL.OBJECT_ID
569: AND P.PARTY_TYPE = 'PERSON'

Line 566: , HZ_PARTIES O

562: FROM
563: HZ_PARTY_RELATIONSHIPS REL
564: , HZ_PARTIES C
565: , HZ_PARTIES P
566: , HZ_PARTIES O
567: WHERE O.PARTY_TYPE = 'ORGANIZATION'
568: AND O.PARTY_ID = REL.OBJECT_ID
569: AND P.PARTY_TYPE = 'PERSON'
570: AND P.PARTY_ID = REL.SUBJECT_ID

Line 660: l_contact_preference_rec.CONTACT_LEVEL_TABLE := 'HZ_PARTIES';

656: -- Dbms_output.put_line('P Id*'||l_contact_preference_id||' Null');
657: null;
658: ELSE
659: -- Dbms_output.put_line('P Id*'||l_contact_preference_id||' Create');
660: l_contact_preference_rec.CONTACT_LEVEL_TABLE := 'HZ_PARTIES';
661: l_contact_preference_rec.CONTACT_LEVEL_TABLE_ID := l_p_party_id;
662: l_contact_preference_rec.PREFERENCE_CODE := 'DO_NOT';
663: l_contact_preference_rec.REQUESTED_BY := 'PARTY';
664: --Begin bug#5087608 schekuri 27-May-2006