eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on IBY_PMT_INSTR_USES_ALL

Line 5867: l_instr_assign_id IBY_PMT_INSTR_USES_ALL.INSTRUMENT_PAYMENT_USE_ID%TYPE;

5863:
5864: /* Bug 9266772*/
5865:
5866: FUNCTION get_PayeeBankAccountAssignment(p_pmt_id Number, p_ext_bank_acct_id NUMBER) RETURN XMLTYPE IS
5867: l_instr_assign_id IBY_PMT_INSTR_USES_ALL.INSTRUMENT_PAYMENT_USE_ID%TYPE;
5868: l_attribute_category IBY_PMT_INSTR_USES_ALL.ATTRIBUTE_CATEGORY%TYPE;
5869: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.get_PayeeBankAccountAssignment';
5870: l_assign_dff XMLTYPE;
5871:

Line 5868: l_attribute_category IBY_PMT_INSTR_USES_ALL.ATTRIBUTE_CATEGORY%TYPE;

5864: /* Bug 9266772*/
5865:
5866: FUNCTION get_PayeeBankAccountAssignment(p_pmt_id Number, p_ext_bank_acct_id NUMBER) RETURN XMLTYPE IS
5867: l_instr_assign_id IBY_PMT_INSTR_USES_ALL.INSTRUMENT_PAYMENT_USE_ID%TYPE;
5868: l_attribute_category IBY_PMT_INSTR_USES_ALL.ATTRIBUTE_CATEGORY%TYPE;
5869: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.get_PayeeBankAccountAssignment';
5870: l_assign_dff XMLTYPE;
5871:
5872: cursor get_Assignments(c_payment_id NUMBER,

Line 5875: FROM iby_pmt_instr_uses_all instr,

5871:
5872: cursor get_Assignments(c_payment_id NUMBER,
5873: c_ext_bank_account_id NUMBER) is
5874: SELECT instr.instrument_payment_use_id, instr.attribute_category
5875: FROM iby_pmt_instr_uses_all instr,
5876: iby_payments_all pmt,
5877: iby_external_payees_all payee
5878: WHERE instr.instrument_id = c_ext_bank_account_id
5879: AND InStr.instrument_type = 'BANKACCOUNT'

Line 5956: XMLELEMENT("DescriptiveFlexField",IBY_EXTRACTGEN_PVT.Get_Dffs('IBY_PMT_INSTR_USES_ALL',l_instr_assign_id, null))))

5952: IF (l_attribute_category is null) then
5953: g_inter_accts_tbl(l_instr_assign_id):=null;
5954: ELSE
5955: SELECT XMLCONCAT(XMLELEMENT("PayeeBankAccountAssignment",
5956: XMLELEMENT("DescriptiveFlexField",IBY_EXTRACTGEN_PVT.Get_Dffs('IBY_PMT_INSTR_USES_ALL',l_instr_assign_id, null))))
5957: into g_inter_accts_tbl(l_instr_assign_id) from dual;
5958: END IF;
5959: ELSE
5960: RETURN g_inter_accts_tbl(l_instr_assign_id);

Line 5970: XMLELEMENT("DescriptiveFlexField",IBY_EXTRACTGEN_PVT.Get_Dffs('IBY_PMT_INSTR_USES_ALL',l_instr_assign_id, null))))

5966: IF (l_attribute_category is null) then
5967: l_assign_dff := null;
5968: ELSE
5969: SELECT XMLCONCAT(XMLELEMENT("PayeeBankAccountAssignment",
5970: XMLELEMENT("DescriptiveFlexField",IBY_EXTRACTGEN_PVT.Get_Dffs('IBY_PMT_INSTR_USES_ALL',l_instr_assign_id, null))))
5971: into l_assign_dff from dual;
5972: END IF;
5973: RETURN l_assign_dff;
5974: END IF;