DBA Data[Home] [Help]

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 730: FROM hz_parties

726: l_password_lifespan_days NUMBER DEFAULT NULL;
727: event_id Number;
728: CURSOR l_party_cur IS
729: SELECT party_type, status
730: FROM hz_parties
731: WHERE party_id = p_person_party_id;
732:
733: l_party_rec l_party_cur%ROWTYPE;
734:

Line 953: l_enterprise_name hz_parties.party_name%TYPE;

949: l_resp_ids po_tbl_number;
950: l_resp_app_ids po_tbl_number;
951: l_sec_attr_codes po_tbl_varchar30;
952: l_sec_attr_numbers po_tbl_number;
953: l_enterprise_name hz_parties.party_name%TYPE;
954: lv_exception_msg VARCHAR2(32000);
955: lv_status VARCHAR2(240);
956: l_itemtype wf_items.item_type%TYPE;
957: l_itemkey wf_items.item_key%TYPE;