APPS.AP_AUTOSELECT_PKG dependencies on AP_CURRENCY_GROUP

Line 657: from AP_CURRENCY_GROUP

653: from AP_OU_GROUP
654: where checkrun_id = p_checkrun_id)
655: or p_ou_group_option = 'ALL')
656: AND (inv.payment_currency_code in (select currency_code
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

Line 1521: l_debug_info := 'insert into AP_CURRENCY_GROUP';

1517: where aog.template_id = p_template_id
1518: and aog.template_id = appt.template_id
1519: and appt.ou_group_option = 'SPECIFY';
1520:
1521: l_debug_info := 'insert into AP_CURRENCY_GROUP';
1522: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1523: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1524: END IF;
1525:

Line 1527: insert into AP_CURRENCY_GROUP (

1523: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1524: END IF;
1525:
1526:
1527: insert into AP_CURRENCY_GROUP (
1528: currency_code,
1529: checkrun_id,
1530: CURRENCY_GROUP_ID,
1531: CREATION_DATE,

Line 1537: AP_CURRENCY_GROUP_S.nextval,

1533: LAST_UPDATE_DATE,
1534: LAST_UPDATED_BY)
1535: select currency_code,
1536: p_checkrun_id,
1537: AP_CURRENCY_GROUP_S.nextval,
1538: sysdate,
1539: acg.created_by,
1540: sysdate,
1541: acg.last_updated_by

Line 1542: from AP_CURRENCY_GROUP acg,

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

Line 2130: from AP_CURRENCY_GROUP

2126: from AP_OU_GROUP
2127: where checkrun_id = p_checkrun_id)
2128: or p_ou_group_option = 'ALL')
2129: AND (inv.payment_currency_code in (select currency_code
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

Line 2424: from AP_CURRENCY_GROUP

2420: from AP_OU_GROUP
2421: where checkrun_id = p_checkrun_id)
2422: or p_ou_group_option = 'ALL')
2423: AND (inv.payment_currency_code in (select currency_code
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

Line 4728: 'FROM AP_CURRENCY_GROUP '||

4724:
4725: l_debug_info := 'select currency group';
4726:
4727: l_qryCtx := DBMS_XMLGEN.newContext('SELECT currency_code '||
4728: 'FROM AP_CURRENCY_GROUP '||
4729: 'WHERE checkrun_id = '||to_char(p_checkrun_id));
4730: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'CURRENCY');
4731: DBMS_XMLGEN.setRowTag(l_qryCtx, 'CURRENCY_GROUP');
4732: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);