APPS.FUN_BAL_UTILS_GRP dependencies on DUAL

Line 392: From Dual;

388: AND accts.type = p_acct_type
389: AND accts.default_flag = 'Y'
390: AND (TRUNC(p_gl_date) BETWEEN TRUNC(NVL(accts.start_date, p_gl_date))
391: AND TRUNC(NVL(accts.end_date, p_gl_date)))))))) ccid
392: From Dual;
393:
394: l_api_name CONSTANT VARCHAR2(30) := 'Get_Intercompany_Account';
395: l_api_version CONSTANT NUMBER := 1.0;
396: l_return_status VARCHAR2(1);

Line 854: From Dual;

850: AND Nvl(opts.le_id,-99) = Nvl(p_le_id,-99)
851: AND opts.je_source_name = 'Other'
852: AND opts.je_category_name = 'Other'
853: AND opts.status_flag = 'Y')))) template_id
854: From Dual;
855:
856: CURSOR c_get_ccid (p_template_id NUMBER,
857: p_dr_bsv VARCHAR2,
858: p_cr_bsv VARCHAR2,

Line 881: From Dual;

877: FROM fun_balance_accounts accts
878: WHERE accts.template_id = p_template_id
879: AND accts.dr_bsv = 'OTHER1234567890123456789012345'
880: AND accts.cr_bsv = 'OTHER1234567890123456789012345')))) ccid
881: From Dual;
882:
883: l_api_name CONSTANT VARCHAR2(30) := 'Get_Intracompany_Account';
884: l_api_version CONSTANT NUMBER := 1.0;
885: l_return_status VARCHAR2(1);