APPS.PAY_IP_EMPLOYEE_BALANCES dependencies on PAY_BALANCE_DIMENSIONS

Line 75: bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,

71: ele_type_id pay_element_types_f.element_type_id%TYPE,
72: def_bal_id pay_defined_balances.defined_balance_id%TYPE,
73: bal_value NUMBER,
74: bal_type_id pay_balance_types.balance_type_id%TYPE,
75: bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,
76: defbal_type VARCHAR2(20));
77:
78: TYPE entity_details_tab IS TABLE OF rec_entity_details INDEX BY BINARY_INTEGER;
79: t_defbal_details_tab entity_details_tab;

Line 85: ptd_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,

81: TYPE ele_bal_details_rec IS RECORD
82: ( ele_name pay_element_types_f.element_name%TYPE,
83: ele_type_id pay_element_types_f.element_type_id%TYPE,
84: bal_type_id pay_balance_types.balance_type_id%TYPE,
85: ptd_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,
86: ptd_bal_value NUMBER,
87: mtd_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,
88: mtd_bal_value NUMBER,
89: qtd_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,

Line 87: mtd_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,

83: ele_type_id pay_element_types_f.element_type_id%TYPE,
84: bal_type_id pay_balance_types.balance_type_id%TYPE,
85: ptd_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,
86: ptd_bal_value NUMBER,
87: mtd_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,
88: mtd_bal_value NUMBER,
89: qtd_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,
90: qtd_bal_value NUMBER,
91: ytd_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,

Line 89: qtd_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,

85: ptd_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,
86: ptd_bal_value NUMBER,
87: mtd_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,
88: mtd_bal_value NUMBER,
89: qtd_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,
90: qtd_bal_value NUMBER,
91: ytd_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,
92: ytd_bal_value NUMBER,
93: arr_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,

Line 91: ytd_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,

87: mtd_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,
88: mtd_bal_value NUMBER,
89: qtd_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,
90: qtd_bal_value NUMBER,
91: ytd_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,
92: ytd_bal_value NUMBER,
93: arr_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,
94: arr_bal_value NUMBER,
95: acc_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,

Line 93: arr_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,

89: qtd_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,
90: qtd_bal_value NUMBER,
91: ytd_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,
92: ytd_bal_value NUMBER,
93: arr_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,
94: arr_bal_value NUMBER,
95: acc_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,
96: acc_bal_value NUMBER);
97:

Line 95: acc_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,

91: ytd_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,
92: ytd_bal_value NUMBER,
93: arr_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,
94: arr_bal_value NUMBER,
95: acc_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,
96: acc_bal_value NUMBER);
97:
98: TYPE ele_bal_details_tab IS TABLE OF ele_bal_details_rec INDEX BY BINARY_INTEGER;
99: t_ele_bal_horizontal_tab ele_bal_details_tab;