APPS.ASO_SHIPMENT_PVT dependencies on HZ_RELATIONSHIPS

Line 916: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id

912: ) RETURN VARCHAR2
913: IS
914: CURSOR C1 IS
915: select HP.party_id,HP.party_name
916: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
917: and hp.party_id=HPR.object_id
918: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
919: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';
920:

Line 958: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id

954: ) RETURN VARCHAR2
955: IS
956: CURSOR C1 IS
957: select HP.party_id,HP.person_first_name
958: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
959: and hp.party_id=HPR.subject_id
960: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
961: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';
962:

Line 1000: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id

996: ) RETURN VARCHAR2
997: IS
998: CURSOR C1 IS
999: select HP.party_id,HP.person_middle_name
1000: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
1001: and hp.party_id=HPR.subject_id
1002: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1003: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';
1004:

Line 1040: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id

1036: ) RETURN VARCHAR2
1037: IS
1038: CURSOR C1 IS
1039: select HP.party_id,HP.person_last_name
1040: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
1041: and hp.party_id=HPR.subject_id
1042: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1043: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';
1044: