APPS.AP_AUTOSELECT_PKG dependencies on AP_OU_GROUP

Line 653: from AP_OU_GROUP

649: from ap_le_group
650: where checkrun_id = p_checkrun_id)
651: or p_le_group_option = 'ALL')
652: AND (inv.org_id in (select org_id
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

Line 1495: l_debug_info := 'insert into AP_OU_GROUP';

1491: and alg.template_id = appt.template_id
1492: and appt.le_group_option = 'SPECIFY';
1493:
1494:
1495: l_debug_info := 'insert into AP_OU_GROUP';
1496: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1497: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1498: END IF;
1499:

Line 1500: insert into AP_OU_GROUP (

1496: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1497: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1498: END IF;
1499:
1500: insert into AP_OU_GROUP (
1501: org_id,
1502: checkrun_id,
1503: OU_GROUP_ID,
1504: CREATION_DATE,

Line 1510: AP_OU_GROUP_S.nextval,

1506: LAST_UPDATE_DATE,
1507: LAST_UPDATED_BY)
1508: select aog.org_id,
1509: p_checkrun_id,
1510: AP_OU_GROUP_S.nextval,
1511: sysdate,
1512: aog.created_by,
1513: sysdate,
1514: aog.last_updated_by

Line 1515: from ap_ou_group aog,

1511: sysdate,
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';

Line 2126: from AP_OU_GROUP

2122: from ap_le_group
2123: where checkrun_id = p_checkrun_id)
2124: or p_le_group_option = 'ALL')
2125: AND (inv.org_id in (select org_id
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

Line 2420: from AP_OU_GROUP

2416: from ap_le_group
2417: where checkrun_id = p_checkrun_id)
2418: or p_le_group_option = 'ALL')
2419: AND (inv.org_id in (select org_id
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

Line 2657: from AP_OU_GROUP

2653: INTO l_encumbrance_flag
2654: FROM financials_system_parameters
2655: WHERE nvl(purch_encumbrance_flag,'N') = 'Y'
2656: AND (org_id in (select org_id
2657: from AP_OU_GROUP
2658: where checkrun_id = l_checkrun_id)
2659: or l_ou_group_option = 'ALL')
2660: AND rownum=1;
2661:

Line 4756: 'FROM AP_OU_GROUP AOG, HR_OPERATING_UNITS HR '||

4752:
4753: l_debug_info := 'select ou group';
4754:
4755: l_qryCtx := DBMS_XMLGEN.newContext('SELECT name organization_name '||
4756: 'FROM AP_OU_GROUP AOG, HR_OPERATING_UNITS HR '||
4757: 'WHERE hr.organization_id = aog.org_id '||
4758: 'AND checkrun_id = '||to_char(p_checkrun_id));
4759: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'ORGANIZATION');
4760: DBMS_XMLGEN.setRowTag(l_qryCtx, 'OU_GROUP');