DBA Data[Home] [Help]

APPS.IBY_EXTRACTGEN_PVT dependencies on IBY_PAY_INSTRUCTIONS_ALL

Line 470: FROM IBY_PAY_INSTRUCTIONS_ALL

466: l_from_clause := ' From ' || p_entity_table;
467: l_where_clause := ' Where payment_instruction_id = :p_entity_id ';
468: SELECT attribute_category
469: INTO l_attribute_category
470: FROM IBY_PAY_INSTRUCTIONS_ALL
471: WHERE payment_instruction_id = p_entity_id;
472:
473: ELSIF p_entity_table = G_DFF_FD_PAYMENT THEN
474: l_num_of_attributes := 15;

Line 710: iby_pay_instructions_all pi,

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
714: WHERE pcc.object_type = 'PAYMENT_INSTRUCTION'