APPS.FND_PII_UTILITY_PVT dependencies on FND_BUSINESS_PURPOSES_B

Line 45: AND pref.preference_topic_type = 'FND_BUSINESS_PURPOSES_B' -- this will be FND_BUSINESS_PURPOSES

41: FROM HZ_CONTACT_PREFERENCES pref
42: WHERE pref.CONTACT_LEVEL_TABLE_ID = l_party_id
43: AND pref.CONTACT_LEVEL_TABLE = 'HZ_PARTIES'
44: AND pref.preference_topic_type_code = l_purpose_code -- this will be l_purpose_code
45: AND pref.preference_topic_type = 'FND_BUSINESS_PURPOSES_B' -- this will be FND_BUSINESS_PURPOSES
46: AND pref.contact_type = 'PRIV_PREF'
47: AND status = 'A';
48:
49: r_pref c_pref%rowtype;

Line 54: from fnd_business_purposes_b

50:
51: cursor c_default(l_purpose_code in varchar2)
52: is
53: select decode(purpose_default_code, 'N', 'I', purpose_default_code) purpose_default_code
54: from fnd_business_purposes_b
55: where purpose_code = l_purpose_code;
56:
57: r_default c_default%rowtype;
58:

Line 167: fnd_business_purposes_b purp

163: select attr.purpose_attribute_id,
164: attr.purpose_code,
165: purp.purpose_default_code
166: from fnd_purpose_attributes attr,
167: fnd_business_purposes_b purp
168: where attr.privacy_attribute_code = l_privacy_attribute_code
169: and attr.purpose_code = purp.purpose_code;
170:
171: r_purp c_purp%rowtype;

Line 183: AND pref.preference_topic_type = 'FND_BUSINESS_PURPOSES_B' -- this will be FND_BUSINESS_PURPOSES

179: FROM HZ_CONTACT_PREFERENCES pref
180: WHERE pref.CONTACT_LEVEL_TABLE_ID = l_party_id
181: AND pref.CONTACT_LEVEL_TABLE = 'HZ_PARTIES'
182: AND pref.preference_topic_type_code = l_purpose_code -- this will be l_purpose_code
183: AND pref.preference_topic_type = 'FND_BUSINESS_PURPOSES_B' -- this will be FND_BUSINESS_PURPOSES
184: AND pref.contact_type = 'PRIV_PREF'
185: AND status = 'A' ;
186:
187:

Line 301: AND pref.preference_topic_type = 'FND_BUSINESS_PURPOSES_B' -- this will be FND_BUSINESS_PURPOSES

297: FROM HZ_CONTACT_PREFERENCES pref
298: WHERE pref.CONTACT_LEVEL_TABLE_ID = l_party_id
299: AND pref.CONTACT_LEVEL_TABLE = 'HZ_PARTIES'
300: AND pref.preference_topic_type_code = l_purpose_code -- this will be l_purpose_code
301: AND pref.preference_topic_type = 'FND_BUSINESS_PURPOSES_B' -- this will be FND_BUSINESS_PURPOSES
302: AND pref.contact_type = 'PRIV_PREF'
303: AND status = 'A';
304:
305: r_pref c_pref%rowtype;

Line 310: from fnd_business_purposes_b

306:
307: cursor c_default(l_purpose_code in varchar2)
308: is
309: select purpose_default_code
310: from fnd_business_purposes_b
311: where purpose_code = l_purpose_code;
312:
313: r_default c_default%rowtype;
314: