APPS.IBY_FD_POST_PICP_PROGS_PVT dependencies on IBY_PAYMENT_PROFILES

Line 222: iby_payment_profiles pp

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

Line 297: iby_payment_profiles pp

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:
301: IF l_save_no_output = 'Y' THEN

Line 353: iby_payment_profiles pp,

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

1865: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Reset_Periodic_Sequence_Value';
1866:
1867: CURSOR l_val_seq_csr IS
1868: SELECT payment_profile_name
1869: FROM iby_payment_profiles
1870: WHERE payment_profile_id = p_payment_profile_id;
1871:
1872: BEGIN
1873:

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