APPS.AP_APXTRSWP_XMLP_PKG dependencies on HR_OPERATING_UNITS

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

Line 1289: FROM ap_inv_selection_criteria_all AIS, hr_operating_units HOU

1285: AND rownum = 1;
1286:
1287: SELECT COUNT(*)
1288: INTO cpb_counter
1289: FROM ap_inv_selection_criteria_all AIS, hr_operating_units HOU
1290: WHERE AIS.org_id = HOU.organization_id
1291: AND AIS.check_date BETWEEN p_start_date AND p_end_date
1292: AND status NOT IN ('CONFIRMED', 'CANCELED', 'QUICKCHECK')
1293: AND HOU.set_of_books_id = to_char(p_set_of_books_id) --Bug 2986690