eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_AUTOSELECT_PKG dependencies on AP_PAY_GROUP

Line 969: ' from AP_PAY_GROUP apg'|| --bug9087739, added alias for AP_PAY_GROUP

965: IF p_pay_group_option <> 'ALL' THEN
966: l_sql_stmt := l_sql_stmt||
967: /* Commented for Bug#9182499 Start
968: ' AND inv.pay_group_lookup_code in (select / *+ leading(apg) cardinality(apg 1) * / vendor_pay_group '||
969: ' from AP_PAY_GROUP apg'|| --bug9087739, added alias for AP_PAY_GROUP
970: ' where checkrun_id BETWEEN :p_checkrun_id AND :p_checkrun_id) ';
971: Commented for Bug#9182499 End */
972: /* Added for Bug#9182499 Start */
973: ' AND (ai.pay_group_lookup_code, ai.org_id) in '||

Line 977: ' from AP_PAY_GROUP apg, MO_GLOB_ORG_ACCESS_TMP mo '||

973: ' AND (ai.pay_group_lookup_code, ai.org_id) in '||
974: ' ( select '|| /* Added for bug#12773508 */
975: /* ' ( select / *+ leading(apg) cardinality(apg 1) * / '|| Commented for bug#12773508 */
976: ' apg.vendor_pay_group, mo.ORGANIZATION_ID '||
977: ' from AP_PAY_GROUP apg, MO_GLOB_ORG_ACCESS_TMP mo '||
978: ' where checkrun_id BETWEEN :p_checkrun_id AND :p_checkrun_id '||
979: ' AND ai.org_id = mo.organization_id) '; /* Added for bug#11848050 */
980: /* Added for Bug#9182499 End */
981:

Line 2182: l_debug_info := 'insert into AP_PAY_GROUP';

2178: where acg.template_id = p_template_id
2179: and acg.template_id = appt.template_id
2180: and appt.currency_group_option = 'SPECIFY';--Bug6926344
2181:
2182: l_debug_info := 'insert into AP_PAY_GROUP';
2183: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2184: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
2185: END IF;
2186:

Line 2187: insert into AP_PAY_GROUP (

2183: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2184: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
2185: END IF;
2186:
2187: insert into AP_PAY_GROUP (
2188: vendor_pay_group,
2189: checkrun_id,
2190: PAY_GROUP_ID,
2191: CREATION_DATE,

Line 2197: AP_PAY_GROUP_S.nextval,

2193: LAST_UPDATE_DATE,
2194: LAST_UPDATED_BY)
2195: select vendor_pay_group,
2196: p_checkrun_id,
2197: AP_PAY_GROUP_S.nextval,
2198: sysdate,
2199: apg.created_by,
2200: sysdate,
2201: apg.last_updated_by

Line 2202: from AP_PAY_GROUP apg,

2198: sysdate,
2199: apg.created_by,
2200: sysdate,
2201: apg.last_updated_by
2202: from AP_PAY_GROUP apg,
2203: ap_payment_templates appt
2204: where apg.template_id = p_template_id
2205: and apg.template_id = appt.template_id
2206: and appt.pay_group_option = 'SPECIFY'; --Bug6926344

Line 3095: ' from AP_PAY_GROUP apg'|| --bug9087739, added alias for AP_PAY_GROUP

3091: IF l_pay_group_option <> 'ALL' THEN
3092: l_sql_stmt := l_sql_stmt||
3093: /* Commented for Bug#9182499 Start
3094: ' AND inv.pay_group_lookup_code in (select / *+ leading(apg) cardinality(apg 1) * / vendor_pay_group '||
3095: ' from AP_PAY_GROUP apg'|| --bug9087739, added alias for AP_PAY_GROUP
3096: ' where checkrun_id BETWEEN :p_checkrun_id AND :p_checkrun_id) ';
3097: Commented for Bug#9182499 End */
3098: /* Added for Bug#9182499 Start */
3099: ' AND (ai.pay_group_lookup_code, ai.org_id) in '||

Line 3103: ' from AP_PAY_GROUP apg, MO_GLOB_ORG_ACCESS_TMP mo '||

3099: ' AND (ai.pay_group_lookup_code, ai.org_id) in '||
3100: ' ( select '|| /* Added for bug#12773508 */
3101: /* ' ( select / *+ leading(apg) cardinality(apg 1) * / '|| Commented for bug#12773508 */
3102: ' apg.vendor_pay_group, mo.ORGANIZATION_ID '||
3103: ' from AP_PAY_GROUP apg, MO_GLOB_ORG_ACCESS_TMP mo '||
3104: ' where checkrun_id BETWEEN :p_checkrun_id AND :p_checkrun_id '||
3105: ' AND ai.org_id = mo.organization_id ) '; /* Added for bug#11848050 */
3106: /* Added for Bug#9182499 End */
3107: ELSE

Line 3920: ' from AP_PAY_GROUP apg'|| --bug9087739, added alias for AP_PAY_GROUP

3916: IF l_pay_group_option <> 'ALL' THEN
3917: l_sql_stmt := l_sql_stmt||
3918: /* Commented for Bug#9182499 Start
3919: ' AND inv.pay_group_lookup_code in (select / *+ leading(apg) cardinality(apg 1) * / vendor_pay_group '||
3920: ' from AP_PAY_GROUP apg'|| --bug9087739, added alias for AP_PAY_GROUP
3921: ' where checkrun_id BETWEEN :p_checkrun_id AND :p_checkrun_id) ';
3922: Commented for Bug#9182499 End */
3923: /* Added for Bug#9182499 Start */
3924: ' AND (ai.pay_group_lookup_code, ai.org_id) in '||

Line 3928: ' from AP_PAY_GROUP apg, MO_GLOB_ORG_ACCESS_TMP mo '||

3924: ' AND (ai.pay_group_lookup_code, ai.org_id) in '||
3925: ' ( select '|| /* Added for bug#12773508 */
3926: /* ' ( select / *+ leading(apg) cardinality(apg 1) * / '|| Commented for bug#12773508 */
3927: ' apg.vendor_pay_group, mo.ORGANIZATION_ID '||
3928: ' from AP_PAY_GROUP apg, MO_GLOB_ORG_ACCESS_TMP mo '||
3929: ' where checkrun_id BETWEEN :p_checkrun_id AND :p_checkrun_id '||
3930: ' AND ai.org_id = mo.organization_id ) '; /* Added for bug#11848050 */
3931: /* Added for Bug#9182499 End */
3932:

Line 6315: 'FROM ap_pay_group '||

6311: l_debug_info := 'select pay group';
6312:
6313:
6314: l_qryCtx := DBMS_XMLGEN.newContext('SELECT vendor_pay_group '||
6315: 'FROM ap_pay_group '||
6316: 'WHERE checkrun_id = '||to_char(p_checkrun_id));
6317: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'PAY');
6318: DBMS_XMLGEN.setRowTag(l_qryCtx, 'PAY_GROUP');
6319: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);