APPS.IEX_WF_BAN_STATUS_PUB dependencies on HZ_PARTIES

Line 332: SELECT party_name INTO l_party_name from hz_parties

328: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..P_Party_id=' ||p_party_id);
329: end if;
330:
331: begin
332: SELECT party_name INTO l_party_name from hz_parties
333: where party_id = p_party_id;
334: exception
335: when others then
336: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow party_name exception');

Line 798: WHERE CONTACT_LEVEL_TABLE = 'HZ_PARTIES'

794: l_contact_preference_rec HZ_CONTACT_PREFERENCE_V2PUB.contact_preference_rec_type;
795:
796: CURSOR C_DO_PARTY(p_person_id NUMBER) IS
797: SELECT contact_preference_id FROM HZ_CONTACT_PREFERENCES
798: WHERE CONTACT_LEVEL_TABLE = 'HZ_PARTIES'
799: AND CONTACT_LEVEL_TABLE_ID = P_PERSON_ID
800: AND PREFERENCE_CODE = 'DO';
801:
802: CURSOR C_DO_NOT_PARTY(p_person_id NUMBER) IS

Line 804: WHERE CONTACT_LEVEL_TABLE = 'HZ_PARTIES'

800: AND PREFERENCE_CODE = 'DO';
801:
802: CURSOR C_DO_NOT_PARTY(p_person_id NUMBER) IS
803: SELECT contact_preference_id FROM HZ_CONTACT_PREFERENCES
804: WHERE CONTACT_LEVEL_TABLE = 'HZ_PARTIES'
805: AND CONTACT_LEVEL_TABLE_ID = P_PERSON_ID
806: AND PREFERENCE_CODE = 'DO_NOT';
807:
808: --Begin Bug#4597394 schekuri 08-Sep-2005

Line 817: , HZ_PARTIES C

813: P.PARTY_ID
814: -- , P.PARTY_NAME
815: FROM
816: HZ_RELATIONSHIPS REL
817: , HZ_PARTIES C
818: , HZ_PARTIES P
819: , HZ_PARTIES O
820: WHERE O.PARTY_TYPE = 'ORGANIZATION'
821: AND O.PARTY_ID = REL.OBJECT_ID

Line 818: , HZ_PARTIES P

814: -- , P.PARTY_NAME
815: FROM
816: HZ_RELATIONSHIPS REL
817: , HZ_PARTIES C
818: , HZ_PARTIES P
819: , HZ_PARTIES O
820: WHERE O.PARTY_TYPE = 'ORGANIZATION'
821: AND O.PARTY_ID = REL.OBJECT_ID
822: AND P.PARTY_TYPE = 'PERSON'

Line 819: , HZ_PARTIES O

815: FROM
816: HZ_RELATIONSHIPS REL
817: , HZ_PARTIES C
818: , HZ_PARTIES P
819: , HZ_PARTIES O
820: WHERE O.PARTY_TYPE = 'ORGANIZATION'
821: AND O.PARTY_ID = REL.OBJECT_ID
822: AND P.PARTY_TYPE = 'PERSON'
823: AND P.PARTY_ID = REL.SUBJECT_ID

Line 826: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

822: AND P.PARTY_TYPE = 'PERSON'
823: AND P.PARTY_ID = REL.SUBJECT_ID
824: AND C.PARTY_TYPE = 'PARTY_RELATIONSHIP'
825: AND REL.PARTY_ID = C.PARTY_ID
826: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
827: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
828: AND REL.DIRECTIONAL_FLAG = 'F'
829: AND O.PARTY_ID = p_org_party_id;
830:

Line 827: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

823: AND P.PARTY_ID = REL.SUBJECT_ID
824: AND C.PARTY_TYPE = 'PARTY_RELATIONSHIP'
825: AND REL.PARTY_ID = C.PARTY_ID
826: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
827: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
828: AND REL.DIRECTIONAL_FLAG = 'F'
829: AND O.PARTY_ID = p_org_party_id;
830:
831:

Line 838: , HZ_PARTIES C

834: P.PARTY_ID
835: -- , P.PARTY_NAME
836: FROM
837: HZ_PARTY_RELATIONSHIPS REL
838: , HZ_PARTIES C
839: , HZ_PARTIES P
840: , HZ_PARTIES O
841: WHERE O.PARTY_TYPE = 'ORGANIZATION'
842: AND O.PARTY_ID = REL.OBJECT_ID

Line 839: , HZ_PARTIES P

835: -- , P.PARTY_NAME
836: FROM
837: HZ_PARTY_RELATIONSHIPS REL
838: , HZ_PARTIES C
839: , HZ_PARTIES P
840: , HZ_PARTIES O
841: WHERE O.PARTY_TYPE = 'ORGANIZATION'
842: AND O.PARTY_ID = REL.OBJECT_ID
843: AND P.PARTY_TYPE = 'PERSON'

Line 840: , HZ_PARTIES O

836: FROM
837: HZ_PARTY_RELATIONSHIPS REL
838: , HZ_PARTIES C
839: , HZ_PARTIES P
840: , HZ_PARTIES O
841: WHERE O.PARTY_TYPE = 'ORGANIZATION'
842: AND O.PARTY_ID = REL.OBJECT_ID
843: AND P.PARTY_TYPE = 'PERSON'
844: AND P.PARTY_ID = REL.SUBJECT_ID

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

930: -- Dbms_output.put_line('P Id*'||l_contact_preference_id||' Null');
931: null;
932: ELSE
933: -- Dbms_output.put_line('P Id*'||l_contact_preference_id||' Create');
934: l_contact_preference_rec.CONTACT_LEVEL_TABLE := 'HZ_PARTIES';
935: l_contact_preference_rec.CONTACT_LEVEL_TABLE_ID := l_p_party_id;
936: l_contact_preference_rec.PREFERENCE_CODE := 'DO_NOT';
937: l_contact_preference_rec.REQUESTED_BY := 'PARTY';
938: --Begin bug#5087608 schekuri 27-May-2006