APPS.PO_POAPPROVAL_INIT1 dependencies on PO_LOOKUP_CODES

Line 424: from po_lookup_codes

420: /* End Bug# 3972475*/
421:
422: cursor c1(p_auth_stat varchar2) is
423: select DISPLAYED_FIELD
424: from po_lookup_codes
425: where lookup_type='AUTHORIZATION STATUS'
426: and lookup_code = p_auth_stat;
427:
428: cursor c2(p_closed_code varchar2) is

Line 430: from po_lookup_codes

426: and lookup_code = p_auth_stat;
427:
428: cursor c2(p_closed_code varchar2) is
429: select DISPLAYED_FIELD
430: from po_lookup_codes
431: where lookup_type='DOCUMENT STATE'
432: and lookup_code = p_closed_code;
433:
434: /* Bug# 2616433: kagarwal

Line 448: from po_lookup_codes

444:
445: /*
446: cursor c3(p_doc_type varchar2) is
447: select DISPLAYED_FIELD
448: from po_lookup_codes
449: where lookup_type='DOCUMENT TYPE'
450: and lookup_code = p_doc_type;
451:
452: cursor c4(p_doc_subtype varchar2) is

Line 454: from po_lookup_codes

450: and lookup_code = p_doc_type;
451:
452: cursor c4(p_doc_subtype varchar2) is
453: select DISPLAYED_FIELD
454: from po_lookup_codes
455: where lookup_type='DOCUMENT SUBTYPE'
456: and lookup_code = p_doc_subtype;
457: */
458:

Line 748: from po_lookup_codes

744: /* End Bug# 3972475*/
745:
746: cursor c1(p_auth_stat varchar2) is
747: select DISPLAYED_FIELD
748: from po_lookup_codes
749: where lookup_type='AUTHORIZATION STATUS'
750: and lookup_code = p_auth_stat;
751:
752: /*

Line 755: from po_lookup_codes

751:
752: /*
753: cursor c2(p_closed_code varchar2) is
754: select DISPLAYED_FIELD
755: from po_lookup_codes
756: where lookup_type='DOCUMENT STATE'
757: and lookup_code = p_closed_code;
758: */
759:

Line 774: from po_lookup_codes

770:
771: /*
772: cursor c3(p_doc_type varchar2) is
773: select DISPLAYED_FIELD
774: from po_lookup_codes
775: where lookup_type='DOCUMENT TYPE'
776: and lookup_code = p_doc_type;
777:
778: cursor c4(p_doc_subtype varchar2) is

Line 780: from po_lookup_codes

776: and lookup_code = p_doc_type;
777:
778: cursor c4(p_doc_subtype varchar2) is
779: select DISPLAYED_FIELD
780: from po_lookup_codes
781: where lookup_type='DOCUMENT SUBTYPE'
782: and lookup_code = p_doc_subtype;
783: */
784: