APPS.FUN_BAL_UTILS_GRP dependencies on DUAL

Line 416: From Dual;

412: AND accts.type = p_acct_type
413: AND accts.default_flag = 'Y'
414: AND (TRUNC(p_gl_date) BETWEEN TRUNC(NVL(accts.start_date, p_gl_date))
415: AND TRUNC(NVL(accts.end_date, p_gl_date))))))))) ccid
416: From Dual;
417:
418: -- ER: 8588074
419: CURSOR c_get_template (p_ledger_id NUMBER,
420: p_le_id NUMBER,

Line 452: From Dual where fun_trx_pvt.get_inter_intra()='Y';

448: AND Nvl(opts.le_id,-99) = Nvl(p_le_id,-99)
449: AND opts.je_source_name = 'Other'
450: AND opts.je_category_name = 'Other'
451: AND opts.status_flag = 'Y')))) template_id
452: From Dual where fun_trx_pvt.get_inter_intra()='Y';
453:
454: CURSOR c_get_intra_ccid (p_template_id NUMBER,
455: p_acct_type VARCHAR2)
456: IS

Line 1168: From Dual;

1164: AND Nvl(opts.le_id,-99) = Nvl(p_le_id,-99)
1165: AND opts.je_source_name = 'Other'
1166: AND opts.je_category_name = 'Other'
1167: AND opts.status_flag = 'Y')))) template_id
1168: From Dual;
1169:
1170: CURSOR c_get_ccid (p_template_id NUMBER,
1171: p_dr_bsv VARCHAR2,
1172: p_cr_bsv VARCHAR2,

Line 1195: From Dual;

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;
1196:
1197: l_api_name CONSTANT VARCHAR2(30) := 'Get_Intracompany_Account';
1198: l_api_version CONSTANT NUMBER := 1.0;
1199: l_return_status VARCHAR2(1);