APPS.PQP_EXCP_RPT dependencies on PAY_BALANCE_DIMENSIONS

Line 208: p_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE

204: --
205: -- Cursor to get the dimension name
206: --
207: CURSOR c_get_dimension_name(
208: p_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE
209: )
210: IS
211: select pbd.dimension_name dimension_name
212: from pay_balance_dimensions pbd,

Line 212: from pay_balance_dimensions pbd,

208: p_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE
209: )
210: IS
211: select pbd.dimension_name dimension_name
212: from pay_balance_dimensions pbd,
213: pay_defined_balances pdb,
214: pqp_exception_report_suffix ers
215: where pbd.database_item_suffix = ers.database_item_suffix
216: and ers.legislation_code = userenv('LANG')

Line 256: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;

252: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
253: l_consolidation_set_name pay_consolidation_sets.consolidation_set_name%TYPE;
254: l_balance_name pay_balance_types.balance_name%TYPE;
255: l_dimension_id pqp_exception_reports.balance_dimension_id%TYPE;
256: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
257: l_legislation_code per_business_groups.legislation_code%TYPE;
258: l_currency_code per_business_groups.currency_code%TYPE;
259: l_currency_format varchar2(40);
260: l_variance_value pqp_exception_reports.variance_value%TYPE;