APPS.AP_AUTOSELECT_PKG dependencies on AP_CURRENCY_GROUP

Line 947: ' from AP_CURRENCY_GROUP '||

943: ' from AP_OU_GROUP '||
944: ' where checkrun_id = :p_checkrun_id) '||
945: ' or :p_ou_group_option = ''ALL'') '||
946: ' AND (ai.payment_currency_code in (select /*+ push_subq * / currency_code '||
947: ' from AP_CURRENCY_GROUP '||
948: ' where checkrun_id = :p_checkrun_id) '||
949: ' or :p_currency_group_option = ''ALL'') 'Commented for Bug#11848050 */ ;
950:
951: /* Code Added for bug#11848050 Start */

Line 1014: ' from AP_CURRENCY_GROUP '||

1010: IF p_currency_group_option <> 'ALL' THEN
1011: l_sql_stmt := l_sql_stmt||
1012: ' AND ai.payment_currency_code in '||
1013: ' (select /*+ push_subq */ currency_code '||
1014: ' from AP_CURRENCY_GROUP '||
1015: ' where checkrun_id BETWEEN :p_checkrun_id AND :p_checkrun_id) ';
1016: ELSE
1017: l_sql_stmt := l_sql_stmt||
1018: ' AND :p_checkrun_id = :p_checkrun_id ';

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

2151: where aog.template_id = p_template_id
2152: and aog.template_id = appt.template_id
2153: and appt.ou_group_option = 'SPECIFY';
2154:
2155: l_debug_info := 'insert into AP_CURRENCY_GROUP';
2156: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2157: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
2158: END IF;
2159:

Line 2161: insert into AP_CURRENCY_GROUP (

2157: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
2158: END IF;
2159:
2160:
2161: insert into AP_CURRENCY_GROUP (
2162: currency_code,
2163: checkrun_id,
2164: CURRENCY_GROUP_ID,
2165: CREATION_DATE,

Line 2171: AP_CURRENCY_GROUP_S.nextval,

2167: LAST_UPDATE_DATE,
2168: LAST_UPDATED_BY)
2169: select currency_code,
2170: p_checkrun_id,
2171: AP_CURRENCY_GROUP_S.nextval,
2172: sysdate,
2173: acg.created_by,
2174: sysdate,
2175: acg.last_updated_by

Line 2176: from AP_CURRENCY_GROUP acg,

2172: sysdate,
2173: acg.created_by,
2174: sysdate,
2175: acg.last_updated_by
2176: from AP_CURRENCY_GROUP acg,
2177: ap_payment_templates appt
2178: where acg.template_id = p_template_id
2179: and acg.template_id = appt.template_id
2180: and appt.currency_group_option = 'SPECIFY';--Bug6926344

Line 3073: ' from AP_CURRENCY_GROUP '||

3069: ' from AP_OU_GROUP '||
3070: ' where checkrun_id = :p_checkrun_id) '||
3071: ' or :p_ou_group_option = ''ALL'') '||
3072: ' AND (ai.payment_currency_code in (select /*+ push_subq * / currency_code '||
3073: ' from AP_CURRENCY_GROUP '||
3074: ' where checkrun_id = :p_checkrun_id) '||
3075: ' or :p_curr_group_option = ''ALL'') ' Commented for bug#11848050 */;
3076:
3077: /* Code Added for bug#11848050 Start */

Line 3142: ' from AP_CURRENCY_GROUP '||

3138: IF l_currency_group_option <> 'ALL' THEN
3139: l_sql_stmt := l_sql_stmt||
3140: ' AND ai.payment_currency_code in '||
3141: ' (select /*+ no_unnest */ currency_code '||
3142: ' from AP_CURRENCY_GROUP '||
3143: ' where checkrun_id BETWEEN :p_checkrun_id AND :p_checkrun_id) ';
3144: ELSE
3145: l_sql_stmt := l_sql_stmt||
3146: ' AND :p_checkrun_id = :p_checkrun_id ';

Line 3898: ' from AP_CURRENCY_GROUP '||

3894: ' from AP_OU_GROUP '||
3895: ' where checkrun_id = :p_checkrun_id) '||
3896: ' or :p_ou_group_option = ''ALL'') '||
3897: ' AND (ai.payment_currency_code in (select /*+ push_subq * / currency_code '||
3898: ' from AP_CURRENCY_GROUP '||
3899: ' where checkrun_id = :p_checkrun_id) '||
3900: ' or :p_curr_group_option = ''ALL'') ' Commented for bug#11848050 */;
3901:
3902: /* Code Added for bug#11848050 Start */

Line 3967: ' from AP_CURRENCY_GROUP '||

3963: IF l_currency_group_option <> 'ALL' THEN
3964: l_sql_stmt := l_sql_stmt||
3965: ' AND ai.payment_currency_code in '||
3966: ' (select /*+ no_unnest */ currency_code '||
3967: ' from AP_CURRENCY_GROUP '||
3968: ' where checkrun_id BETWEEN :p_checkrun_id AND :p_checkrun_id) ';
3969: ELSE
3970: l_sql_stmt := l_sql_stmt||
3971: ' AND :p_checkrun_id = :p_checkrun_id ';

Line 6328: 'FROM AP_CURRENCY_GROUP '||

6324:
6325: l_debug_info := 'select currency group';
6326:
6327: l_qryCtx := DBMS_XMLGEN.newContext('SELECT currency_code '||
6328: 'FROM AP_CURRENCY_GROUP '||
6329: 'WHERE checkrun_id = '||to_char(p_checkrun_id));
6330: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'CURRENCY');
6331: DBMS_XMLGEN.setRowTag(l_qryCtx, 'CURRENCY_GROUP');
6332: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);