APPS.AP_AUTOSELECT_PKG dependencies on AP_LE_GROUP

Line 649: from ap_le_group

645: AND ps.payment_method_code = nvl(p_payment_method, ps.payment_method_code)
646: AND nvl(suppliers.vendor_type_lookup_code,-99) =
647: nvl(p_supplier_type, nvl(suppliers.vendor_type_lookup_code,-99))
648: AND (inv.legal_entity_id in (select legal_entity_id
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

Line 1468: l_debug_info := 'insert into ap_le_group';

1464: from AP_PAYMENT_TEMPLATES
1465: where template_id = p_template_id;
1466:
1467:
1468: l_debug_info := 'insert into ap_le_group';
1469: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1470: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1471: END IF;
1472:

Line 1473: insert into ap_le_group (

1469: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1470: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1471: END IF;
1472:
1473: insert into ap_le_group (
1474: legal_entity_id,
1475: checkrun_id,
1476: LE_GROUP_ID,
1477: CREATION_DATE,

Line 1483: AP_LE_GROUP_S.nextval,

1479: LAST_UPDATE_DATE,
1480: LAST_UPDATED_BY)
1481: select legal_entity_id,
1482: p_checkrun_id,
1483: AP_LE_GROUP_S.nextval,
1484: sysdate,
1485: alg.created_by,
1486: sysdate,
1487: alg.last_updated_by

Line 1488: from ap_le_group alg,

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

Line 2122: from ap_le_group

2118: AND ps.payment_method_code = nvl(p_payment_method, ps.payment_method_code)
2119: AND nvl(suppliers.vendor_type_lookup_code,-99) =
2120: nvl(p_supplier_type, nvl(suppliers.vendor_type_lookup_code,-99))
2121: AND (inv.legal_entity_id in (select legal_entity_id
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

Line 2416: from ap_le_group

2412: AND ps.payment_method_code = nvl(p_payment_method, ps.payment_method_code)
2413: AND nvl(suppliers.vendor_type_lookup_code,-99) =
2414: nvl(p_supplier_type, nvl(suppliers.vendor_type_lookup_code,-99))
2415: AND (inv.legal_entity_id in (select legal_entity_id
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

Line 4742: 'FROM ap_le_group aleg, xle_entity_profiles xle '||

4738:
4739: l_debug_info:= 'select le group';
4740:
4741: l_qryCtx := DBMS_XMLGEN.newContext('SELECT name legal_entity_name '||
4742: 'FROM ap_le_group aleg, xle_entity_profiles xle '||
4743: 'WHERE aleg.legal_entity_id = xle.legal_entity_id '||
4744: 'AND checkrun_id = '||to_char(p_checkrun_id));
4745: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'LEGAL_ENTITY');
4746: DBMS_XMLGEN.setRowTag(l_qryCtx, 'LE_GROUP');