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 221: FROM iby_pay_instructions_all ins,

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

Line 296: FROM iby_pay_instructions_all ins,

292: debug_level => FND_LOG.LEVEL_STATEMENT,
293: module => l_Debug_Module);
294:
295: SELECT nvl(pp.disallow_save_print_flag,'N') into l_save_no_output
296: FROM iby_pay_instructions_all ins,
297: iby_payment_profiles pp
298: WHERE ins.payment_instruction_id = p_payment_instruction_id
299: AND ins.payment_profile_id = pp.payment_profile_id;
300:

Line 352: FROM iby_pay_instructions_all ins,

348: l_template_code,
349: l_template_lang,
350: l_template_terr,
351: l_output_format
352: FROM iby_pay_instructions_all ins,
353: iby_payment_profiles pp,
354: iby_formats_b format,
355: XDO_TEMPLATES_B temp
356: WHERE ins.payment_instruction_id = p_payment_instruction_id

Line 503: FROM iby_pay_instructions_all ins, iby_payment_profiles pp

499: CURSOR l_instruction_ovn_csr (p_payment_instruction_id IN NUMBER) IS
500: SELECT ins.object_version_number, ins.payment_instruction_status,
501: pp.processing_type, pp.mark_complete_event, pp.payment_format_code,
502: pp.print_instruction_immed_flag, ins.process_type
503: FROM iby_pay_instructions_all ins, iby_payment_profiles pp
504: WHERE ins.payment_profile_id = pp.payment_profile_id
505: AND payment_instruction_id = p_payment_instruction_id;
506:
507: CURSOR l_pmt_csr (p_payment_instruction_id IN NUMBER) IS

Line 561: iby_pay_instructions_all

557: RETURN;
558: END IF;
559:
560: UPDATE
561: iby_pay_instructions_all
562: SET
563: payment_instruction_status = p_newStatus,
564: object_version_number = l_instruction_ovn + 1,
565: last_updated_by = fnd_global.user_id,

Line 1111: iby_pay_instructions_all ins

1107:
1108: CURSOR l_doc_csr (p_payment_instruction_id IN NUMBER) IS
1109: SELECT document_payable_id
1110: FROM iby_docs_payable_all doc, iby_payments_all pmt,
1111: iby_pay_instructions_all ins
1112: WHERE ins.payment_instruction_id = p_payment_instruction_id
1113: AND ins.payment_instruction_id = pmt.payment_instruction_id
1114: AND doc.straight_through_flag = 'Y'
1115: AND pmt.payment_id = doc.payment_id;

Line 1179: FROM iby_payment_profiles pp, iby_pay_instructions_all ins

1175: pp.periodic_sequence_name_3,
1176: pp.last_used_number_1,
1177: pp.last_used_number_2,
1178: pp.last_used_number_3
1179: FROM iby_payment_profiles pp, iby_pay_instructions_all ins
1180: WHERE ins.payment_instruction_id = p_payment_instruction_id
1181: AND ins.payment_profile_id = pp.payment_profile_id;
1182:
1183: BEGIN

Line 1360: FROM iby_pay_instructions_all

1356: l_instruction_ovn NUMBER;
1357:
1358: CURSOR l_instruction_ovn_csr (p_payment_instruction_id IN NUMBER) IS
1359: SELECT object_version_number
1360: FROM iby_pay_instructions_all
1361: WHERE payment_instruction_id = p_payment_instruction_id;
1362:
1363: BEGIN
1364:

Line 1370: iby_pay_instructions_all

1366: FETCH l_instruction_ovn_csr INTO l_instruction_ovn;
1367: CLOSE l_instruction_ovn_csr;
1368:
1369: UPDATE
1370: iby_pay_instructions_all
1371: SET
1372: remittance_advice_created_flag = 'Y',
1373: object_version_number = l_instruction_ovn + 1,
1374: last_updated_by = fnd_global.user_id,

Line 1392: FROM iby_pay_instructions_all

1388: l_instruction_ovn NUMBER;
1389:
1390: CURSOR l_instruction_ovn_csr (p_payment_instruction_id IN NUMBER) IS
1391: SELECT object_version_number
1392: FROM iby_pay_instructions_all
1393: WHERE payment_instruction_id = p_payment_instruction_id;
1394:
1395: BEGIN
1396:

Line 1402: iby_pay_instructions_all

1398: FETCH l_instruction_ovn_csr INTO l_instruction_ovn;
1399: CLOSE l_instruction_ovn_csr;
1400:
1401: UPDATE
1402: iby_pay_instructions_all
1403: SET
1404: positive_pay_file_created_flag = 'Y',
1405: object_version_number = l_instruction_ovn + 1,
1406: last_updated_by = fnd_global.user_id,

