APPS.AP_AUTOSELECT_PKG dependencies on AP_OU_GROUP

Line 943: ' from AP_OU_GROUP '||

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 '||
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 '||

Line 1003: ' from AP_OU_GROUP '||

999: IF p_ou_group_option <> 'ALL' THEN
1000: l_sql_stmt := l_sql_stmt||
1001: ' AND ai.org_id in '||
1002: ' (select /*+ push_subq */ org_id '||
1003: ' from AP_OU_GROUP '||
1004: ' where checkrun_id BETWEEN :p_checkrun_id AND :p_checkrun_id) ';
1005: ELSE
1006: l_sql_stmt := l_sql_stmt||
1007: ' AND :p_checkrun_id = :p_checkrun_id ';

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

2125: and alg.template_id = appt.template_id
2126: and appt.le_group_option = 'SPECIFY';
2127:
2128:
2129: l_debug_info := 'insert into AP_OU_GROUP';
2130: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2131: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
2132: END IF;
2133:

Line 2134: insert into AP_OU_GROUP (

2130: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2131: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
2132: END IF;
2133:
2134: insert into AP_OU_GROUP (
2135: org_id,
2136: checkrun_id,
2137: OU_GROUP_ID,
2138: CREATION_DATE,

Line 2144: AP_OU_GROUP_S.nextval,

2140: LAST_UPDATE_DATE,
2141: LAST_UPDATED_BY)
2142: select aog.org_id,
2143: p_checkrun_id,
2144: AP_OU_GROUP_S.nextval,
2145: sysdate,
2146: aog.created_by,
2147: sysdate,
2148: aog.last_updated_by

Line 2149: from ap_ou_group aog,

2145: sysdate,
2146: aog.created_by,
2147: sysdate,
2148: aog.last_updated_by
2149: from ap_ou_group aog,
2150: ap_payment_templates appt
2151: where aog.template_id = p_template_id
2152: and aog.template_id = appt.template_id
2153: and appt.ou_group_option = 'SPECIFY';

Line 2764: from AP_OU_GROUP

2760: INTO l_encumbrance_flag
2761: FROM financials_system_parameters
2762: WHERE nvl(purch_encumbrance_flag,'N') = 'Y'
2763: AND (org_id in (select org_id
2764: from AP_OU_GROUP
2765: where checkrun_id = l_checkrun_id)
2766: or l_ou_group_option = 'ALL')
2767: AND rownum=1;
2768:

Line 3069: ' from AP_OU_GROUP '||

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 '||
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 '||

Line 3130: ' from AP_OU_GROUP '||

3126: IF l_ou_group_option <> 'ALL' THEN
3127: l_sql_stmt := l_sql_stmt||
3128: ' AND ai.org_id in '||
3129: ' (select /*+ no_push_subq no_unnest*/ org_id '||
3130: ' from AP_OU_GROUP '||
3131: ' where checkrun_id BETWEEN :p_checkrun_id AND :p_checkrun_id) ';
3132: ELSE
3133: l_sql_stmt := l_sql_stmt||
3134: ' AND :p_checkrun_id = :p_checkrun_id ';

Line 3894: ' from AP_OU_GROUP '||

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 '||
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 '||

Line 3955: ' from AP_OU_GROUP '||

3951: IF l_ou_group_option <> 'ALL' THEN
3952: l_sql_stmt := l_sql_stmt||
3953: ' AND ai.org_id in '||
3954: ' (select /*+ no_push_subq no_unnest*/ org_id '||
3955: ' from AP_OU_GROUP '||
3956: ' where checkrun_id BETWEEN :p_checkrun_id AND :p_checkrun_id) ';
3957: ELSE
3958: l_sql_stmt := l_sql_stmt||
3959: ' AND :p_checkrun_id = :p_checkrun_id ';

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

6352:
6353: l_debug_info := 'select ou group';
6354:
6355: l_qryCtx := DBMS_XMLGEN.newContext('SELECT name organization_name '||
6356: 'FROM AP_OU_GROUP AOG, HR_OPERATING_UNITS HR '||
6357: 'WHERE hr.organization_id = aog.org_id '||
6358: 'AND checkrun_id = '||to_char(p_checkrun_id));
6359: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'ORGANIZATION');
6360: DBMS_XMLGEN.setRowTag(l_qryCtx, 'OU_GROUP');