26: cursor c_check_attr(l_privacy_attribute_code in varchar2,
27: l_purpose_code in varchar2)
28: is
29: select purpose_attribute_id
30: from fnd_purpose_attributes
31: where purpose_code = l_purpose_code
32: and privacy_attribute_code = l_privacy_attribute_code;
33:
34: r_check_attr c_check_attr%rowtype;
162: is
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: