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_POST_PICP_PROGS_PVT dependencies on IBY_PAY_INSTRUCTIONS_ALL

Line 224: FROM iby_pay_instructions_all ins,

220: CURSOR l_ins_csr (p_payment_instruction_id IN NUMBER) IS
221: SELECT ins.PRINTER_NAME, ins.payment_instruction_status,
222: ins.TRANSMIT_INSTR_IMMED_FLAG,
223: ins.PRINT_INSTRUCTION_IMMED_FLAG, pp.processing_type, mark_complete_event
224: FROM iby_pay_instructions_all ins,
225: iby_payment_profiles pp
226: WHERE ins.payment_instruction_id = p_payment_instruction_id
227: AND ins.payment_profile_id = pp.payment_profile_id;
228:

Line 328: FROM iby_pay_instructions_all ins,

324: debug_level => FND_LOG.LEVEL_STATEMENT,
325: module => l_Debug_Module);
326:
327: SELECT nvl(pp.disallow_save_print_flag,'N') into l_save_no_output
328: FROM iby_pay_instructions_all ins,
329: iby_payment_profiles pp
330: WHERE ins.payment_instruction_id = p_payment_instruction_id
331: AND ins.payment_profile_id = pp.payment_profile_id;
332:

Line 390: FROM iby_pay_instructions_all ins,

386: l_template_code,
387: l_template_lang,
388: l_template_terr,
389: l_output_format
390: FROM iby_pay_instructions_all ins,
391: iby_payment_profiles pp,
392: iby_formats_b format,
393: XDO_TEMPLATES_B temp
394: WHERE ins.payment_instruction_id = p_payment_instruction_id

Line 543: FROM iby_pay_instructions_all ins, iby_payment_profiles pp

539: CURSOR l_instruction_ovn_csr (p_payment_instruction_id IN NUMBER) IS
540: SELECT ins.object_version_number, ins.payment_instruction_status,
541: pp.processing_type, pp.mark_complete_event, pp.payment_format_code,
542: pp.print_instruction_immed_flag, ins.process_type
543: FROM iby_pay_instructions_all ins, iby_payment_profiles pp
544: WHERE ins.payment_profile_id = pp.payment_profile_id
545: AND payment_instruction_id = p_payment_instruction_id;
546:
547: -- CURSOR l_pmt_csr (p_payment_instruction_id IN NUMBER) IS

Line 603: iby_pay_instructions_all

599: RETURN;
600: END IF;
601:
602: UPDATE
603: iby_pay_instructions_all
604: SET
605: payment_instruction_status = p_newStatus,
606: object_version_number = l_instruction_ovn + 1,
607: last_updated_by = fnd_global.user_id,

Line 1320: iby_pay_instructions_all ins

1316:
1317: CURSOR l_doc_csr (p_payment_instruction_id IN NUMBER) IS
1318: SELECT document_payable_id
1319: FROM iby_docs_payable_all doc, iby_payments_all pmt,
1320: iby_pay_instructions_all ins
1321: WHERE ins.payment_instruction_id = p_payment_instruction_id
1322: AND ins.payment_instruction_id = pmt.payment_instruction_id
1323: AND doc.straight_through_flag = 'Y'
1324: AND pmt.payment_id = doc.payment_id;

Line 1388: FROM iby_payment_profiles pp, iby_pay_instructions_all ins

1384: pp.periodic_sequence_name_3,
1385: pp.last_used_number_1,
1386: pp.last_used_number_2,
1387: pp.last_used_number_3
1388: FROM iby_payment_profiles pp, iby_pay_instructions_all ins
1389: WHERE ins.payment_instruction_id = p_payment_instruction_id
1390: AND ins.payment_profile_id = pp.payment_profile_id;
1391:
1392: BEGIN

Line 1569: FROM iby_pay_instructions_all

1565: l_instruction_ovn NUMBER;
1566:
1567: CURSOR l_instruction_ovn_csr (p_payment_instruction_id IN NUMBER) IS
1568: SELECT object_version_number
1569: FROM iby_pay_instructions_all
1570: WHERE payment_instruction_id = p_payment_instruction_id;
1571:
1572: BEGIN
1573:

Line 1579: iby_pay_instructions_all

1575: FETCH l_instruction_ovn_csr INTO l_instruction_ovn;
1576: CLOSE l_instruction_ovn_csr;
1577:
1578: UPDATE
1579: iby_pay_instructions_all
1580: SET
1581: remittance_advice_created_flag = 'Y',
1582: object_version_number = l_instruction_ovn + 1,
1583: last_updated_by = fnd_global.user_id,

Line 1601: FROM iby_pay_instructions_all

1597: l_instruction_ovn NUMBER;
1598:
1599: CURSOR l_instruction_ovn_csr (p_payment_instruction_id IN NUMBER) IS
1600: SELECT object_version_number
1601: FROM iby_pay_instructions_all
1602: WHERE payment_instruction_id = p_payment_instruction_id;
1603:
1604: BEGIN
1605:

Line 1611: iby_pay_instructions_all

1607: FETCH l_instruction_ovn_csr INTO l_instruction_ovn;
1608: CLOSE l_instruction_ovn_csr;
1609:
1610: UPDATE
1611: iby_pay_instructions_all
1612: SET
1613: positive_pay_file_created_flag = 'Y',
1614: object_version_number = l_instruction_ovn + 1,
1615: last_updated_by = fnd_global.user_id,

