DBA Data[Home] [Help]

APPS.IBY_EXTRACTGEN_PVT dependencies on FND_CONCURRENT_REQUESTS

Line 871: l_filename fnd_concurrent_requests.outfile_name%TYPE;

867: p_parameters_value OUT NOCOPY JTF_VARCHAR2_TABLE_200
868: ) IS
869:
870: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.get_template_parameters';
871: l_filename fnd_concurrent_requests.outfile_name%TYPE;
872:
873: BEGIN
874:
875: -- initialize output parameters

Line 888: fnd_concurrent_requests fcr,

884: INTO l_filename
885: FROM (SELECT SUBSTR(fcr.outfile_name,INSTR(fcr.outfile_name,'/',-1)+1) filename,
886: rank() over(partition by pi.payment_instruction_id order by pcc.request_id desc) c_rank
887: FROM iby_process_conc_requests pcc,
888: fnd_concurrent_requests fcr,
889: iby_pay_instructions_all pi,
890: iby_acct_pmt_profiles_b ap,
891: iby_sys_pmt_profiles_b sp,
892: iby_formats_b f