APPS.FTP_TP_PKG dependencies on FTP_PREPAYMENT_RULE

Line 241: (select distinct line_item_id from ftp_prepayment_rule p

237: begin
238: user_id := fnd_global.user_id;
239: login_id := fnd_global.login_id;
240: update ftp_tp_pp_node_map a set pp_node =
241: (select distinct line_item_id from ftp_prepayment_rule p
242: where p.object_definition_id = pp_obj_def
243: and p.line_item_id = a.line_item_id
244: and p.currency = a.currency),
245: -- The object id will always be the same.

Line 364: cursor c is select distinct currency from ftp_prepayment_rule

360: l_value_set_id in number,
361: hier_id in number) is
362: user_id number;
363: login_id number;
364: cursor c is select distinct currency from ftp_prepayment_rule
365: where object_definition_id = pp_obj_def;
366: begin
367: user_id := fnd_global.user_id;
368: login_id := fnd_global.login_id;

Line 380: and exists (select null from ftp_prepayment_rule pp

376: /* restrict to leaves in hierarchy */
377: and a.line_item_id = h.child_id
378: and h.child_value_set_id = l_value_set_id
379: /* restrict to parents in pp id */
380: and exists (select null from ftp_prepayment_rule pp
381: where pp.object_definition_id = pp_obj_def
382: and pp.line_item_id = h.parent_id
383: and pp.currency = cur.currency)
384: /* restrict to lowest level when overrides exist */

Line 389: ftp_prepayment_rule q

385: /* select max level num parent existing for given */
386: /* child within ID */
387: and h.parent_depth_num = (select max(h1.parent_depth_num)
388: from fem_ln_items_hier h1,
389: ftp_prepayment_rule q
390: where h1.hierarchy_obj_def_id
391: = hier_id
392: and q.object_definition_id
393: = pp_obj_def