APPS.AP_AUTOSELECT_PKG dependencies on AP_PAYMENT_TEMPLATES

Line 2098: from AP_PAYMENT_TEMPLATES

2094: ,ATTRIBUTE12
2095: ,ATTRIBUTE13
2096: ,ATTRIBUTE14
2097: ,ATTRIBUTE15 -- end 8885918
2098: from AP_PAYMENT_TEMPLATES
2099: where template_id = p_template_id;
2100:
2101:
2102: l_debug_info := 'insert into ap_le_group';

Line 2123: ap_payment_templates appt

2119: alg.created_by,
2120: sysdate,
2121: alg.last_updated_by
2122: from ap_le_group alg,
2123: ap_payment_templates appt
2124: where alg.template_id = p_template_id
2125: and alg.template_id = appt.template_id
2126: and appt.le_group_option = 'SPECIFY';
2127:

Line 2150: ap_payment_templates appt

2146: aog.created_by,
2147: sysdate,
2148: aog.last_updated_by
2149: from ap_ou_group aog,
2150: ap_payment_templates appt
2151: where aog.template_id = p_template_id
2152: and aog.template_id = appt.template_id
2153: and appt.ou_group_option = 'SPECIFY';
2154:

Line 2177: ap_payment_templates appt

2173: acg.created_by,
2174: sysdate,
2175: acg.last_updated_by
2176: from AP_CURRENCY_GROUP acg,
2177: ap_payment_templates appt
2178: where acg.template_id = p_template_id
2179: and acg.template_id = appt.template_id
2180: and appt.currency_group_option = 'SPECIFY';--Bug6926344
2181:

Line 2203: ap_payment_templates appt

2199: apg.created_by,
2200: sysdate,
2201: apg.last_updated_by
2202: from AP_PAY_GROUP apg,
2203: ap_payment_templates appt
2204: where apg.template_id = p_template_id
2205: and apg.template_id = appt.template_id
2206: and appt.pay_group_option = 'SPECIFY'; --Bug6926344
2207:

Line 6292: ap_payment_templates apt

6288: iby_payment_methods_vl iby,
6289: fnd_lookups vndr,
6290: hz_parties hz,
6291: ap_lookup_codes rate,
6292: ap_payment_templates apt
6293: where checkrun_id ='|| p_checkrun_id ||'
6294: and apt.template_id(+) = aisc.template_id
6295: and aisc.invoice_batch_id = ab.batch_id(+)
6296: and aisc.payment_method_code = iby.payment_method_code(+)