APPS.OZF_PARTY_MKT_SEG_LOADER_PVT dependencies on FND_PROFILE

Line 679: l_terr_limited_to_ou VARCHAR2(1) := NVL(FND_PROFILE.VALUE('OZF_TP_TERR_LIMITED_TO_OU'), 'N');

675:
676:
677: --R12: mkothari -- added cursor to get territory org
678: CURSOR client_info_csr IS select org_id from jtf_terr_all where terr_id = p_terr_id;
679: l_terr_limited_to_ou VARCHAR2(1) := NVL(FND_PROFILE.VALUE('OZF_TP_TERR_LIMITED_TO_OU'), 'N');
680:
681: BEGIN
682: --
683: p_retcode := 0;

Line 1665: WHERE relationship_code = fnd_profile.VALUE('OZF_PARTY_RELATIONS_TYPE')

1661: l_index NUMBER;
1662: CURSOR c_get_object_ids IS
1663: SELECT subject_id
1664: FROM hz_relationships
1665: WHERE relationship_code = fnd_profile.VALUE('OZF_PARTY_RELATIONS_TYPE')
1666: AND subject_type = 'ORGANIZATION'
1667: AND subject_table_name = 'HZ_PARTIES'
1668: AND object_type = 'ORGANIZATION'
1669: AND object_table_name = 'HZ_PARTIES'

Line 2000: l_rel_profile := fnd_profile.VALUE('OZF_PARTY_RELATIONS_TYPE');

1996: errbuf := null;
1997: retcode := 0;
1998: /* yzhao: 08/07/2002 fix bug 2503141 performance issue. Use index on relationship_type */
1999: l_direction_code := NULL;
2000: l_rel_profile := fnd_profile.VALUE('OZF_PARTY_RELATIONS_TYPE');
2001: OPEN c_get_relationship_type(l_rel_profile);
2002: FETCH c_get_relationship_type INTO l_rel_type, l_direction_code;
2003: CLOSE c_get_relationship_type;
2004: IF p_bg_id IS NOT NULL THEN