APPS.PO_COPYDOC_SUB dependencies on PO_LOOKUP_CODES

Line 790: FROM PO_LOOKUP_CODES

786: x_progress := '007';
787: BEGIN
788: SELECT distinct 'Y'
789: INTO x_valid_flag
790: FROM PO_LOOKUP_CODES
791: WHERE lookup_type = 'FOB'
792: AND SYSDATE < nvl(inactive_date, SYSDATE+1)
793: AND lookup_code = x_fob_lookup_code;
794: EXCEPTION

Line 817: FROM PO_LOOKUP_CODES

813: x_progress := '007';
814: BEGIN
815: SELECT distinct 'Y'
816: INTO x_valid_flag
817: FROM PO_LOOKUP_CODES
818: WHERE lookup_type = 'FREIGHT TERMS'
819: AND SYSDATE < nvl(inactive_date, SYSDATE+1)
820: AND lookup_code = x_freight_terms_lu_code;
821: EXCEPTION

Line 1621: from po_lookup_codes

1617: --< Bug 3546252 > When a transaction flow exists, no need to check the
1618: -- accrue_on_receipt_flag.
1619: select distinct 'Y' valid
1620: into x_valid_flag
1621: from po_lookup_codes
1622: where lookup_type = 'DESTINATION TYPE'
1623: and ( ( nvl(x_item_status,'D') = 'D'
1624: and lookup_code <> 'INVENTORY' )
1625: or ( nvl(x_item_status,'D') = 'E'

Line 1651: from po_lookup_codes

1647: --< Bug 3546252 > When a transaction flow exists, no need to check the
1648: -- accrue_on_receipt_flag.
1649: select distinct 'Y' valid
1650: into x_valid_flag
1651: from po_lookup_codes
1652: where lookup_type = 'DESTINATION TYPE'
1653: and ( ( nvl( x_item_status,'D') = 'D'
1654: and lookup_code = 'EXPENSE')
1655: or ( nvl( x_item_status,'D') = 'E'