APPS.FUN_BAL_UTILS_GRP dependencies on FUN_BALANCE_ACCOUNTS

Line 458: FROM fun_balance_accounts accts

454: CURSOR c_get_intra_ccid (p_template_id NUMBER,
455: p_acct_type VARCHAR2)
456: IS
457: SELECT DECODE (p_acct_type, 'D', accts.dr_ccid, 'C', cr_ccid) ccid
458: FROM fun_balance_accounts accts
459: WHERE accts.template_id = p_template_id
460: AND accts.dr_bsv = 'OTHER1234567890123456789012345'
461: AND accts.cr_bsv = 'OTHER1234567890123456789012345' ;
462:

Line 1176: FROM fun_balance_accounts accts

1172: p_cr_bsv VARCHAR2,
1173: p_acct_type VARCHAR2)
1174: IS
1175: SELECT NVL((SELECT DECODE (p_acct_type, 'D', accts.dr_ccid, 'C', cr_ccid)
1176: FROM fun_balance_accounts accts
1177: WHERE accts.template_id = p_template_id
1178: AND accts.dr_bsv = p_dr_bsv
1179: AND accts.cr_bsv = p_cr_bsv),
1180: NVL((SELECT DECODE (p_acct_type, 'D', accts.dr_ccid, 'C', cr_ccid)

Line 1181: FROM fun_balance_accounts accts

1177: WHERE accts.template_id = p_template_id
1178: AND accts.dr_bsv = p_dr_bsv
1179: AND accts.cr_bsv = p_cr_bsv),
1180: NVL((SELECT DECODE (p_acct_type, 'D', accts.dr_ccid, 'C', cr_ccid)
1181: FROM fun_balance_accounts accts
1182: WHERE accts.template_id = p_template_id
1183: AND accts.dr_bsv = p_dr_bsv
1184: AND accts.cr_bsv = 'OTHER1234567890123456789012345'),
1185: NVL((SELECT DECODE (p_acct_type, 'D', accts.dr_ccid, 'C', cr_ccid)

Line 1186: FROM fun_balance_accounts accts

1182: WHERE accts.template_id = p_template_id
1183: AND accts.dr_bsv = p_dr_bsv
1184: AND accts.cr_bsv = 'OTHER1234567890123456789012345'),
1185: NVL((SELECT DECODE (p_acct_type, 'D', accts.dr_ccid, 'C', cr_ccid)
1186: FROM fun_balance_accounts accts
1187: WHERE accts.template_id = p_template_id
1188: AND accts.dr_bsv = 'OTHER1234567890123456789012345'
1189: AND accts.cr_bsv = p_cr_bsv),
1190: (SELECT DECODE (p_acct_type, 'D', accts.dr_ccid, 'C', cr_ccid)

Line 1191: FROM fun_balance_accounts accts

1187: WHERE accts.template_id = p_template_id
1188: AND accts.dr_bsv = 'OTHER1234567890123456789012345'
1189: AND accts.cr_bsv = p_cr_bsv),
1190: (SELECT DECODE (p_acct_type, 'D', accts.dr_ccid, 'C', cr_ccid)
1191: FROM fun_balance_accounts accts
1192: WHERE accts.template_id = p_template_id
1193: AND accts.dr_bsv = 'OTHER1234567890123456789012345'
1194: AND accts.cr_bsv = 'OTHER1234567890123456789012345')))) ccid
1195: From Dual;

Line 1213: l_dr_bsv FUN_BALANCE_ACCOUNTS.DR_BSV%TYPE;

1209: l_dummy NUMBER;
1210: l_ic_seg_num NUMBER;
1211: l_bal_seg_num NUMBER;
1212: -- Bug: 7368523
1213: l_dr_bsv FUN_BALANCE_ACCOUNTS.DR_BSV%TYPE;
1214: l_cr_bsv FUN_BALANCE_ACCOUNTS.CR_BSV%TYPE;
1215: l_check_ccid NUMBER;
1216: BEGIN
1217:

Line 1214: l_cr_bsv FUN_BALANCE_ACCOUNTS.CR_BSV%TYPE;

1210: l_ic_seg_num NUMBER;
1211: l_bal_seg_num NUMBER;
1212: -- Bug: 7368523
1213: l_dr_bsv FUN_BALANCE_ACCOUNTS.DR_BSV%TYPE;
1214: l_cr_bsv FUN_BALANCE_ACCOUNTS.CR_BSV%TYPE;
1215: l_check_ccid NUMBER;
1216: BEGIN
1217:
1218: l_check_ccid := 0;