APPS.AP_AUTOSELECT_PKG dependencies on AP_PAY_GROUP

Line 661: from AP_PAY_GROUP

657: from AP_CURRENCY_GROUP
658: where checkrun_id = p_checkrun_id)
659: or p_currency_group_option = 'ALL')
660: AND (inv.pay_group_lookup_code in (select vendor_pay_group
661: from AP_PAY_GROUP
662: where checkrun_id = p_checkrun_id)
663: or p_pay_group_option = 'ALL')
664: AND ((p_zero_invoices_allowed = 'N' AND ps.amount_remaining <> 0) OR
665: p_zero_invoices_allowed = 'Y')

Line 1548: l_debug_info := 'insert into AP_PAY_GROUP';

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:
1548: l_debug_info := 'insert into AP_PAY_GROUP';
1549: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1550: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1551: END IF;
1552:

Line 1553: insert into AP_PAY_GROUP (

1549: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1550: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1551: END IF;
1552:
1553: insert into AP_PAY_GROUP (
1554: vendor_pay_group,
1555: checkrun_id,
1556: PAY_GROUP_ID,
1557: CREATION_DATE,

Line 1563: AP_PAY_GROUP_S.nextval,

1559: LAST_UPDATE_DATE,
1560: LAST_UPDATED_BY)
1561: select vendor_pay_group,
1562: p_checkrun_id,
1563: AP_PAY_GROUP_S.nextval,
1564: sysdate,
1565: apg.created_by,
1566: sysdate,
1567: apg.last_updated_by

Line 1568: from AP_PAY_GROUP apg,

1564: sysdate,
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

Line 2134: from AP_PAY_GROUP

2130: from AP_CURRENCY_GROUP
2131: where checkrun_id = p_checkrun_id)
2132: or p_curr_group_option = 'ALL')
2133: AND (inv.pay_group_lookup_code in (select vendor_pay_group
2134: from AP_PAY_GROUP
2135: where checkrun_id = p_checkrun_id)
2136: or p_pay_group_option = 'ALL')
2137: AND ((p_zero_inv_allowed = 'N' AND ps.amount_remaining <> 0) OR
2138: p_zero_inv_allowed = 'Y')

Line 2428: from AP_PAY_GROUP

2424: from AP_CURRENCY_GROUP
2425: where checkrun_id = p_checkrun_id)
2426: or p_curr_group_option = 'ALL')
2427: AND (inv.pay_group_lookup_code in (select vendor_pay_group
2428: from AP_PAY_GROUP
2429: where checkrun_id = p_checkrun_id)
2430: or p_pay_group_option = 'ALL')
2431: AND ((p_zero_inv_allowed = 'N' AND ps.amount_remaining <> 0) OR
2432: p_zero_inv_allowed = 'Y')

Line 4715: 'FROM ap_pay_group '||

4711: l_debug_info := 'select pay group';
4712:
4713:
4714: l_qryCtx := DBMS_XMLGEN.newContext('SELECT vendor_pay_group '||
4715: 'FROM ap_pay_group '||
4716: 'WHERE checkrun_id = '||to_char(p_checkrun_id));
4717: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'PAY');
4718: DBMS_XMLGEN.setRowTag(l_qryCtx, 'PAY_GROUP');
4719: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);