APPS.ASO_SHIPMENT_PVT dependencies on HZ_RELATIONSHIPS

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

961: ) RETURN VARCHAR2
962: IS
963: CURSOR C1 IS
964: select HP.party_id,HP.party_name
965: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
966: and hp.party_id=HPR.object_id
967: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
968: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
969: and HPR.directional_flag = 'B'; -- Added for bug 8634067

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

1004: ) RETURN VARCHAR2
1005: IS
1006: CURSOR C1 IS
1007: select HP.party_id,HP.person_first_name
1008: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
1009: and hp.party_id=HPR.subject_id
1010: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1011: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1012: and HPR.directional_flag = 'F'; -- 8634067

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

1047: ) RETURN VARCHAR2
1048: IS
1049: CURSOR C1 IS
1050: select HP.party_id,HP.person_middle_name
1051: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
1052: and hp.party_id=HPR.subject_id
1053: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1054: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1055: and HPR.directional_flag = 'F'; -- 8634067

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

1089: ) RETURN VARCHAR2
1090: IS
1091: CURSOR C1 IS
1092: select HP.party_id,HP.person_last_name
1093: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
1094: and hp.party_id=HPR.subject_id
1095: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1096: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1097: and HPR.directional_flag = 'F'; -- 8634067