APPS.AP_APXKIRKI_XMLP_PKG dependencies on AP_HOLD_CODES

Line 503: AP_HOLD_CODES

499: INTO L_TOTAL_INVOICE_HOLDS,L_TOTAL_INVOICE_HOLDS_DLR
500: FROM
501: AP_INVOICES,
502: AP_HOLDS,
503: AP_HOLD_CODES
504: WHERE AP_INVOICES.INVOICE_ID = AP_HOLDS.INVOICE_ID
505: AND AP_HOLDS.HOLD_LOOKUP_CODE = AP_HOLD_CODES.HOLD_LOOKUP_CODE
506: AND AP_HOLD_CODES.HOLD_TYPE = 'INVOICE HOLD REASON'
507: AND AP_HOLDS.RELEASE_LOOKUP_CODE IS NULL

Line 505: AND AP_HOLDS.HOLD_LOOKUP_CODE = AP_HOLD_CODES.HOLD_LOOKUP_CODE

501: AP_INVOICES,
502: AP_HOLDS,
503: AP_HOLD_CODES
504: WHERE AP_INVOICES.INVOICE_ID = AP_HOLDS.INVOICE_ID
505: AND AP_HOLDS.HOLD_LOOKUP_CODE = AP_HOLD_CODES.HOLD_LOOKUP_CODE
506: AND AP_HOLD_CODES.HOLD_TYPE = 'INVOICE HOLD REASON'
507: AND AP_HOLDS.RELEASE_LOOKUP_CODE IS NULL
508: AND TRUNC(AP_INVOICES.CREATION_DATE) <= TO_DATE(C_END_DATE
509: ,'DD/MM/YYYY');

Line 506: AND AP_HOLD_CODES.HOLD_TYPE = 'INVOICE HOLD REASON'

502: AP_HOLDS,
503: AP_HOLD_CODES
504: WHERE AP_INVOICES.INVOICE_ID = AP_HOLDS.INVOICE_ID
505: AND AP_HOLDS.HOLD_LOOKUP_CODE = AP_HOLD_CODES.HOLD_LOOKUP_CODE
506: AND AP_HOLD_CODES.HOLD_TYPE = 'INVOICE HOLD REASON'
507: AND AP_HOLDS.RELEASE_LOOKUP_CODE IS NULL
508: AND TRUNC(AP_INVOICES.CREATION_DATE) <= TO_DATE(C_END_DATE
509: ,'DD/MM/YYYY');
510: SELECT

Line 711: AP_HOLD_CODES HC

707: FOR c1 IN (SELECT
708: H.INVOICE_ID
709: FROM
710: AP_HOLDS H,
711: AP_HOLD_CODES HC
712: WHERE RELEASE_LOOKUP_CODE is null
713: AND H.HOLD_LOOKUP_CODE = HC.HOLD_LOOKUP_CODE
714: AND HC.HOLD_TYPE = 'MATCHING HOLD REASON') LOOP
715: BEGIN

Line 1129: AP_HOLD_CODES HC

1125: INTO L_NEW_ON_HOLD,L_NEW_HOLD_DLR
1126: FROM
1127: AP_INVOICES I,
1128: AP_HOLDS H,
1129: AP_HOLD_CODES HC
1130: WHERE I.INVOICE_ID = H.INVOICE_ID
1131: AND H.HOLD_LOOKUP_CODE = HC.HOLD_LOOKUP_CODE
1132: AND TRUNC(I.CREATION_DATE) >= TO_DATE(C_START_DATE
1133: ,'DD/MM/YYYY')

Line 2016: AP_HOLD_CODES HC

2012: count(( INVOICE_ID ))
2013: INTO L_INVOICE_COUNT
2014: FROM
2015: AP_HOLDS H,
2016: AP_HOLD_CODES HC
2017: WHERE H.RELEASE_LOOKUP_CODE is null
2018: AND H.HOLD_LOOKUP_CODE = HC.HOLD_LOOKUP_CODE
2019: AND HC.HOLD_TYPE = 'MATCHING HOLD REASON';
2020: IF L_INVOICE_COUNT <> 0 THEN