APPS.PO_COPYDOC_SUB dependencies on PO_LOOKUP_CODES

Line 835: FROM PO_LOOKUP_CODES

831: x_progress := '007';
832: BEGIN
833: SELECT distinct 'Y'
834: INTO x_valid_flag
835: FROM PO_LOOKUP_CODES
836: WHERE lookup_type = 'FOB'
837: AND SYSDATE < nvl(inactive_date, SYSDATE+1)
838: AND lookup_code = x_fob_lookup_code;
839: EXCEPTION

Line 862: FROM PO_LOOKUP_CODES

858: x_progress := '007';
859: BEGIN
860: SELECT distinct 'Y'
861: INTO x_valid_flag
862: FROM PO_LOOKUP_CODES
863: WHERE lookup_type = 'FREIGHT TERMS'
864: AND SYSDATE < nvl(inactive_date, SYSDATE+1)
865: AND lookup_code = x_freight_terms_lu_code;
866: EXCEPTION

Line 1757: from po_lookup_codes

1753: --< Bug 3546252 > When a transaction flow exists, no need to check the
1754: -- accrue_on_receipt_flag.
1755: select distinct 'Y' valid
1756: into x_valid_flag
1757: from po_lookup_codes
1758: where lookup_type = 'DESTINATION TYPE'
1759: and ( ( nvl(x_item_status,'D') = 'D'
1760: and lookup_code <> 'INVENTORY' )
1761: or ( nvl(x_item_status,'D') = 'E'

Line 1787: from po_lookup_codes

1783: --< Bug 3546252 > When a transaction flow exists, no need to check the
1784: -- accrue_on_receipt_flag.
1785: select distinct 'Y' valid
1786: into x_valid_flag
1787: from po_lookup_codes
1788: where lookup_type = 'DESTINATION TYPE'
1789: and ( ( nvl( x_item_status,'D') = 'D'
1790: and lookup_code = 'EXPENSE')
1791: or ( nvl( x_item_status,'D') = 'E'