DBA Data[Home] [Help]

APPS.IBY_EXTRACTGEN_PVT dependencies on IBY_PAY_INSTRUCTIONS_ALL

Line 608: FROM IBY_PAY_INSTRUCTIONS_ALL

604: l_from_clause := ' From ' || p_entity_table;
605: l_where_clause := ' Where payment_instruction_id = :p_entity_id ';
606: SELECT attribute_category
607: INTO l_attribute_category
608: FROM IBY_PAY_INSTRUCTIONS_ALL
609: WHERE payment_instruction_id = p_entity_id;
610:
611: ELSIF p_entity_table = G_DFF_FD_PAY_SERVICE_REQ THEN
612: l_num_of_attributes := 15;

Line 889: iby_pay_instructions_all pi,

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