APPS.FUN_RECIPIENT_WF dependencies on FUN_UTIL

Line 2288: fun_util.get_account_segment_value (DECODE(p_party_type, 'I',

2284: head.to_ledger_id) ledger_id ,
2285: dist.amount_cr ,
2286: dist.amount_dr ,
2287: dist.ccid ,
2288: fun_util.get_account_segment_value (DECODE(p_party_type, 'I',
2289: btch.from_ledger_id,
2290: head.to_ledger_id),
2291: dist.ccid,
2292: 'GL_BALANCING') dist_bsv ,

Line 2550: FROM (SELECT FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,

2546: IF l_init_dist_tbl(1).AMOUNT_DR IS NULL
2547: THEN
2548: SELECT MIN(DIST_BSV)
2549: INTO l_init_bsv
2550: FROM (SELECT FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,
2551: HEAD.TO_LEDGER_ID),
2552: DIST.CCID,'GL_BALANCING') DIST_BSV,
2553: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2554: FROM FUN_DIST_LINES DIST,

Line 2560: GROUP BY FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,

2556: FUN_TRX_BATCHES BTCH
2557: WHERE DIST.TRX_ID = HEAD.TRX_ID
2558: AND HEAD.BATCH_ID = BTCH.BATCH_ID
2559: AND HEAD.TRX_ID = p_trx_id
2560: GROUP BY FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,
2561: HEAD.TO_LEDGER_ID),
2562: DIST.CCID,'GL_BALANCING'),
2563: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2564: HAVING SUM(NVL(DIST.AMOUNT_DR,0.00)) <> SUM(NVL(DIST.AMOUNT_CR,0.00))

Line 2569: FROM (SELECT FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,

2565: AND SUM(NVL(DIST.AMOUNT_CR,0.00)) <> 0.00);
2566:
2567: SELECT MIN(DIST_BSV)
2568: INTO l_reci_bsv
2569: FROM (SELECT FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,
2570: HEAD.TO_LEDGER_ID),
2571: DIST.CCID,'GL_BALANCING') DIST_BSV,
2572: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2573: FROM FUN_DIST_LINES DIST,

Line 2579: GROUP BY FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,

2575: FUN_TRX_BATCHES BTCH
2576: WHERE DIST.TRX_ID = HEAD.TRX_ID
2577: AND HEAD.BATCH_ID = BTCH.BATCH_ID
2578: AND HEAD.TRX_ID = p_trx_id
2579: GROUP BY FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,
2580: HEAD.TO_LEDGER_ID),
2581: DIST.CCID,'GL_BALANCING'),
2582: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2583: HAVING SUM(NVL(DIST.AMOUNT_DR,0.00)) <> SUM(NVL(DIST.AMOUNT_CR,0.00))

Line 2588: FROM (SELECT FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,

2584: AND SUM(NVL(DIST.AMOUNT_DR,0.00)) <> 0.00);
2585: ELSE
2586: SELECT MIN(DIST_BSV)
2587: INTO l_reci_bsv
2588: FROM (SELECT FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,
2589: HEAD.TO_LEDGER_ID),
2590: DIST.CCID,'GL_BALANCING') DIST_BSV,
2591: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2592: FROM FUN_DIST_LINES DIST,

Line 2598: GROUP BY FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,

2594: FUN_TRX_BATCHES BTCH
2595: WHERE DIST.TRX_ID = HEAD.TRX_ID
2596: AND HEAD.BATCH_ID = BTCH.BATCH_ID
2597: AND HEAD.TRX_ID = p_trx_id
2598: GROUP BY FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,
2599: HEAD.TO_LEDGER_ID),
2600: DIST.CCID,'GL_BALANCING'),
2601: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2602: HAVING SUM(NVL(DIST.AMOUNT_DR,0.00)) <> SUM(NVL(DIST.AMOUNT_CR,0.00))

Line 2607: FROM (SELECT FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,

2603: AND SUM(NVL(DIST.AMOUNT_CR,0.00)) <> 0.00);
2604:
2605: SELECT MIN(DIST_BSV)
2606: INTO l_init_bsv
2607: FROM (SELECT FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,
2608: HEAD.TO_LEDGER_ID),
2609: DIST.CCID,'GL_BALANCING') DIST_BSV,
2610: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2611: FROM FUN_DIST_LINES DIST,

Line 2617: GROUP BY FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,

2613: FUN_TRX_BATCHES BTCH
2614: WHERE DIST.TRX_ID = HEAD.TRX_ID
2615: AND HEAD.BATCH_ID = BTCH.BATCH_ID
2616: AND HEAD.TRX_ID = p_trx_id
2617: GROUP BY FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,
2618: HEAD.TO_LEDGER_ID),
2619: DIST.CCID,'GL_BALANCING'),
2620: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2621: HAVING SUM(NVL(DIST.AMOUNT_DR,0.00)) <> SUM(NVL(DIST.AMOUNT_CR,0.00))