APPS.AP_AUTOSELECT_PKG dependencies on AP_LE_GROUP

Line 939: ' from ap_le_group '||

935: /* ' AND ps.payment_method_code = nvl(:p_payment_method, ps.payment_method_code) '||
936: ' AND nvl(suppliers.vendor_type_lookup_code,-99) = '||
937: ' nvl(:p_supplier_type, nvl(suppliers.vendor_type_lookup_code,-99)) '||
938: ' AND (ai.legal_entity_id in (select /*+ push_subq * / legal_entity_id '||
939: ' from ap_le_group '||
940: ' where checkrun_id = :p_checkrun_id) '||
941: ' or :p_le_group_option = ''ALL'') '||
942: ' AND (ai.org_id in (select /*+ push_subq * / org_id '||
943: ' from AP_OU_GROUP '||

Line 992: ' from ap_le_group '||

988: IF p_le_group_option <> 'ALL' THEN
989: l_sql_stmt := l_sql_stmt||
990: ' AND ai.legal_entity_id in '||
991: ' (select /*+ push_subq */ legal_entity_id '||
992: ' from ap_le_group '||
993: ' where checkrun_id BETWEEN :p_checkrun_id AND :p_checkrun_id) ';
994: ELSE
995: l_sql_stmt := l_sql_stmt||
996: ' AND :p_checkrun_id = :p_checkrun_id ';

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

2098: from AP_PAYMENT_TEMPLATES
2099: where template_id = p_template_id;
2100:
2101:
2102: l_debug_info := 'insert into ap_le_group';
2103: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2104: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
2105: END IF;
2106:

Line 2107: insert into ap_le_group (

2103: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2104: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
2105: END IF;
2106:
2107: insert into ap_le_group (
2108: legal_entity_id,
2109: checkrun_id,
2110: LE_GROUP_ID,
2111: CREATION_DATE,

Line 2117: AP_LE_GROUP_S.nextval,

2113: LAST_UPDATE_DATE,
2114: LAST_UPDATED_BY)
2115: select legal_entity_id,
2116: p_checkrun_id,
2117: AP_LE_GROUP_S.nextval,
2118: sysdate,
2119: alg.created_by,
2120: sysdate,
2121: alg.last_updated_by

Line 2122: from ap_le_group alg,

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

Line 3065: ' from ap_le_group '||

3061: /*' AND ps.payment_method_code = nvl(:p_payment_method, ps.payment_method_code) '||
3062: ' AND nvl(suppliers.vendor_type_lookup_code,-99) = '||
3063: ' nvl(:p_supplier_type, nvl(suppliers.vendor_type_lookup_code,-99)) '||
3064: ' AND (ai.legal_entity_id in (select /*+ push_subq * / legal_entity_id '||
3065: ' from ap_le_group '||
3066: ' where checkrun_id = :p_checkrun_id) '||
3067: ' or :p_le_group_option = ''ALL'') '||
3068: ' AND (ai.org_id in (select /*+ push_subq * / org_id '||
3069: ' from AP_OU_GROUP '||

Line 3118: ' from ap_le_group '||

3114: IF l_le_group_option <> 'ALL' THEN
3115: l_sql_stmt := l_sql_stmt||
3116: ' AND ai.legal_entity_id in '||
3117: ' (select /*+ push_subq */ legal_entity_id '||
3118: ' from ap_le_group '||
3119: ' where checkrun_id BETWEEN :p_checkrun_id AND :p_checkrun_id) ';
3120: ELSE
3121: l_sql_stmt := l_sql_stmt||
3122: ' AND :p_checkrun_id = :p_checkrun_id ';

Line 3890: ' from ap_le_group '||

3886: /* ' AND ps.payment_method_code = nvl(:p_payment_method, ps.payment_method_code) '||
3887: ' AND nvl(suppliers.vendor_type_lookup_code,-99) = '||
3888: ' nvl(:p_supplier_type, nvl(suppliers.vendor_type_lookup_code,-99)) '||
3889: ' AND (ai.legal_entity_id in (select /*+ push_subq * / legal_entity_id '||
3890: ' from ap_le_group '||
3891: ' where checkrun_id = :p_checkrun_id) '||
3892: ' or :p_le_group_option = ''ALL'') '||
3893: ' AND (ai.org_id in (select /*+ push_subq * / org_id '||
3894: ' from AP_OU_GROUP '||

Line 3943: ' from ap_le_group '||

3939: IF l_le_group_option <> 'ALL' THEN
3940: l_sql_stmt := l_sql_stmt||
3941: ' AND ai.legal_entity_id in '||
3942: ' (select /*+ push_subq */ legal_entity_id '||
3943: ' from ap_le_group '||
3944: ' where checkrun_id BETWEEN :p_checkrun_id AND :p_checkrun_id) ';
3945: ELSE
3946: l_sql_stmt := l_sql_stmt||
3947: ' AND :p_checkrun_id = :p_checkrun_id ';

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

6338:
6339: l_debug_info:= 'select le group';
6340:
6341: l_qryCtx := DBMS_XMLGEN.newContext('SELECT name legal_entity_name '||
6342: 'FROM ap_le_group aleg, xle_entity_profiles xle '||
6343: 'WHERE aleg.legal_entity_id = xle.legal_entity_id '||
6344: 'AND checkrun_id = '||to_char(p_checkrun_id));
6345: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'LEGAL_ENTITY');
6346: DBMS_XMLGEN.setRowTag(l_qryCtx, 'LE_GROUP');