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_APXTRSWP_XMLP_PKG dependencies on AP_CHECKS_ALL

Line 393: FROM ap_checks_all

389: BEGIN
390:
391: SELECT COUNT(*)
392: INTO cfp_counter
393: FROM ap_checks_all
394: WHERE future_pay_due_date IS NOT NULL
395: AND status_lookup_code = 'ISSUED'
396: AND future_pay_due_date BETWEEN p_start_date AND p_end_date
397: AND org_id = co_org_id

Line 1084: FROM ap_checks_all

1080: AND rownum = 1;
1081:
1082: SELECT COUNT(*)
1083: INTO cfp_counter
1084: FROM ap_checks_all
1085: WHERE future_pay_due_date IS NOT NULL
1086: AND status_lookup_code = 'ISSUED'
1087: AND future_pay_due_date BETWEEN p_start_date AND p_end_date
1088: AND org_id = co_org_id

Line 1279: FROM ap_checks_all AC, hr_operating_units HOU

1275: AND rownum = 1;
1276:
1277: SELECT COUNT(*)
1278: INTO cfp_counter
1279: FROM ap_checks_all AC, hr_operating_units HOU
1280: WHERE AC.org_id = HOU.organization_id
1281: AND AC.future_pay_due_date IS NOT NULL
1282: AND AC.status_lookup_code = 'ISSUED'
1283: AND AC.future_pay_due_date BETWEEN p_start_date AND p_end_date