106: qual.qualifier_attribute,
107: qual.qualifier_attr_value,
108: qual.qualifier_grouping_no
109: FROM
110: qp_interface_qualifiers qual
111: WHERE
112: qual.process_id = p_process_id;
113:
114: CURSOR l_lines IS
1266:
1267: -- obtain party_name
1268: SELECT q.qualifier_attr_value
1269: INTO l_party_name
1270: FROM qp_interface_qualifiers q
1271: WHERE q.process_id = p_process_id AND q.qualifier_context = 'PARTY';
1272:
1273: --obtain the party_id
1274: SELECT hz_parties.party_id