APPS.PQP_US_SRS_EXTRACTS dependencies on PAY_BALANCE_TYPES

Line 464: ,p_balance_name In pay_balance_types.balance_name%TYPE

460: -- ~ any given balance and the dimension is based the extract running i.e. YTD,QTD ~
461: -- ~ or MTD and is set in the main criteria function Pay_US_SRS_Main_Criteria ~
462: -- =================================================================================
463: Function Get_SRS_Deduction_Balances (p_assignment_id In per_all_assignments_f.assignment_id%TYPE -- context
464: ,p_balance_name In pay_balance_types.balance_name%TYPE
465: ,p_balance_amount In out nocopy Number
466: ) Return Number Is
467:
468: Cursor c_tax_id ( c_assignment_id In per_all_assignments_f.assignment_id%Type

Line 481: l_balance_name pay_balance_types.balance_name%TYPE;

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;
485: l_proc_name varchar2(150) := g_proc_name ||'.Get_SRS_Deduction_Balances';