APPS.FUN_RECIPIENT_WF dependencies on FUN_UTIL

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

2512: head.to_ledger_id) ledger_id ,
2513: dist.amount_cr ,
2514: dist.amount_dr ,
2515: dist.ccid ,
2516: fun_util.get_account_segment_value (DECODE(p_party_type, 'I',
2517: btch.from_ledger_id,
2518: head.to_ledger_id),
2519: dist.ccid,
2520: 'GL_BALANCING') dist_bsv ,

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

2782: IF l_init_dist_tbl(1).AMOUNT_DR IS NULL
2783: THEN
2784: SELECT MIN(DIST_BSV)
2785: INTO l_init_bsv
2786: FROM (SELECT FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,
2787: HEAD.TO_LEDGER_ID),
2788: DIST.CCID,'GL_BALANCING') DIST_BSV,
2789: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2790: FROM FUN_DIST_LINES DIST,

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

2792: FUN_TRX_BATCHES BTCH
2793: WHERE DIST.TRX_ID = HEAD.TRX_ID
2794: AND HEAD.BATCH_ID = BTCH.BATCH_ID
2795: AND HEAD.TRX_ID = p_trx_id
2796: GROUP BY FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,
2797: HEAD.TO_LEDGER_ID),
2798: DIST.CCID,'GL_BALANCING'),
2799: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2800: HAVING SUM(NVL(DIST.AMOUNT_DR,0.00)) <> SUM(NVL(DIST.AMOUNT_CR,0.00))

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

2801: AND SUM(NVL(DIST.AMOUNT_CR,0.00)) <> 0.00);
2802:
2803: SELECT MIN(DIST_BSV)
2804: INTO l_reci_bsv
2805: FROM (SELECT FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,
2806: HEAD.TO_LEDGER_ID),
2807: DIST.CCID,'GL_BALANCING') DIST_BSV,
2808: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2809: FROM FUN_DIST_LINES DIST,

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

2811: FUN_TRX_BATCHES BTCH
2812: WHERE DIST.TRX_ID = HEAD.TRX_ID
2813: AND HEAD.BATCH_ID = BTCH.BATCH_ID
2814: AND HEAD.TRX_ID = p_trx_id
2815: GROUP BY FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,
2816: HEAD.TO_LEDGER_ID),
2817: DIST.CCID,'GL_BALANCING'),
2818: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2819: HAVING SUM(NVL(DIST.AMOUNT_DR,0.00)) <> SUM(NVL(DIST.AMOUNT_CR,0.00))

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

2820: AND SUM(NVL(DIST.AMOUNT_DR,0.00)) <> 0.00);
2821: ELSE
2822: SELECT MIN(DIST_BSV)
2823: INTO l_reci_bsv
2824: FROM (SELECT FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,
2825: HEAD.TO_LEDGER_ID),
2826: DIST.CCID,'GL_BALANCING') DIST_BSV,
2827: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2828: FROM FUN_DIST_LINES DIST,

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

2830: FUN_TRX_BATCHES BTCH
2831: WHERE DIST.TRX_ID = HEAD.TRX_ID
2832: AND HEAD.BATCH_ID = BTCH.BATCH_ID
2833: AND HEAD.TRX_ID = p_trx_id
2834: GROUP BY FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,
2835: HEAD.TO_LEDGER_ID),
2836: DIST.CCID,'GL_BALANCING'),
2837: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2838: HAVING SUM(NVL(DIST.AMOUNT_DR,0.00)) <> SUM(NVL(DIST.AMOUNT_CR,0.00))

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

2839: AND SUM(NVL(DIST.AMOUNT_CR,0.00)) <> 0.00);
2840:
2841: SELECT MIN(DIST_BSV)
2842: INTO l_init_bsv
2843: FROM (SELECT FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,
2844: HEAD.TO_LEDGER_ID),
2845: DIST.CCID,'GL_BALANCING') DIST_BSV,
2846: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2847: FROM FUN_DIST_LINES DIST,

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

2849: FUN_TRX_BATCHES BTCH
2850: WHERE DIST.TRX_ID = HEAD.TRX_ID
2851: AND HEAD.BATCH_ID = BTCH.BATCH_ID
2852: AND HEAD.TRX_ID = p_trx_id
2853: GROUP BY FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,
2854: HEAD.TO_LEDGER_ID),
2855: DIST.CCID,'GL_BALANCING'),
2856: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2857: HAVING SUM(NVL(DIST.AMOUNT_DR,0.00)) <> SUM(NVL(DIST.AMOUNT_CR,0.00))