Search Results pay_in_tax_declarations_v




Overview
Explore in AI Chat

Overview

The PAY_IN_TAX_DECLARATIONS_V view is a payroll reporting object owned by the APPS schema within the Oracle E-Business Suite PAY – Payroll product family. It is a VALID database view in both EBS 12.1.1 and 12.2.2. The view is purpose-built for the Indian statutory payroll localization, presenting consolidated employee, assignment, and tax declaration information required for investment and tax declaration reporting under the India Payroll module.

Functionally, the view aggregates person-level identity data together with assignment attributes, organization unit details, extra information types, and month-wise house rent declaration amounts. Because much of its logic is delivered through calls to the PAY_IN_TAX_DECLARATION package, the view serves primarily as a reporting and integration layer rather than a pure denormalized snapshot. It is typically consumed by statutory returns, employee tax declaration reports, and downstream integration extracts that need tax declaration values mapped to a specific reporting year beginning in April, consistent with the Indian fiscal calendar.

Underlying Base Objects

The ETRM 12.2.2 metadata documents that the view is defined over the following base objects:

Several PL/SQL components are also referenced: PAY_IN_TAX_DECLARATION (the core package driving the month-wise declaration logic), along with FND_DATE, HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY, which provide date handling, name formatting, and security-based row filtering.

Key Columns

The view exposes a flat projection combining identity, assignment, and declaration attributes. Notable columns include:

Common Use Cases and Queries

This view is most commonly used for Indian tax declaration reporting, house rent reconciliation, and employee-level statutory extracts. A representative query retrieves an employee's annual house rent declarations:

SELECT person_id, full_name, employee_number, april, may, june, july, august, september, october, november, december, january, february, march
FROM apps.pay_in_tax_declarations_v
WHERE employee_number = :p_emp_num;

Typical scenarios include generating proof-of-investment statements, validating declared house rent against payroll deductions, and feeding tax computation processes. Because row-level access is governed by HR_SECURITY, results are automatically restricted to the querying user's security profile, making the view suitable for both administrative and self-service reporting contexts.