APPS.PAY_PAP_BUS dependencies on PAY_BALANCE_DIMENSIONS

Line 709: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;

705:
706: l_proc VARCHAR2(72) := g_package||'chk_defined_balance_id';
707: l_accrual_formula ff_formulas_f.formula_name%TYPE;
708: l_api_updating BOOLEAN;
709: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
710: l_balance_type hr_organization_information.org_information1%TYPE;
711:
712: --
713: -- Get the balance dimension given the defined balance.

Line 717: FROM pay_balance_dimensions pbd

713: -- Get the balance dimension given the defined balance.
714: --
715: CURSOR csr_get_dim_name IS
716: SELECT pbd.dimension_name
717: FROM pay_balance_dimensions pbd
718: ,pay_defined_balances pdb
719: WHERE pdb.defined_balance_id = p_defined_balance_id
720: AND pdb.balance_dimension_id = pbd.balance_dimension_id;
721: