APPS.AST_UWQ_SEL_PKG dependencies on HZ_PARTIES

Line 657: and owner_party_source_table = 'HZ_PARTIES';

653: CURSOR C_getDtlsFromServiceKey(x_ServiceKey varchar2 ) IS
654: SELECT owner_party_id
655: FROM csi_item_instances
656: where instance_number = x_ServiceKey
657: and owner_party_source_table = 'HZ_PARTIES';
658: BEGIN
659:
660: LogMessage('In getDtlsFromServiceKey');
661: OPEN C_getDtlsFromServiceKey(l_ServiceKey);

Line 694: FROM hz_parties p, hz_relationships rel

690: PROCEDURE GetDtlsFromConNum IS
691: /* kmahajan - just pass back the Party_id of the relationship instead
692: CURSOR C_getDtlsFromConNum(x_contactNum varchar2 ) IS
693: SELECT rel.subject_id, rel.object_id
694: FROM hz_parties p, hz_relationships rel
695: WHERE p.party_number = x_contactNum
696: AND p.party_id = rel.party_id
697: AND rel.subject_type = 'PERSON'
698: AND rel.object_table_name = 'HZ_PARTIES'

Line 698: AND rel.object_table_name = 'HZ_PARTIES'

694: FROM hz_parties p, hz_relationships rel
695: WHERE p.party_number = x_contactNum
696: AND p.party_id = rel.party_id
697: AND rel.subject_type = 'PERSON'
698: AND rel.object_table_name = 'HZ_PARTIES'
699: AND rel.subject_table_name = 'HZ_PARTIES'
700: AND rel.object_type = 'ORGANIZATION';
701: */
702: CURSOR C_getDtlsFromConNum(x_contactNum varchar2 ) IS

Line 699: AND rel.subject_table_name = 'HZ_PARTIES'

695: WHERE p.party_number = x_contactNum
696: AND p.party_id = rel.party_id
697: AND rel.subject_type = 'PERSON'
698: AND rel.object_table_name = 'HZ_PARTIES'
699: AND rel.subject_table_name = 'HZ_PARTIES'
700: AND rel.object_type = 'ORGANIZATION';
701: */
702: CURSOR C_getDtlsFromConNum(x_contactNum varchar2 ) IS
703: SELECT party_id, party_type

Line 704: FROM hz_parties

700: AND rel.object_type = 'ORGANIZATION';
701: */
702: CURSOR C_getDtlsFromConNum(x_contactNum varchar2 ) IS
703: SELECT party_id, party_type
704: FROM hz_parties
705: WHERE party_number = x_contactNum
706: AND party_type = 'PARTY_RELATIONSHIP';
707: BEGIN
708: OPEN C_getDtlsFromConNum (l_contactNumber);

Line 723: FROM hz_parties

719: PROCEDURE GetDtlsFromCustNum IS
720: CURSOR C_GetCustId(x_custnum VARCHAR2) IS
721: SELECT party_id, party_type
722: --FROM jtf_parties_v
723: FROM hz_parties
724: WHERE party_number = x_custnum;
725: --AND party_type in ('ORGANIZATION','PERSON');
726:
727: BEGIN

Line 746: FROM hz_parties

742: -- added by rnori 07-APR-03, for bug# 2885131
743: PROCEDURE GetDtlsFromCustID IS
744: CURSOR C_GetCustId(x_custid NUMBER) IS
745: SELECT party_id,party_type
746: FROM hz_parties
747: WHERE party_id = x_custid;
748: BEGIN
749: LogMessage('GetDtls from Customer ID');
750: OPEN c_getcustid(l_customerID);

Line 766: FROM hz_cust_accounts hza, hz_parties hzp

762: PROCEDURE GetDtlsFromAccountNum IS
763:
764: CURSOR C_GetCustId(x_account_num VARCHAR2) IS
765: SELECT hzp.party_id, hza.cust_account_id, hzp.party_type
766: FROM hz_cust_accounts hza, hz_parties hzp
767: --SELECT hza.party_id, hza.cust_account_id
768: --FROM hz_cust_accounts hza
769: WHERE hza.account_number = x_account_num and
770: hza.party_id = hzp.party_id;

Line 828: FROM hz_contact_points cp, hz_parties p

824: PROCEDURE GetDtlsFromPhoneNum IS
825:
826: CURSOR C_getDtlsFromPhone(x_phonenumber varchar2 ) IS
827: SELECT cp.owner_table_id, p.party_type
828: FROM hz_contact_points cp, hz_parties p
829: WHERE cp.transposed_phone_number like x_phonenumber
830: AND cp.owner_table_name = 'HZ_PARTIES'
831: AND cp.status = 'A'
832: AND cp.owner_table_id = p.party_id;

Line 830: AND cp.owner_table_name = 'HZ_PARTIES'

826: CURSOR C_getDtlsFromPhone(x_phonenumber varchar2 ) IS
827: SELECT cp.owner_table_id, p.party_type
828: FROM hz_contact_points cp, hz_parties p
829: WHERE cp.transposed_phone_number like x_phonenumber
830: AND cp.owner_table_name = 'HZ_PARTIES'
831: AND cp.status = 'A'
832: AND cp.owner_table_id = p.party_id;
833:
834: /*