APPS.JL_ZZ_AP_LIBRARY_1_PKG dependencies on PO_VENDOR_SITES

Line 74: FROM FND_LOOKUPS L,PO_VENDOR_SITES V

70: Begin
71: errcd := 0;
72: SELECT L.LOOKUP_CODE
73: Into inttyp
74: FROM FND_LOOKUPS L,PO_VENDOR_SITES V
75: WHERE L.LOOKUP_CODE = V.GLOBAL_ATTRIBUTE2
76: AND L.LOOKUP_TYPE = 'JLBR_INTEREST_PENALTY_TYPE'
77: AND V.VENDOR_SITE_ID = vndstid and rownum = row_number;
78: Exception

Line 95: FROM PO_VENDOR_SITES

91: errcd := 0;
92: SELECT GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE6,
93: GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE3
94: INTO pntamt, intgrd, intprd, intamt
95: FROM PO_VENDOR_SITES
96: WHERE VENDOR_SITE_ID = vndstid and rownum = row_number;
97: Exception
98: When Others Then
99: errcd := sqlcode;

Line 110: FROM FND_LOOKUPS L, PO_VENDOR_SITES V

106: Begin
107: errcd := 0;
108: SELECT L.LOOKUP_CODE
109: INTO intfml
110: FROM FND_LOOKUPS L, PO_VENDOR_SITES V
111: WHERE L.LOOKUP_CODE = V.GLOBAL_ATTRIBUTE5
112: AND L.LOOKUP_TYPE = 'JLBR_INTEREST_FORMULA'
113: AND V.VENDOR_SITE_ID = vndstid and rownum = row_number;
114: Exception

Line 127: FROM FND_LOOKUPS L, PO_VENDOR_SITES V

123: Begin
124: errcd := 0;
125: SELECT L.LOOKUP_CODE
126: INTO pnttyp
127: FROM FND_LOOKUPS L, PO_VENDOR_SITES V
128: WHERE L.LOOKUP_CODE = V.GLOBAL_ATTRIBUTE7
129: AND L.LOOKUP_TYPE = 'JLBR_INTEREST_PENALTY_TYPE'
130: AND V.VENDOR_SITE_ID = vndstid and rownum = row_number;
131: Exception

Line 413: from po_vendor_sites

409: Begin
410: errcd := 0;
411: select state ship_from
412: into shp_frm
413: from po_vendor_sites
414: where vendor_site_id = vendsite_id
415: and nvl(inactive_date,sysdate + 1) > sysdate and rownum = row_number;
416: Exception
417: When Others Then

Line 622: from po_vendor_sites

618: Begin
619: errcd := 0;
620: select substr(global_attribute16,1,25)
621: into tax_cal_name
622: from po_vendor_sites
623: where vendor_site_id = vendsite_id
624: and nvl(inactive_date,sysdate + 1) > sysdate and rownum = row_number;
625: Exception
626: When Others Then

Line 771: from po_vendor_sites

767: Begin
768: errcd := 0;
769: select city
770: into vcity
771: from po_vendor_sites
772: where vendor_site_id = vendsite_id
773: and nvl(inactive_date,sysdate + 1) > sysdate and rownum = row_number;
774: Exception
775: When Others Then

Line 887: from po_vendor_sites

883: select city,
884: state --Bug # 2319552
885: into vcity,
886: vstate --Bug # 2319552
887: from po_vendor_sites
888: where vendor_site_id = vendsite_id
889: and nvl(inactive_date,sysdate + 1) > sysdate and rownum = row_number;
890: Exception
891: When Others Then