APPS.PQP_US_PENSION_EXTRACTS dependencies on PAY_BALANCE_DIMENSIONS

Line 9: g_asgrun_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

5: g_legislation_code per_business_groups.legislation_code%TYPE;
6: g_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
7: g_action_effective_date Date;
8: g_action_type Varchar2(50);
9: g_asgrun_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
10: g_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
11: g_business_group_id per_business_groups.business_group_id%TYPE;
12: g_person_id per_all_assignments_f.person_id%TYPE;
13: g_gre_tax_unit_id hr_all_organization_units.organization_id%TYPE;

Line 108: ,balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE

104: TYPE balance_details IS RECORD
105: ( balance_name pay_balance_types.balance_name%TYPE
106: ,balance_type_id pay_balance_types.balance_type_id%TYPE
107: ,defined_balance_id pay_defined_balances.defined_balance_id%TYPE
108: ,balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE
109: ,dimension_name pay_balance_dimensions.dimension_name%TYPE
110: );
111: TYPE t_balance_details IS TABLE OF balance_details INDEX BY Binary_Integer;
112: g_balance_detls t_balance_details;

Line 109: ,dimension_name pay_balance_dimensions.dimension_name%TYPE

105: ( balance_name pay_balance_types.balance_name%TYPE
106: ,balance_type_id pay_balance_types.balance_type_id%TYPE
107: ,defined_balance_id pay_defined_balances.defined_balance_id%TYPE
108: ,balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE
109: ,dimension_name pay_balance_dimensions.dimension_name%TYPE
110: );
111: TYPE t_balance_details IS TABLE OF balance_details INDEX BY Binary_Integer;
112: g_balance_detls t_balance_details;
113:

Line 115: ( dimension_name pay_balance_dimensions.dimension_name%TYPE

111: TYPE t_balance_details IS TABLE OF balance_details INDEX BY Binary_Integer;
112: g_balance_detls t_balance_details;
113:
114: TYPE balance_dimension IS RECORD
115: ( dimension_name pay_balance_dimensions.dimension_name%TYPE
116: ,balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE
117: );
118: TYPE t_balance_dim IS TABLE OF balance_dimension INDEX BY Binary_Integer;
119: g_balance_dim t_balance_dim;

Line 116: ,balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE

112: g_balance_detls t_balance_details;
113:
114: TYPE balance_dimension IS RECORD
115: ( dimension_name pay_balance_dimensions.dimension_name%TYPE
116: ,balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE
117: );
118: TYPE t_balance_dim IS TABLE OF balance_dimension INDEX BY Binary_Integer;
119: g_balance_dim t_balance_dim;
120: