APPS.PV_PTR_MEMBER_TYPE_PVT dependencies on HZ_PARTIES

Line 386: FROM hz_parties

382: */
383:
384: CURSOR party_cur(p_ptnr_party_id NUMBER) IS
385: SELECT object_version_number
386: FROM hz_parties
387: WHERE party_id=p_ptnr_party_id;
388:
389: CURSOR get_memb_csr ( attr_cd IN VARCHAR2 ) IS
390: SELECT DESCRIPTION

Line 398: FROM hz_parties party

394: AND ATTR_CODE =attr_cd;
395:
396: CURSOR get_party_csr( p_partner_id IN NUMBER ) IS
397: SELECT party_name
398: FROM hz_parties party
399: ,pv_partner_profiles prof
400: WHERE prof.partner_id=p_partner_id
401: AND prof.partner_party_id=party.party_id;
402:

Line 807: l_relationship_rec.subject_table_name := 'HZ_PARTIES';

803: -- create a new relationship in TCA for subsidiary global relationship
804: -- Initilize the l_relationship_rec with required values.
805: l_relationship_rec.subject_id := l_partner_party_id;--subsidiary party id
806: l_relationship_rec.subject_type := 'ORGANIZATION';
807: l_relationship_rec.subject_table_name := 'HZ_PARTIES';
808: l_relationship_rec.object_id := l_global_partner_party_id; --global party id
809: l_relationship_rec.object_type := 'ORGANIZATION';
810: l_relationship_rec.object_table_name := 'HZ_PARTIES';
811: l_relationship_rec.relationship_code := 'SUBSIDIARY_OF';

Line 810: l_relationship_rec.object_table_name := 'HZ_PARTIES';

806: l_relationship_rec.subject_type := 'ORGANIZATION';
807: l_relationship_rec.subject_table_name := 'HZ_PARTIES';
808: l_relationship_rec.object_id := l_global_partner_party_id; --global party id
809: l_relationship_rec.object_type := 'ORGANIZATION';
810: l_relationship_rec.object_table_name := 'HZ_PARTIES';
811: l_relationship_rec.relationship_code := 'SUBSIDIARY_OF';
812: l_relationship_rec.relationship_type := 'PARTNER_HIERARCHY';
813: l_relationship_rec.start_date := SYSDATE;
814: l_relationship_rec.created_by_module:= 'PV';

Line 1191: (select 1 from hz_parties hzp, pv_partner_profiles pvpp, pv_enty_attr_values pvev

1187: IS
1188:
1189: cursor cv_validate_global_orgzn(cv_orgzn_number VARCHAR2) IS
1190: select 1 from dual where exists
1191: (select 1 from hz_parties hzp, pv_partner_profiles pvpp, pv_enty_attr_values pvev
1192: where hzp.party_number= cv_orgzn_number
1193: and hzp.party_id = pvpp.partner_party_id
1194: and pvpp.status = 'A'
1195: and pvpp.partner_id = pvev.entity_id

Line 1229: select pvpp.partner_id from hz_parties hzp, pv_partner_profiles pvpp, pv_enty_attr_values pvev

1225: IS
1226: l_global_prtnr_id NUMBER := NULL ;
1227:
1228: cursor cv_get_global_prtnr_id(cv_orgzn_number VARCHAR2) IS
1229: select pvpp.partner_id from hz_parties hzp, pv_partner_profiles pvpp, pv_enty_attr_values pvev
1230: where hzp.party_number= cv_orgzn_number
1231: and hzp.party_id = pvpp.partner_party_id
1232: and pvpp.status = 'A'
1233: and pvpp.partner_id = pvev.entity_id

Line 1395: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'

1391: BEGIN
1392: SELECT 1 INTO l_count
1393: FROM HZ_RELATIONSHIPS
1394: WHERE SUBJECT_ID = l_subject_id -- subsidiary partner party id
1395: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
1396: AND OBJECT_TYPE = 'ORGANIZATION'
1397: AND RELATIONSHIP_TYPE = 'PARTNER_HIERARCHY'
1398: AND DIRECTION_CODE = 'C'
1399: AND STATUS='A';

Line 1589: FROM hz_parties party

1585: AND ATTR_CODE =attr_cd;
1586:
1587: CURSOR get_party_csr( p_partner_id IN NUMBER ) IS
1588: SELECT party_name
1589: FROM hz_parties party
1590: ,pv_partner_profiles prof
1591: WHERE prof.partner_id=p_partner_id
1592: AND prof.partner_party_id=party.party_id;
1593: