DBA Data[Home] [Help]

APPS.PAY_IP_PAYROLL_ARCH dependencies on PAY_BALANCE_DIMENSIONS

Line 11: gv_ytd_balance_dimension pay_balance_dimensions.database_item_suffix%TYPE;

7: ******************************************************************************/
8: gv_package VARCHAR2(100);
9: gn_gross_earn_def_bal_id NUMBER := 0;
10: gn_payments_def_bal_id NUMBER := 0;
11: gv_ytd_balance_dimension pay_balance_dimensions.database_item_suffix%TYPE;
12: gv_is_tax_unit_enabled VARCHAR2(1);
13:
14: dbt DEF_BAL_TBL;
15:

Line 2701: pay_balance_dimensions pbd,

2697: max(pbad.attribute_name) attribute_name
2698: FROM pay_bal_attribute_definitions pbad,
2699: pay_balance_attributes pba,
2700: pay_defined_balances pdb,
2701: pay_balance_dimensions pbd,
2702: pay_balance_types_tl pbtl
2703: WHERE pbad.attribute_name IN ('ONLINE_SOE_BALANCE_ATTRIBUTE','STATUTORY_BALANCE_ATTRIBUTE')
2704: AND pbad.legislation_code = gv_legislation_code
2705: AND pba.attribute_id = pbad.attribute_id