DBA Data[Home] [Help]

APPS.IBY_EXTRACTGEN_PVT dependencies on FND_CONCURRENT_REQUESTS

Line 692: l_filename fnd_concurrent_requests.outfile_name%TYPE;

688: p_parameters_value OUT NOCOPY JTF_VARCHAR2_TABLE_200
689: ) IS
690:
691: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.get_template_parameters';
692: l_filename fnd_concurrent_requests.outfile_name%TYPE;
693:
694: BEGIN
695:
696: -- initialize output parameters

Line 709: fnd_concurrent_requests fcr,

705: INTO l_filename
706: FROM (SELECT SUBSTR(fcr.outfile_name,INSTR(fcr.outfile_name,'/',-1)+1) filename,
707: rank() over(partition by pi.payment_instruction_id order by pcc.request_id desc) c_rank
708: FROM iby_process_conc_requests pcc,
709: fnd_concurrent_requests fcr,
710: iby_pay_instructions_all pi,
711: iby_acct_pmt_profiles_b ap,
712: iby_sys_pmt_profiles_b sp,
713: iby_formats_b f