APPS.PO_POAPPROVAL_INIT1 dependencies on PO_LOOKUP_CODES

Line 528: from po_lookup_codes

524: -------------------------------------------------------------------------------------
525: --Added by Eric Ma for IL PO Notification on Apr-13,2009 ,End
526: cursor c1(p_auth_stat varchar2) is
527: select DISPLAYED_FIELD
528: from po_lookup_codes
529: where lookup_type='AUTHORIZATION STATUS'
530: and lookup_code = p_auth_stat;
531:
532: cursor c2(p_closed_code varchar2) is

Line 534: from po_lookup_codes

530: and lookup_code = p_auth_stat;
531:
532: cursor c2(p_closed_code varchar2) is
533: select DISPLAYED_FIELD
534: from po_lookup_codes
535: where lookup_type='DOCUMENT STATE'
536: and lookup_code = p_closed_code;
537:
538: /* Bug# 2616433: kagarwal

Line 954: from po_lookup_codes

950: -------------------------------------------------------------------------------------
951: --Added by Eric Ma for IL PO Notification on Apr-13,2009,End
952: cursor c1(p_auth_stat varchar2) is
953: select DISPLAYED_FIELD
954: from po_lookup_codes
955: where lookup_type='AUTHORIZATION STATUS'
956: and lookup_code = p_auth_stat;
957:
958: /*

Line 961: from po_lookup_codes

957:
958: /*
959: cursor c2(p_closed_code varchar2) is
960: select DISPLAYED_FIELD
961: from po_lookup_codes
962: where lookup_type='DOCUMENT STATE'
963: and lookup_code = p_closed_code;
964: */
965:

Line 980: from po_lookup_codes

976:
977: /*
978: cursor c3(p_doc_type varchar2) is
979: select DISPLAYED_FIELD
980: from po_lookup_codes
981: where lookup_type='DOCUMENT TYPE'
982: and lookup_code = p_doc_type;
983:
984: cursor c4(p_doc_subtype varchar2) is

Line 986: from po_lookup_codes

982: and lookup_code = p_doc_type;
983:
984: cursor c4(p_doc_subtype varchar2) is
985: select DISPLAYED_FIELD
986: from po_lookup_codes
987: where lookup_type='DOCUMENT SUBTYPE'
988: and lookup_code = p_doc_subtype;
989: */
990: