APPS.AP_APXKIRKI_XMLP_PKG dependencies on AP_CHECKS

Line 458: AP_CHECKS

454: SELECT
455: count(*)
456: INTO L_TOTAL_VOIDED
457: FROM
458: AP_CHECKS
459: WHERE VOID_DATE <= TO_DATE(C_END_DATE
460: ,'DD/MM/YYYY');
461: SELECT
462: count(*)

Line 518: AP_CHECKS

514: ,AMOUNT)))
515: ,0)
516: INTO L_TOTAL_CLEARED,L_TOTAL_CLEARED_DLR
517: FROM
518: AP_CHECKS
519: WHERE CLEARED_DATE <= TO_DATE(C_END_DATE
520: ,'DD/MM/YYYY');
521: SELECT
522: count(*)

Line 525: AP_CHECKS

521: SELECT
522: count(*)
523: INTO L_TOTAL_STOPPED
524: FROM
525: AP_CHECKS
526: WHERE STOPPED_BY is not null
527: AND VOID_DATE is null
528: AND RELEASED_DATE is null;
529: SELECT

Line 595: AP_CHECKS

591: ,0)
592: ,0))
593: INTO L_TOTAL_MAN_CHECKS,L_TOTAL_MAN_CHECKS_DLR,L_TOTAL_AUTO_CHECKS,L_TOTAL_AUTO_CHECKS_DLR,L_TOTAL_SPOILED,L_TOTAL_OUTSTANDING,L_TOTAL_OUTSTANDING_DLR
594: FROM
595: AP_CHECKS
596: WHERE CHECK_DATE <= TO_DATE(C_END_DATE
597: ,'DD/MM/YYYY')
598: AND NVL(VOID_DATE
599: ,SYSDATE + 1) >= sysdate;

Line 614: AP_CHECKS

610: ,0))
611: ,0)
612: INTO L_TOTAL_REFUND_CHECKS,L_TOTAL_REFUND_CHECKS_DLR
613: FROM
614: AP_CHECKS
615: WHERE CHECK_DATE <= TO_DATE(C_END_DATE
616: ,'DD/MM/YYYY')
617: AND NVL(VOID_DATE
618: ,SYSDATE + 1) >= sysdate

Line 636: AP_CHECKS CHK,

632: ,1))
633: ,0)
634: INTO L_TOTAL_PAID_INV,L_TOTAL_DISCS_DLR,L_TOTAL_DISCS
635: FROM
636: AP_CHECKS CHK,
637: AP_INVOICE_PAYMENTS PAY
638: WHERE CHECK_DATE <= TO_DATE(C_END_DATE
639: ,'DD/MM/YYYY')
640: AND PAY.CHECK_ID = CHK.CHECK_ID

Line 928: AP_CHECKS

924: SELECT
925: count(*)
926: INTO L_VOID
927: FROM
928: AP_CHECKS
929: WHERE VOID_DATE >= TO_DATE(C_START_DATE
930: ,'DD/MM/YYYY')
931: AND VOID_DATE <= TO_DATE(C_END_DATE
932: ,'DD/MM/YYYY');

Line 941: AP_CHECKS

937: ,AMOUNT)))
938: ,0)
939: INTO L_CLEARED,L_CLEARED_DLR
940: FROM
941: AP_CHECKS
942: WHERE CLEARED_DATE >= TO_DATE(C_START_DATE
943: ,'DD/MM/YYYY')
944: AND CLEARED_DATE <= TO_DATE(C_END_DATE
945: ,'DD/MM/YYYY');

Line 950: AP_CHECKS

946: SELECT
947: count(*)
948: INTO L_STOPPED
949: FROM
950: AP_CHECKS
951: WHERE TRUNC(STOPPED_DATE) >= TO_DATE(C_START_DATE
952: ,'DD/MM/YYYY')
953: AND TRUNC(STOPPED_DATE) <= TO_DATE(C_END_DATE
954: ,'DD/MM/YYYY')

Line 1023: AP_CHECKS

1019: ,0)
1020: ,0))
1021: INTO L_MANUAL_CHECKS,L_MANUAL_CHECKS_DLR,L_AUTO_CHECKS,L_AUTO_CHECKS_DLR,L_NEW_SPOILED,L_NEW_OUTSTANDING,L_NEW_OUTSTANDING_DLR
1022: FROM
1023: AP_CHECKS
1024: WHERE CHECK_DATE >= TO_DATE(C_START_DATE
1025: ,'DD/MM/YYYY')
1026: AND CHECK_DATE <= TO_DATE(C_END_DATE
1027: ,'DD/MM/YYYY')

Line 1044: AP_CHECKS

1040: ,0))
1041: ,0)
1042: INTO L_NEW_REFUND_PAYMENTS,L_NEW_REFUND_PAYMENTS_DLR
1043: FROM
1044: AP_CHECKS
1045: WHERE CHECK_DATE >= TO_DATE(C_START_DATE
1046: ,'DD/MM/YYYY')
1047: AND CHECK_DATE <= TO_DATE(C_END_DATE
1048: ,'DD/MM/YYYY')

Line 1090: AP_CHECKS CHK,

1086: ,1))
1087: ,0)
1088: INTO L_MANUAL_PAYMENTS,L_MANUAL_PAYMENTS_DLR,L_AUTO_PAYMENTS,L_AUTO_PAYMENTS_DLR,L_INVOICES,L_DISCOUNT_DLR,L_DISCOUNTS
1089: FROM
1090: AP_CHECKS CHK,
1091: AP_INVOICE_PAYMENTS PAY
1092: WHERE CHECK_DATE >= TO_DATE(C_START_DATE
1093: ,'DD/MM/YYYY')
1094: AND CHECK_DATE <= TO_DATE(C_END_DATE