DBA Data[Home] [Help]

APPS.OKL_CREATE_DISB_TRANS_PVT dependencies on PO_VENDOR_SITES_ALL

Line 44: l_pay_group_lookup_code PO_VENDOR_SITES_ALL.PAY_GROUP_LOOKUP_CODE%TYPE;

40: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
41: -- l_set_of_books_id NUMBER;
42: l_terms_id NUMBER;
43: -- l_application_id NUMBER;
44: l_pay_group_lookup_code PO_VENDOR_SITES_ALL.PAY_GROUP_LOOKUP_CODE%TYPE;
45: l_vendor_id NUMBER;
46:
47: CURSOR c_vendor(p_vendor_site_id NUMBER)
48: IS

Line 75: from PO_VENDOR_SITES_ALL a

71:
72: CURSOR c_vendor_sites(p_vendor_site_id NUMBER)
73: IS
74: select a.TERMS_ID, a.PAY_GROUP_LOOKUP_CODE
75: from PO_VENDOR_SITES_ALL a
76: where vendor_site_id = p_vendor_site_id
77: ;
78:
79: -- select apps.FND_DOC_SEQ_885_S.nextval from dual;