APPS.OZF_PARTY_MKT_SEG_LOADER_PVT dependencies on HZ_RELATIONSHIPS

Line 987: 'hz_relationships hzpr ';

983: 'FROM hz_cust_site_uses_all hzcsua, '||
984: 'hz_cust_acct_sites_all hzcasa, '||
985: 'hz_cust_accounts hzca, ';
986: l_party_select_sql := l_party_select_sql ||
987: 'hz_relationships hzpr ';
988: l_party_where_sql := 'WHERE ' ;
989: --R12
990: IF l_terr_limited_to_ou = 'Y'
991: THEN

Line 1018: ', hz_relationships hzpr ';

1014: --
1015: ELSE
1016: --
1017: l_party_select_sql := l_party_select_sql ||
1018: ', hz_relationships hzpr ';
1019: l_party_where_sql := l_party_where_sql ||
1020: 'hzpr.subject_id = hzca.party_id '||
1021: 'AND hzpr.start_date <= SYSDATE ' ;
1022: l_party_where_sql := l_party_where_sql ||

Line 1123: --R12: mkothari 'hz_relationships hzpr, '||

1119: 'FROM hz_cust_site_uses_all hzcsua, '||
1120: 'hz_cust_acct_sites_all hzcasa, '||
1121: 'hz_cust_accounts hzca, ';
1122: l_party_select_sql := l_party_select_sql ||
1123: --R12: mkothari 'hz_relationships hzpr, '||
1124: 'hz_party_sites hzps, '||
1125: 'hz_locations hzloc ';
1126: l_party_where_sql := 'WHERE ' || l_hzlocations_sql;
1127: --R12

Line 1677: FROM hz_relationships

1673: l_client_info NUMBER;
1674: l_index NUMBER;
1675: CURSOR c_get_object_ids IS
1676: SELECT subject_id
1677: FROM hz_relationships
1678: WHERE relationship_code = fnd_profile.VALUE('OZF_PARTY_RELATIONS_TYPE')
1679: AND subject_type = 'ORGANIZATION'
1680: AND subject_table_name = 'HZ_PARTIES'
1681: AND object_type = 'ORGANIZATION'

Line 1970: FROM hz_relationships r1

1966: /* yzhao: 08/07/2002 fix performance issue. Use index on relationship_type */
1967: CURSOR c_get_all_bgroots(p_relationship_code VARCHAR2, p_relationship_type VARCHAR2, p_direction_code VARCHAR2) IS
1968: -- get all root object_ids
1969: SELECT distinct r1.object_id
1970: FROM hz_relationships r1
1971: WHERE r1.relationship_type = p_relationship_type
1972: AND r1.relationship_code = p_relationship_code
1973: AND r1.subject_type = 'ORGANIZATION'
1974: AND r1.subject_table_name = 'HZ_PARTIES'

Line 1985: FROM hz_relationships r2

1981: */
1982: AND r1.directional_flag = NVL(p_direction_code, r1.directional_flag)
1983: AND NOT EXISTS
1984: (SELECT 1
1985: FROM hz_relationships r2
1986: WHERE r1.object_id = r2.subject_id
1987: AND r2.relationship_type = p_relationship_type
1988: AND r2.relationship_code = p_relationship_code
1989: AND r2.subject_type = 'ORGANIZATION'