APPS.PQP_PENSION_EXTRACTS dependencies on PAY_BALANCE_DIMENSIONS

Line 4042: FROM pay_balance_dimensions

4038: -- Get the Assignment Run level dimension id
4039: CURSOR csr_asg_dimId(c_legislation_code IN VARCHAR2
4040: ,c_dimension_name IN VARCHAR2 ) IS
4041: SELECT balance_dimension_id
4042: FROM pay_balance_dimensions
4043: WHERE legislation_code = c_legislation_code
4044: AND dimension_name = c_dimension_name;
4045:
4046: -- Get the Legislation Code and Curreny Code

Line 4142: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;

4138: l_proc_name VARCHAR2(150) := g_proc_name ||'Pension_Criteria_Full_Profile';
4139: l_assig_rec csr_assig%ROWTYPE;
4140: l_valid_person_chk VARCHAR2(2);
4141: l_Chg_Evt_Exists VARCHAR2(2);
4142: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
4143: BEGIN
4144:
4145: hr_utility.set_location('Entering: '||l_proc_name, 5);
4146: i := p_business_group_id;