Search Results payment_method




Overview
Explore in AI Chat

Overview

The HRFV_PAY_METH_NOT_DIR_DEPOSITS view is an Oracle E-Business Suite flexfield business view template owned by the APPS schema in the PER (Human Resources) product. It belongs to the family of "HRFV" (Human Resources Flexfield View) objects, which are business view templates from which runtime flexfield views are generated. Its specific purpose is to expose personal payment methods that are not direct deposits — that is, payment methods whose external account identifier is null, as enforced by the predicate PPM.EXTERNAL_ACCOUNT_ID IS NULL. Through this restriction the view isolates payees who are paid by org payment methods unrelated to externally held bank accounts, making it useful for payroll and HR reporting on alternative disbursement arrangements.

The view joins payee definitions across organizations, persons, and assignments, presenting a consolidated, denormalized picture of payment method usage. Because it is a flexfield-based view template, its column list and predicate logic are intended to be consumed by the flexfield generator, but the underlying SQL remains accessible for ad-hoc reporting and integration.

Underlying Base Objects

The view text identifies the principal base tables and their join relationships. PAY_PERSONAL_PAYMENT_METHODS_F (aliased PPM) is the driving table, joined to PAY_ORG_PAYMENT_METHODS_F (OPM) on ORG_PAYMENT_METHOD_ID, then to PAY_PAYMENT_TYPES_TL (PTT) on PAYMENT_TYPE_ID restricted by USERENV('LANG'). Assignment and person data come from PER_ASSIGNMENTS_X (PA) and PER_PEOPLE_X (PER). Organizational name columns are resolved through multiple aliases of HR_ALL_ORGANIZATION_UNITS_TL — PORGT for organizational payee, ORGT for the assignment organization, and BGRT for the business group.

The documented base objects also include PER_JOBS_TL, PER_GRADES_TL, HR_POSITIONS_F_TL, and HR_LOCATIONS_ALL_TL, which supply job, grade, position, and location descriptors. Packages HR_BIS, HR_DISCOVERER, HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY provide lookup decoding, end-date adjustment, and security/name formatting logic used inside the SELECT clause.

Key Columns

The view projects both identifying and descriptive attributes. Notable columns include:

Common Use Cases and Queries

Typical uses include auditing non-direct-deposit payment methods, reconciliation of payroll disbursements by payee type, and extracting payment method utilization by organization or assignment. A representative query is:

  • SELECT PERSON_NAME, EMPLOYEE_NUMBER, PAYMENT_METHOD, PAYMENT_TYPE, AMOUNT, PERCENTAGE FROM HRFV_PAY_METH_NOT_DIR_DEPOSITS;
  • SELECT ORGANIZATION_NAME, PAYEE_TYPE, PAYEE_NAME, PAYMENT_METHOD FROM HRFV_PAY_METH_NOT_DIR_DEPOSITS WHERE EFFECTIVE_END_DATE >= TRUNC(SYSDATE);
  • SELECT CURRENCY_CODE, COUNT(*), SUM(AMOUNT) FROM HRFV_PAY_METH_NOT_DIR_DEPOSITS GROUP BY CURRENCY_CODE;

Because the view incorporates HR_SECURITY, queries respect the caller's security profile, making it suitable for secured HR reporting. Users should also be aware that the ORGT, PORGT, and BGRT joins to HR_ALL_ORGANIZATION_UNITS_TL assume USERENV('LANG') alignment, so language settings in the session affect returned descriptions.