APPS.POS_USER_ADMIN_PKG dependencies on HZ_PARTIES

Line 355: FROM hz_parties

351: WHERE person_party_id = p_party_id;
352:
353: CURSOR l_party_cur IS
354: SELECT object_version_number, last_update_date
355: FROM hz_parties
356: WHERE party_id = p_party_id;
357:
358: l_party_rec l_party_cur%ROWTYPE;
359:

Line 728: FROM hz_parties

724: l_testname NUMBER;
725:
726: CURSOR l_party_cur IS
727: SELECT party_type, status
728: FROM hz_parties
729: WHERE party_id = p_person_party_id;
730:
731: l_party_rec l_party_cur%ROWTYPE;
732:

Line 907: l_enterprise_name hz_parties.party_name%TYPE;

903: l_resp_ids po_tbl_number;
904: l_resp_app_ids po_tbl_number;
905: l_sec_attr_codes po_tbl_varchar30;
906: l_sec_attr_numbers po_tbl_number;
907: l_enterprise_name hz_parties.party_name%TYPE;
908: lv_exception_msg VARCHAR2(32000);
909: lv_status VARCHAR2(240);
910: l_itemtype wf_items.item_type%TYPE;
911: l_itemkey wf_items.item_key%TYPE;