APPS.FUN_BAL_PKG dependencies on FUN_BALANCE_OPTIONS

Line 2076: FROM fun_balance_options opts

2072: -- Update intra_template_id in FUN_BAL_LE_BSV_MAP
2073: UPDATE fun_bal_le_bsv_map_gt le_bsv_map
2074: SET template_id =
2075: (SELECT opts.template_id
2076: FROM fun_balance_options opts
2077: WHERE le_bsv_map.ledger_id = opts.ledger_id
2078: AND Nvl(le_bsv_map.le_id, -99) = Nvl(opts.le_id,-99)
2079: AND le_bsv_map.je_source_name = opts.je_source_name
2080: AND le_bsv_map.je_category_name = opts.je_category_name

Line 2087: FROM fun_balance_options opts

2083:
2084: UPDATE fun_bal_le_bsv_map_gt le_bsv_map
2085: SET template_id =
2086: (SELECT opts.template_id
2087: FROM fun_balance_options opts
2088: WHERE le_bsv_map.ledger_id = opts.ledger_id
2089: AND Nvl(le_bsv_map.le_id, -99) = Nvl(opts.le_id,-99)
2090: AND le_bsv_map.je_source_name = opts.je_source_name
2091: AND opts.je_category_name = 'Other'

Line 2098: FROM fun_balance_options opts

2094:
2095: UPDATE fun_bal_le_bsv_map_gt le_bsv_map
2096: SET template_id =
2097: (SELECT opts.template_id
2098: FROM fun_balance_options opts
2099: WHERE le_bsv_map.ledger_id = opts.ledger_id
2100: AND Nvl(le_bsv_map.le_id, -99) = Nvl(opts.le_id,-99)
2101: AND opts.je_source_name = 'Other'
2102: AND le_bsv_map.je_category_name = opts.je_category_name

Line 2109: FROM fun_balance_options opts

2105:
2106: UPDATE fun_bal_le_bsv_map_gt le_bsv_map
2107: SET template_id =
2108: (SELECT opts.template_id
2109: FROM fun_balance_options opts
2110: WHERE le_bsv_map.ledger_id = opts.ledger_id
2111: AND Nvl(le_bsv_map.le_id, -99) = Nvl(opts.le_id,-99)
2112: -- No error here if null, since both le_id is -99 if no legal entity is specified
2113: AND opts.je_source_name = 'Other'

Line 2179: FROM fun_balance_options opts

2175: 4, NULL,
2176: le_bsv_map.clearing_bsv)),
2177: NULL),
2178: opts.many_to_many_option
2179: FROM fun_balance_options opts
2180: WHERE le_bsv_map.template_id = opts.template_id
2181: AND opts.status_flag = 'Y');
2182:
2183: