APPS.FUN_BAL_UTILS_GRP dependencies on FUN_INTER_ACCOUNTS

Line 351: FROM fun_inter_accounts accts

347: p_acct_type VARCHAR2,
348: p_gl_date DATE)
349: IS
350: SELECT 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 = p_from_bsv

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: NVL((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 = p_to_le_id
388: AND accts.trans_bsv = 'OTHER1234567890123456789012345'

Line 395: FROM fun_inter_accounts accts

391: AND accts.default_flag = 'Y'
392: AND (TRUNC(p_gl_date) BETWEEN TRUNC(NVL(accts.start_date, p_gl_date))
393: AND TRUNC(NVL(accts.end_date, p_gl_date)))),
394: NVL((SELECT ccid
395: FROM fun_inter_accounts accts
396: WHERE accts.ledger_id = p_ledger_id
397: AND accts.from_le_id = p_from_le_id
398: AND accts.to_le_id = -99
399: AND accts.trans_bsv = p_from_bsv

Line 406: FROM fun_inter_accounts accts

402: AND accts.default_flag = 'Y'
403: AND (TRUNC(p_gl_date) BETWEEN TRUNC(NVL(accts.start_date, p_gl_date))
404: AND TRUNC(NVL(accts.end_date, p_gl_date)))),
405: (SELECT ccid
406: FROM fun_inter_accounts accts
407: WHERE accts.ledger_id = p_ledger_id
408: AND accts.from_le_id = p_from_le_id
409: AND accts.to_le_id = -99
410: AND accts.trans_bsv = 'OTHER1234567890123456789012345'

Line 865: FROM FUN_INTER_ACCOUNTS_V

861: x_reciprocal_ccid := l_setup_recp_ccid;
862: END IF;
863: BEGIN
864: SELECT 'Y' INTO l_insert_flag
865: FROM FUN_INTER_ACCOUNTS_V
866: WHERE FROM_LE_ID = p_from_le
867: AND LEDGER_ID = p_ledger_id
868: AND TO_LE_ID = p_to_le
869: AND CCID = x_ccid

Line 880: INSERT INTO FUN_INTER_ACCOUNTS_ADDL(FROM_LE_ID

876: WHEN OTHERS THEN
877: l_insert_flag := 'Y';
878: END;
879: IF (l_insert_flag = 'N') THEN
880: INSERT INTO FUN_INTER_ACCOUNTS_ADDL(FROM_LE_ID
881: , LEDGER_ID
882: , TO_LE_ID
883: , CCID
884: , TYPE

Line 916: FROM FUN_INTER_ACCOUNTS_V

912: END IF;
913:
914: BEGIN
915: SELECT 'Y' INTO l_insert_flag
916: FROM FUN_INTER_ACCOUNTS_V
917: WHERE FROM_LE_ID = p_to_le
918: AND LEDGER_ID = p_to_ledger_id
919: AND TO_LE_ID = p_from_le
920: AND CCID = x_reciprocal_ccid

Line 931: INSERT INTO FUN_INTER_ACCOUNTS_ADDL(FROM_LE_ID

927: WHEN OTHERS THEN
928: l_insert_flag := 'Y';
929: END;
930: IF (l_insert_flag = 'N' AND nvl(x_reciprocal_ccid, 0) > 0) THEN
931: INSERT INTO FUN_INTER_ACCOUNTS_ADDL(FROM_LE_ID
932: , LEDGER_ID
933: , TO_LE_ID
934: , CCID
935: , TYPE