Line 1424: FROM iby_pay_instructions_all

1420: l_instruction_ovn NUMBER;
1421:
1422: CURSOR l_instruction_ovn_csr (p_payment_instruction_id IN NUMBER) IS
1423: SELECT object_version_number
1424: FROM iby_pay_instructions_all
1425: WHERE payment_instruction_id = p_payment_instruction_id;
1426:
1427: BEGIN
1428:

Line 1434: iby_pay_instructions_all

1430: FETCH l_instruction_ovn_csr INTO l_instruction_ovn;
1431: CLOSE l_instruction_ovn_csr;
1432:
1433: UPDATE
1434: iby_pay_instructions_all
1435: SET
1436: regulatory_report_created_flag = 'Y',
1437: object_version_number = l_instruction_ovn + 1,
1438: last_updated_by = fnd_global.user_id,

Line 1486: FROM iby_pay_instructions_all ins, iby_payment_profiles pp,

1482: l_reg_rpt_format_code varchar2(30);
1483:
1484: CURSOR l_sra_format_csr (p_payment_instruction_id IN NUMBER) IS
1485: SELECT sra.remittance_advice_format_code
1486: FROM iby_pay_instructions_all ins, iby_payment_profiles pp,
1487: iby_remit_advice_setup sra
1488: WHERE payment_instruction_id = p_payment_instruction_id
1489: AND ins.payment_profile_id = pp.payment_profile_id
1490: AND pp.system_profile_code = sra.system_profile_code;

Line 1496: FROM iby_pay_instructions_all ins, iby_payment_profiles pp

1492: CURSOR l_aux_format_csr (p_payment_instruction_id IN NUMBER) IS
1493: SELECT pp.pay_file_letter_format_code,
1494: pp.positive_pay_format_code,
1495: pp.declaration_report_name
1496: FROM iby_pay_instructions_all ins, iby_payment_profiles pp
1497: WHERE payment_instruction_id = p_payment_instruction_id
1498: AND ins.payment_profile_id = pp.payment_profile_id;
1499:
1500: BEGIN

Line 1539: FROM iby_pay_instructions_all ins, iby_payment_profiles pp,

1535: l_allow_multiple_sra_flag varchar2(1);
1536:
1537: CURSOR l_multi_sra_flag_csr (p_payment_instruction_id IN NUMBER) IS
1538: SELECT sra.allow_multiple_copy_flag
1539: FROM iby_pay_instructions_all ins, iby_payment_profiles pp,
1540: iby_remit_advice_setup sra
1541: WHERE payment_instruction_id = p_payment_instruction_id
1542: AND ins.payment_profile_id = pp.payment_profile_id
1543: AND pp.system_profile_code = sra.system_profile_code;

Line 1621: FROM iby_pay_instructions_all ins, iby_process_orgs po

1617:
1618: -- all orgs belonging to the instruction
1619: CURSOR l_ins_org_csr (p_payment_instruction_id IN NUMBER) IS
1620: SELECT po.org_type, po.org_id
1621: FROM iby_pay_instructions_all ins, iby_process_orgs po
1622: WHERE ins.payment_instruction_id = p_payment_instruction_id
1623: AND ins.payment_instruction_id = po.object_id
1624: AND po.object_type = 'PAYMENT_INSTRUCTION';
1625:

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

1675: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.val_pmt_reg_instr_accessible';
1676:
1677: CURSOR l_accessible_orgs_csr (p_payment_instruction_id IN NUMBER) IS
1678: SELECT count(po.org_id)
1679: FROM iby_pay_instructions_all ins, iby_process_orgs po, ce_security_profiles_v ce_sp
1680: WHERE ins.payment_instruction_id = p_payment_instruction_id
1681: AND ins.payment_instruction_id = po.object_id
1682: AND po.object_type = 'PAYMENT_INSTRUCTION'
1683: AND ce_sp.organization_type = po.org_type

Line 2079: FROM iby_payment_profiles pp, iby_pay_instructions_all ins

2075: l_return_status boolean; -- Bug 6411356
2076:
2077: CURSOR l_acp_ltr_fmt_csr IS
2078: SELECT pay_file_letter_format_code
2079: FROM iby_payment_profiles pp, iby_pay_instructions_all ins
2080: WHERE ins.payment_instruction_id = p_payment_instruction_id
2081: AND ins.payment_profile_id = pp.payment_profile_id;
2082:
2083: BEGIN