APPS.FUN_BAL_UTILS_GRP dependencies on FUN_INTER_ACCOUNTS

Line 340: FROM fun_inter_accounts accts

336: p_acct_type VARCHAR2,
337: p_gl_date DATE)
338: IS
339: SELECT NVL( (SELECT ccid
340: FROM fun_inter_accounts accts
341: WHERE accts.ledger_id = p_ledger_id
342: AND accts.from_le_id = p_from_le_id
343: AND accts.to_le_id = p_to_le_id
344: AND accts.trans_bsv = p_from_bsv

Line 351: FROM fun_inter_accounts accts

347: AND accts.default_flag = 'Y'
348: AND (TRUNC(p_gl_date) BETWEEN TRUNC(NVL(accts.start_date, p_gl_date))
349: AND TRUNC(NVL(accts.end_date, p_gl_date)))),
350: NVL((SELECT ccid
351: FROM fun_inter_accounts accts
352: WHERE accts.ledger_id = p_ledger_id
353: AND accts.from_le_id = p_from_le_id
354: AND accts.to_le_id = p_to_le_id
355: AND accts.trans_bsv = p_from_bsv

Line 362: FROM fun_inter_accounts accts

358: AND accts.default_flag = 'Y'
359: AND (TRUNC(p_gl_date) BETWEEN TRUNC(NVL(accts.start_date, p_gl_date))
360: AND TRUNC(NVL(accts.end_date, p_gl_date)))),
361: NVL((SELECT ccid
362: FROM fun_inter_accounts accts
363: WHERE accts.ledger_id = p_ledger_id
364: AND accts.from_le_id = p_from_le_id
365: AND accts.to_le_id = p_to_le_id
366: AND accts.trans_bsv = 'OTHER1234567890123456789012345'

Line 373: FROM fun_inter_accounts accts

369: AND accts.default_flag = 'Y'
370: AND (TRUNC(p_gl_date) BETWEEN TRUNC(NVL(accts.start_date, p_gl_date))
371: AND TRUNC(NVL(accts.end_date, p_gl_date)))),
372: NVL((SELECT ccid
373: FROM fun_inter_accounts accts
374: WHERE accts.ledger_id = p_ledger_id
375: AND accts.from_le_id = p_from_le_id
376: AND accts.to_le_id = p_to_le_id
377: AND accts.trans_bsv = 'OTHER1234567890123456789012345'

Line 384: FROM fun_inter_accounts accts

380: AND accts.default_flag = 'Y'
381: AND (TRUNC(p_gl_date) BETWEEN TRUNC(NVL(accts.start_date, p_gl_date))
382: AND TRUNC(NVL(accts.end_date, p_gl_date)))),
383: (SELECT ccid
384: FROM fun_inter_accounts accts
385: WHERE accts.ledger_id = p_ledger_id
386: AND accts.from_le_id = p_from_le_id
387: AND accts.to_le_id = -99
388: AND accts.type = p_acct_type

Line 570: FROM FUN_INTER_ACCOUNTS_V

566: IF ( x_ccid <> l_setup_ccid) THEN
567: BEGIN
568:
569: SELECT 'Y' INTO l_insert_flag
570: FROM FUN_INTER_ACCOUNTS_V
571: WHERE FROM_LE_ID = p_from_le
572: AND LEDGER_ID = p_ledger_id
573: AND TO_LE_ID = p_to_le
574: AND CCID = x_ccid

Line 585: INSERT INTO FUN_INTER_ACCOUNTS_ADDL(FROM_LE_ID

581: WHEN OTHERS THEN
582: l_insert_flag := 'Y';
583: END;
584: IF (l_insert_flag = 'N') THEN
585: INSERT INTO FUN_INTER_ACCOUNTS_ADDL(FROM_LE_ID
586: , LEDGER_ID
587: , TO_LE_ID
588: , CCID
589: , TYPE

Line 643: FROM FUN_INTER_ACCOUNTS_V

639: --bug: 8200511
640: IF ( x_reciprocal_ccid <> l_setup_ccid) THEN
641: BEGIN
642: SELECT 'Y' INTO l_insert_flag
643: FROM FUN_INTER_ACCOUNTS_V
644: WHERE FROM_LE_ID = p_to_le
645: AND LEDGER_ID = p_to_ledger_id
646: AND TO_LE_ID = p_from_le
647: AND CCID = x_reciprocal_ccid

Line 658: INSERT INTO FUN_INTER_ACCOUNTS_ADDL(FROM_LE_ID

654: WHEN OTHERS THEN
655: l_insert_flag := 'Y';
656: END;
657: IF (l_insert_flag = 'N') THEN
658: INSERT INTO FUN_INTER_ACCOUNTS_ADDL(FROM_LE_ID
659: , LEDGER_ID
660: , TO_LE_ID
661: , CCID
662: , TYPE