APPS.AP_AUTOSELECT_PKG dependencies on AP_PAYMENT_TEMPLATES

Line 1464: from AP_PAYMENT_TEMPLATES

1460: party_id,
1461: fnd_global.conc_request_id, --4737467
1462: payment_document_id, --7315136
1463: transfer_priority --7315136
1464: from AP_PAYMENT_TEMPLATES
1465: where template_id = p_template_id;
1466:
1467:
1468: l_debug_info := 'insert into ap_le_group';

Line 1489: ap_payment_templates appt

1485: alg.created_by,
1486: sysdate,
1487: alg.last_updated_by
1488: from ap_le_group alg,
1489: ap_payment_templates appt
1490: where alg.template_id = p_template_id
1491: and alg.template_id = appt.template_id
1492: and appt.le_group_option = 'SPECIFY';
1493:

Line 1516: ap_payment_templates appt

1512: aog.created_by,
1513: sysdate,
1514: aog.last_updated_by
1515: from ap_ou_group aog,
1516: ap_payment_templates appt
1517: where aog.template_id = p_template_id
1518: and aog.template_id = appt.template_id
1519: and appt.ou_group_option = 'SPECIFY';
1520:

Line 1543: ap_payment_templates appt

1539: acg.created_by,
1540: sysdate,
1541: acg.last_updated_by
1542: from AP_CURRENCY_GROUP acg,
1543: ap_payment_templates appt
1544: where acg.template_id = p_template_id
1545: and acg.template_id = appt.template_id
1546: and appt.currency_group_option = 'SPECIFY';--Bug6926344
1547:

Line 1569: ap_payment_templates appt

1565: apg.created_by,
1566: sysdate,
1567: apg.last_updated_by
1568: from AP_PAY_GROUP apg,
1569: ap_payment_templates appt
1570: where apg.template_id = p_template_id
1571: and apg.template_id = appt.template_id
1572: and appt.pay_group_option = 'SPECIFY'; --Bug6926344
1573:

Line 4692: ap_payment_templates apt

4688: iby_payment_methods_vl iby,
4689: fnd_lookups vndr,
4690: hz_parties hz,
4691: ap_lookup_codes rate,
4692: ap_payment_templates apt
4693: where checkrun_id ='|| p_checkrun_id ||'
4694: and apt.template_id(+) = aisc.template_id
4695: and aisc.invoice_batch_id = ab.batch_id(+)
4696: and aisc.payment_method_code = iby.payment_method_code(+)