APPS.PQP_US_SRS_EXTRACTS dependencies on PAY_DEFINED_BALANCES

Line 33: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

29: ,p_balance_name In varchar2
30: ,p_dimension_name In varchar2) Return Number As
31:
32: l_balance_amount Number;
33: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
34: l_proc_name varchar2(150) := g_proc_name ||'Get_Balance_Value';
35: l_error varchar2(500);
36: Begin
37: hr_utility.set_location('Entering: '||l_proc_name, 5);

Line 480: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

476: And c_effective_date between asg.effective_start_date
477: and asg.effective_end_date;
478:
479: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
480: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
481: l_balance_name pay_balance_types.balance_name%TYPE;
482: l_effective_date date;
483: l_balance_amount Number := 0;
484: l_return_value Number := 0;