APPS.IBY_FD_POST_PICP_PROGS_PVT dependencies on IBY_PAYMENT_PROFILES

Line 225: iby_payment_profiles pp

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:
229: BEGIN

Line 329: iby_payment_profiles pp

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:
333: IF l_printer_name = 'noprint' THEN

Line 391: iby_payment_profiles pp,

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
395: AND ins.payment_profile_id = pp.payment_profile_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 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 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 2078: FROM iby_payment_profiles

2074: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Reset_Periodic_Sequence_Value';
2075:
2076: CURSOR l_val_seq_csr IS
2077: SELECT payment_profile_name
2078: FROM iby_payment_profiles
2079: WHERE payment_profile_id = p_payment_profile_id;
2080:
2081: BEGIN
2082:

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