APPS.FTP_TP_PKG dependencies on FTP_ADJUSTMENT_RULE

Line 272: (select distinct line_item_id, currency from ftp_adjustment_rule

268: --assumptions
269: --When not found means TP assumptions doesn't exists for the line_item,
270: --currency combo and we need to insert adjustment assumptions
271: MERGE INTO ftp_tp_pp_node_map nm USING
272: (select distinct line_item_id, currency from ftp_adjustment_rule
273: where object_definition_id = adj_obj_def) adj
274: ON (nm.line_item_id =adj.line_item_id and nm.currency=adj.currency
275: and nm.node_map_id = map_id)
276: WHEN MATCHED THEN

Line 420: cursor c is select distinct currency from ftp_adjustment_rule

416: l_value_set_id in number,
417: hier_id in number) is
418: user_id number;
419: login_id number;
420: cursor c is select distinct currency from ftp_adjustment_rule
421: where object_definition_id = adj_obj_def;
422: --l_count number;
423: begin
424: user_id := fnd_global.user_id;

Line 443: and exists (select null from ftp_adjustment_rule adj

439: /* restrict to this value set */
440: and l_value_set_id = h.parent_value_set_id
441: and l_value_set_id = h.child_value_set_id
442: /* restrict to parents in adjustment id */
443: and exists (select null from ftp_adjustment_rule adj
444: where adj.object_definition_id = adj_obj_def
445: and adj.line_item_id = h.parent_id
446: and adj.currency = cur.currency)
447: /* restrict to leaves in hierarchy */

Line 459: ftp_adjustment_rule q

455: /* restrict to lowest level when overrides exist */
456: /* select max level num parent existing for given child within ID */
457: and h.parent_depth_num = (select max(h1.parent_depth_num)
458: from fem_ln_items_hier h1,
459: ftp_adjustment_rule q
460: where h1.hierarchy_obj_def_id
461: = hier_id
462: and q.object_definition_id = adj_obj_def
463: and q.line_item_id = h1.parent_id

Line 2483: adj_type_code ftp_adjustment_rule.adjustment_type_code%TYPE;

2479:
2480: indx NUMBER;
2481: rate_output_rule_obj_id FTP_TP_PROCESS_RULE.ALT_RATE_OP_OBJECT_ID%TYPE;
2482: adj_object_id FTP_TP_PROCESS_RULE.adjustment_object_id%TYPE;
2483: adj_type_code ftp_adjustment_rule.adjustment_type_code%TYPE;
2484: ecoloss_meth_count NUMBER;
2485: TYPE varchar_std_type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
2486: rate_map_info OBJ_INFO_TYPE;
2487: adj_rule_info OBJ_INFO_TYPE;

Line 2517: from ftp_adjustment_rule

2513: -- For rate_output_rule get detail info
2514: get_obj_def(adj_object_id, effective_date, adj_rule_info);
2515:
2516: select distinct(adjustment_type_code) into adj_type_code
2517: from ftp_adjustment_rule
2518: where object_definition_id = adj_rule_info.obj_id; --11762;
2519: END IF;
2520:
2521: IF ( rate_output_rule_obj_id IS NULL ) THEN

Line 2582: from ftp_adjustment_rule where

2578: g_alt_rate_obj(i).ADJ_AMOUNT_COL_NAME := 'BREAK_FUNDING_AMT';
2579:
2580: --Check for Eco Loss method to register MV Column
2581: select count(calc_method_code) into ecoloss_meth_count
2582: from ftp_adjustment_rule where
2583: object_definition_id = adj_rule_info.obj_id and
2584: calc_method_code = c_ecoloss_method;
2585:
2586: if(ecoloss_meth_count > 0) THEN