APPS.IBY_UTILITY_PVT dependencies on AP_INV_SELECTION_CRITERIA_ALL

Line 870: FROM ap_inv_selection_criteria_all ap

866:
867:
868: SELECT count(*)
869: INTO l_count2
870: FROM ap_inv_selection_criteria_all ap
871: WHERE ap.status IN ('REVIEW', 'MISSING RATES' )
872: AND NOT EXISTS ( SELECT 'NEED_ACTION_BY_ME'
873: FROM iby_pay_service_requests iby
874: WHERE iby.calling_app_id = 200

Line 931: FROM ap_inv_selection_criteria_all ap

927:
928:
929: SELECT count(*)
930: INTO l_count2
931: FROM ap_inv_selection_criteria_all ap
932: WHERE ap.status IN ('UNSTARTED', 'SELECTING', 'CANCELING',
933: 'CALCULATING', 'SELECTED')
934: AND NOT EXISTS ( SELECT 'PROCESSING'
935: FROM iby_pay_service_requests iby

Line 946: FROM ap_inv_selection_criteria_all ap

942:
943: ELSIF p_snapshot_code = 'USER_TERMINATED' THEN
944: SELECT count(*)
945: INTO l_count1
946: FROM ap_inv_selection_criteria_all ap
947: WHERE EXISTS ( SELECT 'IBY USER_TERMINATED'
948: FROM iby_pay_service_requests iby
949: WHERE iby.calling_app_id = 200
950: AND iby.call_app_pay_service_req_code =

Line 958: FROM ap_inv_selection_criteria_all ap

954: AND ap.creation_date BETWEEN TRUNC(SYSDATE) AND (TRUNC(SYSDATE) + 0.99999);
955:
956: SELECT count(*)
957: INTO l_count2
958: FROM ap_inv_selection_criteria_all ap
959: WHERE ap.status IN ('CANCELED', 'CANCELLED NO PAYMENTS')
960: AND TRUNC(ap.creation_date) =TRUNC(sysdate)
961: AND NOT EXISTS ( SELECT 'AP USER_TERMINATED'
962: FROM iby_pay_service_requests iby

Line 975: FROM ap_inv_selection_criteria_all ap

971: ELSIF p_snapshot_code = 'PROGRAM_ERRORS' THEN
972:
973: SELECT count(*)
974: INTO l_count1
975: FROM ap_inv_selection_criteria_all ap
976: WHERE EXISTS ( SELECT 'PROGRAM ERRORS'
977: FROM iby_pay_service_requests iby
978: WHERE iby.calling_app_id = 200
979: AND iby.call_app_pay_service_req_code =

Line 993: FROM ap_inv_selection_criteria_all ap

989: ELSIF p_snapshot_code = 'COMPLETED' THEN
990:
991: SELECT count(*)
992: INTO l_count1
993: FROM ap_inv_selection_criteria_all ap
994: WHERE EXISTS ( SELECT 'COMPLETED'
995: FROM iby_pay_service_requests iby
996: WHERE iby.calling_app_id = 200
997: AND iby.call_app_pay_service_req_code =