Line 1633: FROM iby_pay_instructions_all

1629: l_instruction_ovn NUMBER;
1630:
1631: CURSOR l_instruction_ovn_csr (p_payment_instruction_id IN NUMBER) IS
1632: SELECT object_version_number
1633: FROM iby_pay_instructions_all
1634: WHERE payment_instruction_id = p_payment_instruction_id;
1635:
1636: BEGIN
1637:

Line 1643: iby_pay_instructions_all

1639: FETCH l_instruction_ovn_csr INTO l_instruction_ovn;
1640: CLOSE l_instruction_ovn_csr;
1641:
1642: UPDATE
1643: iby_pay_instructions_all
1644: SET
1645: regulatory_report_created_flag = 'Y',
1646: object_version_number = l_instruction_ovn + 1,
1647: last_updated_by = fnd_global.user_id,

Line 1695: FROM iby_pay_instructions_all ins, iby_payment_profiles pp,

1691: l_reg_rpt_format_code varchar2(30);
1692:
1693: CURSOR l_sra_format_csr (p_payment_instruction_id IN NUMBER) IS
1694: SELECT sra.remittance_advice_format_code
1695: FROM iby_pay_instructions_all ins, iby_payment_profiles pp,
1696: iby_remit_advice_setup sra
1697: WHERE payment_instruction_id = p_payment_instruction_id
1698: AND ins.payment_profile_id = pp.payment_profile_id
1699: AND pp.system_profile_code = sra.system_profile_code;

Line 1705: FROM iby_pay_instructions_all ins, iby_payment_profiles pp

1701: CURSOR l_aux_format_csr (p_payment_instruction_id IN NUMBER) IS
1702: SELECT pp.pay_file_letter_format_code,
1703: pp.positive_pay_format_code,
1704: pp.declaration_report_name
1705: FROM iby_pay_instructions_all ins, iby_payment_profiles pp
1706: WHERE payment_instruction_id = p_payment_instruction_id
1707: AND ins.payment_profile_id = pp.payment_profile_id;
1708:
1709: BEGIN

Line 1748: FROM iby_pay_instructions_all ins, iby_payment_profiles pp,

1744: l_allow_multiple_sra_flag varchar2(1);
1745:
1746: CURSOR l_multi_sra_flag_csr (p_payment_instruction_id IN NUMBER) IS
1747: SELECT sra.allow_multiple_copy_flag
1748: FROM iby_pay_instructions_all ins, iby_payment_profiles pp,
1749: iby_remit_advice_setup sra
1750: WHERE payment_instruction_id = p_payment_instruction_id
1751: AND ins.payment_profile_id = pp.payment_profile_id
1752: AND pp.system_profile_code = sra.system_profile_code;

Line 1830: FROM iby_pay_instructions_all ins, iby_process_orgs po

1826:
1827: -- all orgs belonging to the instruction
1828: CURSOR l_ins_org_csr (p_payment_instruction_id IN NUMBER) IS
1829: SELECT po.org_type, po.org_id
1830: FROM iby_pay_instructions_all ins, iby_process_orgs po
1831: WHERE ins.payment_instruction_id = p_payment_instruction_id
1832: AND ins.payment_instruction_id = po.object_id
1833: AND po.object_type = 'PAYMENT_INSTRUCTION';
1834:

Line 1888: FROM iby_pay_instructions_all ins, iby_process_orgs po, ce_security_profiles_v ce_sp

1884: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.val_pmt_reg_instr_accessible';
1885:
1886: CURSOR l_accessible_orgs_csr (p_payment_instruction_id IN NUMBER) IS
1887: SELECT count(po.org_id)
1888: FROM iby_pay_instructions_all ins, iby_process_orgs po, ce_security_profiles_v ce_sp
1889: WHERE ins.payment_instruction_id = p_payment_instruction_id
1890: AND ins.payment_instruction_id = po.object_id
1891: AND po.object_type = 'PAYMENT_INSTRUCTION'
1892: AND ce_sp.organization_type = po.org_type

Line 2288: FROM iby_payment_profiles pp, iby_pay_instructions_all ins

2284: l_return_status boolean; -- Bug 6411356
2285:
2286: CURSOR l_acp_ltr_fmt_csr IS
2287: SELECT pay_file_letter_format_code
2288: FROM iby_payment_profiles pp, iby_pay_instructions_all ins
2289: WHERE ins.payment_instruction_id = p_payment_instruction_id
2290: AND ins.payment_profile_id = pp.payment_profile_id;
2291:
2292: BEGIN

Line 2539: FROM iby_pay_instructions_all ins, iby_payment_profiles pp

2535: l_msg_data VARCHAR2(2000);
2536:
2537: CURSOR l_instruction_ovn_csr (p_payment_instruction_id IN NUMBER) IS
2538: SELECT pp.payment_format_code
2539: FROM iby_pay_instructions_all ins, iby_payment_profiles pp
2540: WHERE ins.payment_profile_id = pp.payment_profile_id
2541: AND payment_instruction_id = p_payment_instruction_id;
2542:
2543: BEGIN