APPS.IBY_UTILITY_PVT dependencies on IBY_PAY_SERVICE_REQUESTS

Line 834: FROM iby_pay_service_requests iby

830:
831: SELECT
832: count(*)
833: INTO l_count1
834: FROM iby_pay_service_requests iby
835: WHERE iby.calling_app_id = 200
836: AND iby.process_type = 'STANDARD'
837: AND
838: ( iby.payment_service_request_status IN (

Line 873: FROM iby_pay_service_requests iby

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
875: AND iby.call_app_pay_service_req_code =
876: ap.checkrun_name);
877:

Line 889: FROM iby_pay_service_requests iby

885: are waiting for the user action*/
886: SELECT
887: count(*)
888: INTO l_count1
889: FROM iby_pay_service_requests iby
890: WHERE iby.calling_app_id = 200
891: AND iby.process_type = 'STANDARD'
892: AND
893: (

Line 935: FROM iby_pay_service_requests iby

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
936: WHERE iby.calling_app_id = 200
937: AND iby.call_app_pay_service_req_code =
938: ap.checkrun_name);
939:

Line 948: FROM iby_pay_service_requests iby

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 =
951: ap.checkrun_name
952: AND iby.payment_service_request_status IN

Line 962: FROM iby_pay_service_requests iby

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
963: WHERE iby.calling_app_id = 200
964: AND iby.call_app_pay_service_req_code =
965: ap.checkrun_name)
966: AND ap.creation_date BETWEEN TRUNC(SYSDATE) AND (TRUNC(SYSDATE) + 0.99999);

Line 977: FROM iby_pay_service_requests iby

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 =
980: ap.checkrun_name
981: AND iby.payment_service_request_status IN

Line 995: FROM iby_pay_service_requests iby

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 =
998: ap.checkrun_name
999: AND iby.payment_service_request_status IN