APPS.PO_SIGNATURE_PVT dependencies on HR_LEGAL_ENTITIES

Line 381: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;

377: l_item_key WF_ITEMS.item_key%TYPE;
378: l_firstcolon NUMBER;
379: l_secondcolon NUMBER;
380: l_amount NUMBER;
381: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;
382: l_orgid PO_HEADERS_ALL.org_id%TYPE;
383: l_doc_string VARCHAR2(200);
384: l_preparer_user_name WF_USERS.name%TYPE;
385: l_progress VARCHAR2(300);

Line 456: HR_LEGAL_ENTITIES HRL

452:
453: /* SELECT HRL.name
454: INTO l_buyer_org
455: FROM HR_OPERATING_UNITS HRO,
456: HR_LEGAL_ENTITIES HRL
457: WHERE HRO.default_legal_context_id = HRL.organization_id -- Bug#5527795
458: AND HRO.organization_id = l_orgid; */
459: EXCEPTION
460: WHEN NO_DATA_FOUND THEN

Line 1683: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;

1679: l_supplier_displayname WF_LOCAL_ROLES.display_name%TYPE;
1680: l_supplier_username WF_LOCAL_ROLES.name%TYPE;
1681: l_supplier_org PO_VENDORS.vendor_name%TYPE;
1682: l_supplier_userid WF_LOCAL_ROLES.orig_system_id%TYPE;
1683: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;
1684: l_orgid PO_HEADERS_ALL.org_id%TYPE;
1685: l_doc_string VARCHAR2(200);
1686: l_preparer_user_name WF_USERS.name%TYPE;
1687: l_progress VARCHAR2(300);

Line 1770: HR_LEGAL_ENTITIES HRL

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

Line 2045: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;

2041: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
2042: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
2043: l_revision PO_HEADERS_ALL.revision_num%TYPE;
2044: l_supplier_name FND_USER.user_name%TYPE;
2045: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;
2046: l_orgid PO_HEADERS_ALL.org_id%TYPE;
2047: l_doc_string VARCHAR2(200);
2048: l_preparer_user_name WF_USERS.name%TYPE;
2049: l_progress VARCHAR2(300);

Line 2124: HR_LEGAL_ENTITIES HRL

2120: x_legalentity_info);
2121: /* SELECT HRL.name
2122: INTO l_buyer_org
2123: FROM HR_OPERATING_UNITS HRO,
2124: HR_LEGAL_ENTITIES HRL
2125: WHERE HRO.default_legal_context_id = HRL.organization_id -- Bug#5527795
2126: AND HRO.organization_id = l_orgid;*/
2127: EXCEPTION
2128: WHEN NO_DATA_FOUND THEN