APPS.PO_LINK_REQ_DIST_PVT dependencies on GL_SETS_OF_BOOKS

Line 224: GL_SETS_OF_BOOKS GLSOB,

220:
221: SELECT PH.CURRENCY_CODE, PH.RATE, GLSOB.CURRENCY_CODE, GLSOB.SET_OF_BOOKS_ID, PH.ORG_ID
222: INTO L_CURRENCY_CODE, L_RATE , L_FUNC_CURRENCY_CODE, L_SOB, L_ORG_ID
223: FROM PO_HEADERS_DRAFT_ALL PH,
224: GL_SETS_OF_BOOKS GLSOB,
225: ORG_ORGANIZATION_DEFINITIONS OOD
226: WHERE PH.PO_HEADER_ID = L_HEADER_ID
227: AND PH.DRAFT_ID = L_DRAFT_ID
228: AND GLSOB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID

Line 239: GL_SETS_OF_BOOKS GLSOB,

235:
236: SELECT PH.CURRENCY_CODE, PH.RATE, GLSOB.CURRENCY_CODE, GLSOB.SET_OF_BOOKS_ID, PH.ORG_ID
237: INTO L_CURRENCY_CODE, L_RATE , L_FUNC_CURRENCY_CODE, L_SOB, L_ORG_ID
238: FROM PO_HEADERS_ALL PH,
239: GL_SETS_OF_BOOKS GLSOB,
240: ORG_ORGANIZATION_DEFINITIONS OOD
241: WHERE PH.PO_HEADER_ID = L_HEADER_ID
242: AND GLSOB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID
243: AND OOD.ORGANIZATION_ID = PH.ORG_ID AND ROWNUM < 2;

Line 1108: GL_SETS_OF_BOOKS GLSOB,

1104:
1105: SELECT PH.CURRENCY_CODE, PH.RATE, GLSOB.CURRENCY_CODE
1106: INTO L_CURRENCY_CODE, L_RATE , L_FUNC_CURRENCY_CODE
1107: FROM PO_HEADERS_DRAFT_ALL PH,
1108: GL_SETS_OF_BOOKS GLSOB,
1109: ORG_ORGANIZATION_DEFINITIONS OOD
1110: WHERE PH.PO_HEADER_ID = L_HEADER_ID
1111: AND PH.DRAFT_ID = L_DRAFT_ID
1112: AND GLSOB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID

Line 1179: GL_SETS_OF_BOOKS GLSOB,

1175:
1176: SELECT PH.CURRENCY_CODE, PH.RATE, GLSOB.CURRENCY_CODE
1177: INTO L_CURRENCY_CODE, L_RATE , L_FUNC_CURRENCY_CODE
1178: FROM PO_HEADERS_ALL PH,
1179: GL_SETS_OF_BOOKS GLSOB,
1180: ORG_ORGANIZATION_DEFINITIONS OOD
1181: WHERE PH.PO_HEADER_ID = L_HEADER_ID
1182: AND GLSOB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID
1183: AND OOD.ORGANIZATION_ID = PH.ORG_ID AND ROWNUM < 2;