APPS.AP_IMPORT_INVOICES_PKG dependencies on STANDARD

Line 247: NVL(invoice_type_lookup_code, 'STANDARD') <> 'PAYMENT REQUEST')

243: FROM ap_invoices_interface
244: WHERE ((status is NULL) OR (status = 'REJECTED'))
245: AND source = p_source
246: AND ((p_invoice_interface_id IS NULL AND
247: NVL(invoice_type_lookup_code, 'STANDARD') <> 'PAYMENT REQUEST')
248: OR (invoice_id = p_invoice_interface_id))
249: AND NVL(workflow_flag,'D') = 'D'
250: AND ( (p_commit_cycles IS NULL)
251: OR (rownum <= p_commit_cycles))

Line 429: NVL(invoice_type_lookup_code, 'STANDARD') <> 'PAYMENT REQUEST')

425: WHERE ((status is NULL) OR (status = 'REJECTED'))
426: AND source = p_source
427: AND group_id = p_group_id
428: AND ((p_invoice_interface_id IS NULL AND
429: NVL(invoice_type_lookup_code, 'STANDARD') <> 'PAYMENT REQUEST')
430: OR (invoice_id = p_invoice_interface_id))
431: AND NVL(workflow_flag,'D') = 'D'
432: AND ( (p_commit_cycles IS NULL)
433: OR (rownum <= p_commit_cycles))

Line 795: NVL(invoice_type_lookup_code, 'STANDARD') <> 'PAYMENT REQUEST')

791: FROM ap_invoices_interface
792: WHERE ((status is NULL) or (status = 'REJECTED'))
793: AND source = p_source
794: AND ((p_invoice_interface_id IS NULL AND
795: NVL(invoice_type_lookup_code, 'STANDARD') <> 'PAYMENT REQUEST')
796: OR (invoice_id = p_invoice_interface_id))
797: AND nvl(workflow_flag,'D') = 'D'
798: AND ((org_id is NOT NULL AND
799: p_org_id is NOT NULL AND

Line 816: NVL(invoice_type_lookup_code, 'STANDARD') <> 'PAYMENT REQUEST')

812: WHERE ((status is NULL) or (status = 'REJECTED'))
813: AND source = p_source
814: AND group_id = p_group_id
815: AND ((p_invoice_interface_id IS NULL AND
816: NVL(invoice_type_lookup_code, 'STANDARD') <> 'PAYMENT REQUEST')
817: OR (invoice_id = p_invoice_interface_id))
818: AND nvl(workflow_flag,'D') = 'D'
819: AND ((org_id is NOT NULL AND
820: p_org_id is NOT NULL AND

Line 904: NVL(invoice_type_lookup_code, 'STANDARD') <> 'PAYMENT REQUEST')

900: AND i.operating_unit is not null
901: AND ((status is NULL) OR (status = 'REJECTED'))
902: AND source = p_source
903: AND ((p_invoice_interface_id IS NULL AND
904: NVL(invoice_type_lookup_code, 'STANDARD') <> 'PAYMENT REQUEST')
905: OR (invoice_id = p_invoice_interface_id))
906: AND NVL(workflow_flag,'D') = 'D' ;
907:
908: --Bug 6839034 Added ELSE part

Line 924: NVL(invoice_type_lookup_code, 'STANDARD') <> 'PAYMENT REQUEST')

920: AND ((status is NULL) OR (status = 'REJECTED'))
921: AND source = p_source
922: AND group_id = p_group_id
923: AND ((p_invoice_interface_id IS NULL AND
924: NVL(invoice_type_lookup_code, 'STANDARD') <> 'PAYMENT REQUEST')
925: OR (invoice_id = p_invoice_interface_id))
926: AND NVL(workflow_flag,'D') = 'D' ;
927:
928: END IF;

Line 963: NVL(invoice_type_lookup_code, 'STANDARD') <> 'PAYMENT REQUEST')

959: FROM ap_invoices_interface
960: WHERE ((status is NULL) or (status = 'REJECTED'))
961: AND source = p_source
962: AND ((p_invoice_interface_id IS NULL AND
963: NVL(invoice_type_lookup_code, 'STANDARD') <> 'PAYMENT REQUEST')
964: OR (invoice_id = p_invoice_interface_id))
965: AND nvl(workflow_flag,'D') = 'D'
966: AND ((org_id is NOT NULL AND
967: p_org_id is NOT NULL AND

Line 996: NVL(invoice_type_lookup_code, 'STANDARD') <> 'PAYMENT REQUEST')

992: WHERE ((status is NULL) or (status = 'REJECTED'))
993: AND source = p_source
994: AND group_id = p_group_id
995: AND ((p_invoice_interface_id IS NULL AND
996: NVL(invoice_type_lookup_code, 'STANDARD') <> 'PAYMENT REQUEST')
997: OR (invoice_id = p_invoice_interface_id))
998: AND nvl(workflow_flag,'D') = 'D'
999: AND ((org_id is NOT NULL AND
1000: p_org_id is NOT NULL AND