DBA Data[Home] [Help]

APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on DUAL

Line 1658: FROM dual;

1654: XMLElement("EmailAddress", l_email),
1655: XMLElement("Website", l_url)
1656: )
1657: INTO g_payer_contact_tbl(p_party_id).l_contactinfo
1658: FROM dual;
1659: END IF;
1660: ELSE
1661: RETURN null;
1662: END IF;

Line 1807: FROM dual;

1803: XMLElement("EmailAddress", l_email),
1804: XMLElement("Website", l_url)
1805: )
1806: INTO l_contactinfo
1807: FROM dual;
1808: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1809: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
1810: debug_level => G_LEVEL_PROCEDURE,
1811: module => l_Debug_Module);

Line 2075: -- for payment format: reprint individual and ranges

2071: AND ((xml_pmt_lvl.payment_status in ('INSTRUCTION_CREATED',
2072: 'VOID_BY_SETUP', 'VOID_BY_OVERFLOW') AND ins.process_type = 'STANDARD') OR
2073: ins.process_type = 'IMMEDIATE');
2074:
2075: -- for payment format: reprint individual and ranges
2076: CURSOR l_payerinstr_reprt_csr (p_payment_instruction_id IN NUMBER) IS
2077: SELECT XMLAgg(xml_pmt_lvl.payment)
2078: FROM
2079: iby_xml_fd_pmt_1_0_v xml_pmt_lvl,