APPS.FUN_BAL_PKG dependencies on FUN_BALANCE_OPTIONS

Line 2004: FROM fun_balance_options opts

2000: WHERE
2001: 'OTHER1234567890123456789012345' = accts.cr_bsv
2002: AND 'OTHER1234567890123456789012345' = accts.dr_bsv
2003: AND accts.template_id = (SELECT NVL((SELECT opts.template_id
2004: FROM fun_balance_options opts
2005: WHERE opts.ledger_id = inter_int.ledger_id
2006: AND opts.le_id = DECODE(inter_int.intercompany_mode,
2007: 1, DECODE(inter_int.le_id, driving_cr_le_id,
2008: DECODE(inter_int.type, 'C', driving_cr_le_id, NULL),

Line 2020: FROM fun_balance_options opts

2016: AND opts.je_category_name = (select distinct je_category_name from fun_bal_le_bsv_map_gt le_bsv_map
2017: where le_bsv_map.group_id = inter_int.group_id)
2018: AND opts.status_flag = 'Y'),
2019: NVL((SELECT opts.template_id
2020: FROM fun_balance_options opts
2021: WHERE opts.ledger_id = inter_int.ledger_id
2022: AND opts.le_id = DECODE(inter_int.intercompany_mode,
2023: 1, DECODE(inter_int.le_id, driving_cr_le_id,
2024: DECODE(inter_int.type, 'C', driving_cr_le_id, NULL),

Line 2035: FROM fun_balance_options opts

2031: where le_bsv_map.group_id = inter_int.group_id)
2032: AND opts.je_category_name = 'Other'
2033: AND opts.status_flag = 'Y'),
2034: NVL((SELECT opts.template_id
2035: FROM fun_balance_options opts
2036: WHERE opts.ledger_id = inter_int.ledger_id
2037: AND opts.le_id = DECODE(inter_int.intercompany_mode,
2038: 1, DECODE(inter_int.le_id, driving_cr_le_id,
2039: DECODE(inter_int.type, 'C', driving_cr_le_id, NULL),

Line 2050: FROM fun_balance_options opts

2046: AND opts.je_category_name = (select distinct je_category_name from fun_bal_le_bsv_map_gt le_bsv_map
2047: where le_bsv_map.group_id = inter_int.group_id)
2048: AND opts.status_flag = 'Y'),
2049: (SELECT opts.template_id
2050: FROM fun_balance_options opts
2051: WHERE opts.ledger_id = inter_int.ledger_id
2052: AND opts.le_id = DECODE(inter_int.intercompany_mode,
2053: 1, DECODE(inter_int.le_id, driving_cr_le_id,
2054: DECODE(inter_int.type, 'C', driving_cr_le_id, NULL),

Line 2275: FROM fun_balance_options opts

2271: WHERE
2272: 'OTHER1234567890123456789012345' = accts.cr_bsv
2273: AND 'OTHER1234567890123456789012345' = accts.dr_bsv
2274: AND accts.template_id = (SELECT NVL((SELECT opts.template_id
2275: FROM fun_balance_options opts
2276: WHERE opts.ledger_id = inter_int.ledger_id
2277: AND opts.le_id = DECODE(inter_int.intercompany_mode,
2278: 1, DECODE(inter_int.le_id, driving_dr_le_id,
2279: DECODE(inter_int.type, 'D', driving_dr_le_id, NULL),

Line 2291: FROM fun_balance_options opts

2287: AND opts.je_category_name = (select distinct je_category_name from fun_bal_le_bsv_map_gt le_bsv_map
2288: where le_bsv_map.group_id = inter_int.group_id)
2289: AND opts.status_flag = 'Y'),
2290: NVL((SELECT opts.template_id
2291: FROM fun_balance_options opts
2292: WHERE opts.ledger_id = inter_int.ledger_id
2293: AND opts.le_id = DECODE(inter_int.intercompany_mode,
2294: 1, DECODE(inter_int.le_id, driving_dr_le_id,
2295: DECODE(inter_int.type, 'D', driving_dr_le_id, NULL),

Line 2306: FROM fun_balance_options opts

2302: where le_bsv_map.group_id = inter_int.group_id)
2303: AND opts.je_category_name = 'Other'
2304: AND opts.status_flag = 'Y'),
2305: NVL((SELECT opts.template_id
2306: FROM fun_balance_options opts
2307: WHERE opts.ledger_id = inter_int.ledger_id
2308: AND opts.le_id = DECODE(inter_int.intercompany_mode,
2309: 1, DECODE(inter_int.le_id, driving_dr_le_id,
2310: DECODE(inter_int.type, 'D', driving_dr_le_id, NULL),

Line 2321: FROM fun_balance_options opts

2317: AND opts.je_category_name = (select distinct je_category_name from fun_bal_le_bsv_map_gt le_bsv_map
2318: where le_bsv_map.group_id = inter_int.group_id)
2319: AND opts.status_flag = 'Y'),
2320: (SELECT opts.template_id
2321: FROM fun_balance_options opts
2322: WHERE opts.ledger_id = inter_int.ledger_id
2323: AND opts.le_id = DECODE(inter_int.intercompany_mode,
2324: 1, DECODE(inter_int.le_id, driving_dr_le_id,
2325: DECODE(inter_int.type, 'D', driving_dr_le_id, NULL),

Line 3045: FROM fun_balance_options opts

3041: -- Update intra_template_id in FUN_BAL_LE_BSV_MAP
3042: UPDATE fun_bal_le_bsv_map_gt le_bsv_map
3043: SET template_id =
3044: (SELECT opts.template_id
3045: FROM fun_balance_options opts
3046: WHERE le_bsv_map.ledger_id = opts.ledger_id
3047: AND Nvl(le_bsv_map.le_id, -99) = Nvl(opts.le_id,-99)
3048: AND le_bsv_map.je_source_name = opts.je_source_name
3049: AND le_bsv_map.je_category_name = opts.je_category_name

Line 3056: FROM fun_balance_options opts

3052:
3053: UPDATE fun_bal_le_bsv_map_gt le_bsv_map
3054: SET template_id =
3055: (SELECT opts.template_id
3056: FROM fun_balance_options opts
3057: WHERE le_bsv_map.ledger_id = opts.ledger_id
3058: AND Nvl(le_bsv_map.le_id, -99) = Nvl(opts.le_id,-99)
3059: AND le_bsv_map.je_source_name = opts.je_source_name
3060: AND opts.je_category_name = 'Other'

Line 3067: FROM fun_balance_options opts

3063:
3064: UPDATE fun_bal_le_bsv_map_gt le_bsv_map
3065: SET template_id =
3066: (SELECT opts.template_id
3067: FROM fun_balance_options opts
3068: WHERE le_bsv_map.ledger_id = opts.ledger_id
3069: AND Nvl(le_bsv_map.le_id, -99) = Nvl(opts.le_id,-99)
3070: AND opts.je_source_name = 'Other'
3071: AND le_bsv_map.je_category_name = opts.je_category_name

Line 3078: FROM fun_balance_options opts

3074:
3075: UPDATE fun_bal_le_bsv_map_gt le_bsv_map
3076: SET template_id =
3077: (SELECT opts.template_id
3078: FROM fun_balance_options opts
3079: WHERE le_bsv_map.ledger_id = opts.ledger_id
3080: AND Nvl(le_bsv_map.le_id, -99) = Nvl(opts.le_id,-99)
3081: -- No error here if null, since both le_id is -99 if no legal entity is specified
3082: AND opts.je_source_name = 'Other'

Line 3148: FROM fun_balance_options opts

3144: 4, NULL,
3145: le_bsv_map.clearing_bsv)),
3146: NULL),
3147: opts.many_to_many_option
3148: FROM fun_balance_options opts
3149: WHERE le_bsv_map.template_id = opts.template_id
3150: AND opts.status_flag = 'Y');
3151:
3152: