[Home] [Help]
223: select distinct map_id, line_item_id, l_value_set_id,
224: currency, line_item_id,
225: null, sysdate,
226: user_id, user_id, sysdate, login_id,
227: OBJECT_ID,REQUEST_ID,OBJECT_ID,REQUEST_ID from ftp_transfer_price_rule
228: where object_definition_id = tp_obj_def;
229: end populate_non_hier_tp;
230: -- procedure to populate pp nodes on ftp_tp_node_map when there is
231: -- no hierarchy used for prepayment
294: l_value_set_id in number,
295: hier_id in number) is
296: user_id number;
297: login_id number;
298: cursor c is select distinct currency from ftp_transfer_price_rule
299: where object_definition_id = tp_obj_def;
300: begin
301: user_id := fnd_global.user_id;
302: login_id := fnd_global.login_id;
323: /* restrict to this value set */
324: and l_value_set_id = h.parent_value_set_id
325: and l_value_set_id = h.child_value_set_id
326: /* restrict to parents in tp id */
327: and exists (select null from ftp_transfer_price_rule tp
328: where tp.object_definition_id = tp_obj_def
329: and tp.line_item_id = h.parent_id
330: and tp.currency = cur.currency)
331: /* restrict to leaves in hierarchy */
339: /* restrict to lowest level when overrides exist */
340: /* select max level num parent existing for given child within ID */
341: and h.parent_depth_num = (select max(h1.parent_depth_num)
342: from fem_ln_items_hier h1,
343: ftp_transfer_price_rule q
344: where h1.hierarchy_obj_def_id
345: = hier_id
346: and q.object_definition_id = tp_obj_def
347: and q.line_item_id = h1.parent_id