APPS.PO_SIGNATURE_PVT dependencies on HR_LEGAL_ENTITIES

Line 308: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;

304: l_item_key WF_ITEMS.item_key%TYPE;
305: l_firstcolon NUMBER;
306: l_secondcolon NUMBER;
307: l_amount NUMBER;
308: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;
309: l_orgid PO_HEADERS_ALL.org_id%TYPE;
310: l_doc_string VARCHAR2(200);
311: l_preparer_user_name WF_USERS.name%TYPE;
312: l_progress VARCHAR2(300);

Line 370: HR_LEGAL_ENTITIES HRL

366:
367: /* SELECT HRL.name
368: INTO l_buyer_org
369: FROM HR_OPERATING_UNITS HRO,
370: HR_LEGAL_ENTITIES HRL
371: WHERE HRO.default_legal_context_id = HRL.organization_id -- Bug#5527795
372: AND HRO.organization_id = l_orgid; */
373: EXCEPTION
374: WHEN NO_DATA_FOUND THEN

Line 1340: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;

1336: l_supplier_displayname WF_LOCAL_ROLES.display_name%TYPE;
1337: l_supplier_username WF_LOCAL_ROLES.name%TYPE;
1338: l_supplier_org PO_VENDORS.vendor_name%TYPE;
1339: l_supplier_userid WF_LOCAL_ROLES.orig_system_id%TYPE;
1340: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;
1341: l_orgid PO_HEADERS_ALL.org_id%TYPE;
1342: l_doc_string VARCHAR2(200);
1343: l_preparer_user_name WF_USERS.name%TYPE;
1344: l_progress VARCHAR2(300);

Line 1427: HR_LEGAL_ENTITIES HRL

1423: x_legalentity_info);
1424: /* SELECT HRL.name
1425: INTO l_buyer_org
1426: FROM HR_OPERATING_UNITS HRO,
1427: HR_LEGAL_ENTITIES HRL
1428: WHERE HRO.default_legal_context_id = HRL.organization_id -- Bug#5527795
1429: AND HRO.organization_id = l_orgid; */
1430: EXCEPTION
1431: WHEN NO_DATA_FOUND THEN

Line 1694: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;

1690: l_document_number PO_HEADERS_ALL.segment1%TYPE;
1691: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
1692: l_revision PO_HEADERS_ALL.revision_num%TYPE;
1693: l_supplier_name FND_USER.user_name%TYPE;
1694: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;
1695: l_orgid PO_HEADERS_ALL.org_id%TYPE;
1696: l_doc_string VARCHAR2(200);
1697: l_preparer_user_name WF_USERS.name%TYPE;
1698: l_progress VARCHAR2(300);

Line 1773: HR_LEGAL_ENTITIES HRL

1769: x_legalentity_info);
1770: /* SELECT HRL.name
1771: INTO l_buyer_org
1772: FROM HR_OPERATING_UNITS HRO,
1773: HR_LEGAL_ENTITIES HRL
1774: WHERE HRO.default_legal_context_id = HRL.organization_id -- Bug#5527795
1775: AND HRO.organization_id = l_orgid;*/
1776: EXCEPTION
1777: WHEN NO_DATA_FOUND THEN