APPS.PQP_US_PENSION_EXTRACTS dependencies on PAY_BALANCE_DIMENSIONS

Line 88: FROM pay_balance_dimensions pbd

84: CURSOR csr_dim (c_dimension_name IN VARCHAR2
85: ,c_bg_id IN NUMBER
86: ,c_leg_code IN VARCHAR2) IS
87: SELECT pbd.balance_dimension_id
88: FROM pay_balance_dimensions pbd
89: WHERE pbd.dimension_name = c_dimension_name
90: AND (pbd.business_group_id = c_bg_id OR
91: pbd.legislation_code = c_leg_code);
92: --

Line 102: ,pay_balance_dimensions bd

98: ,c_business_group_id IN NUMBER) IS
99: SELECT db.defined_balance_id
100: FROM pay_balance_types pbt
101: ,pay_defined_balances db
102: ,pay_balance_dimensions bd
103: WHERE pbt.balance_name = c_balance_name
104: AND pbt.balance_type_id = db.balance_type_id
105: AND bd.balance_dimension_id = db.balance_dimension_id
106: AND bd.dimension_name = c_dimension_name

Line 4423: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;

4419:
4420: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
4421: l_balance_amount NUMBER :=0;
4422: l_bal_total_amt NUMBER :=0;
4423: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
4424: i per_all_assignments_f.business_group_id%TYPE;
4425: l_legislation_code per_business_groups.legislation_code%TYPE;
4426: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
4427: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;

Line 4427: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;

4423: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
4424: i per_all_assignments_f.business_group_id%TYPE;
4425: l_legislation_code per_business_groups.legislation_code%TYPE;
4426: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
4427: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
4428: l_new_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
4429: l_index NUMBER;
4430: l_assignment_action_id pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE;
4431: l_yr_end_date DATE;

Line 4428: l_new_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

4424: i per_all_assignments_f.business_group_id%TYPE;
4425: l_legislation_code per_business_groups.legislation_code%TYPE;
4426: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
4427: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
4428: l_new_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
4429: l_index NUMBER;
4430: l_assignment_action_id pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE;
4431: l_yr_end_date DATE;
4432: l_yr_start_date DATE;

Line 4925: FROM pay_balance_dimensions

4921:
4922: -- Get the Assignment Run level dimension id
4923: CURSOR csr_asg_dimId(c_legislation_code IN VARCHAR2) IS
4924: SELECT balance_dimension_id
4925: FROM pay_balance_dimensions
4926: WHERE legislation_code = c_legislation_code
4927: AND dimension_name = 'Assignment-Level Current Run';
4928:
4929: -- Check the eligibility to the person enrolled for pension for passed values.