APPS.FUN_BAL_PKG dependencies on GL_LEDGER_LE_BSV_SPECIFIC_V

Line 764: FROM gl_ledger_le_bsv_specific_v vals

760: -- Legal entity can only be either null or has a specific value
761: UPDATE fun_bal_le_bsv_map_gt bsv_le_map
762: SET le_id =
763: NVL((SELECT vals.legal_entity_id
764: FROM gl_ledger_le_bsv_specific_v vals
765: WHERE bsv_le_map.bal_seg_val = vals.segment_value
766: AND (TRUNC(bsv_le_map.gl_date) BETWEEN TRUNC(NVL(vals.start_date, bsv_le_map.gl_date)) AND
767: TRUNC(NVL(vals.end_date, bsv_le_map.gl_date)))
768: AND bsv_le_map.ledger_id = vals.ledger_id

Line 782: FROM gl_ledger_le_bsv_specific_v vals

778: WHERE hdrs.group_id = lines.group_id
779: AND hdrs.ledger_id = ledger.ledger_id(+)
780: AND ledger.bal_seg_value_option_code = 'I') main
781: WHERE main.bal_seg_val NOT IN (SELECT vals.segment_value
782: FROM gl_ledger_le_bsv_specific_v vals
783: WHERE main.ledger_id = vals.ledger_id
784: AND TRUNC(main.gl_date) BETWEEN
785: TRUNC(NVL(vals.start_date, main.gl_date)) AND
786: TRUNC(NVL(vals.end_date, main.gl_date)));

Line 821: gl_ledger_le_bsv_specific_v vals

817: AND hdrs.ledger_id = ledger.ledger_id(+)
818: AND ledger.configuration_id = config.configuration_id
819: AND ledger.configuration_id <> -2 -- Bug 3271446
820: AND ledger.bal_seg_value_option_code = 'I') main,
821: gl_ledger_le_bsv_specific_v vals
822: WHERE main.bal_seg_val = vals.segment_value(+)
823: AND (TRUNC(main.gl_date) BETWEEN TRUNC(NVL(vals.start_date, main.gl_date)) AND
824: TRUNC(NVL(vals.end_date, main.gl_date)))
825: AND main.ledger_id = vals.ledger_id(+);

Line 865: FROM gl_ledger_le_bsv_specific_v vals

861: (headers.le_count = 1 AND headers.unmapped_bsv_le_id = -99)
862: OR
863: (headers.le_id IS NOT NULL
864: AND NOT EXISTS (SELECT 'BSV belongs to the LE'
865: FROM gl_ledger_le_bsv_specific_v vals
866: WHERE vals.segment_value = headers.clearing_bsv
867: AND vals.ledger_id = headers.ledger_id
868: AND vals.legal_entity_id = headers.le_id))
869: OR

Line 872: FROM gl_ledger_le_bsv_specific_v vals

868: AND vals.legal_entity_id = headers.le_id))
869: OR
870: (headers.le_id IS NULL
871: AND EXISTS (SELECT 'BSV belongs to Ledger'
872: FROM gl_ledger_le_bsv_specific_v vals
873: WHERE vals.segment_value = headers.clearing_bsv
874: AND vals.ledger_id = headers.ledger_id
875: AND vals.legal_entity_id IS NOT NULL))); -- Bug 3278912
876:

Line 888: FROM gl_ledger_le_bsv_specific_v vals

884: FROM gl_ledgers ledgers
885: WHERE ledgers.bal_seg_value_option_code = 'A')
886: OR
887: hdrs.clearing_bsv IN (SELECT vals.segment_value
888: FROM gl_ledger_le_bsv_specific_v vals
889: WHERE hdrs.ledger_id = vals.ledger_id
890: AND TRUNC(hdrs.gl_date) BETWEEN
891: TRUNC(NVL(vals.start_date, hdrs.gl_date))
892: AND

Line 2942: FROM gl_ledger_le_bsv_specific_v vals

2938: -- Update Legal entity for each ledger, BSV combination. Legal entity can only be either null or has a specific value
2939: UPDATE fun_bal_le_bsv_map_gt bsv_le_map
2940: SET le_id =
2941: NVL((SELECT vals.legal_entity_id
2942: FROM gl_ledger_le_bsv_specific_v vals
2943: WHERE bsv_le_map.bal_seg_val = vals.segment_value
2944: AND (TRUNC(bsv_le_map.gl_date) BETWEEN TRUNC(NVL(vals.start_date, bsv_le_map.gl_date)) AND
2945: TRUNC(NVL(vals.end_date, bsv_le_map.gl_date)))
2946: AND bsv_le_map.ledger_id = vals.ledger_id

Line 3193: FROM gl_ledger_le_bsv_specific_v gl_seg

3189: AND ledger.ledger_id = le_bsv_map.ledger_id
3190: AND ledger.bal_seg_value_option_code = 'I'
3191: AND NOT EXISTS
3192: (SELECT 'X'
3193: FROM gl_ledger_le_bsv_specific_v gl_seg
3194: WHERE gl_seg.ledger_id = le_bsv_map.ledger_id
3195: AND gl_seg.segment_value = le_bsv_map.clearing_bsv
3196: AND TRUNC(le_bsv_map.gl_date) BETWEEN TRUNC(NVL(gl_seg.start_date, le_bsv_map.gl_date))
3197: AND TRUNC(NVL(gl_seg.end_date, le_bsv_map.gl_date)));