APPS.PAY_PAP_BUS dependencies on PAY_BALANCE_DIMENSIONS

Line 735: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;

731:
732: l_proc VARCHAR2(72) := g_package||'chk_defined_balance_id';
733: l_accrual_formula ff_formulas_f.formula_name%TYPE;
734: l_api_updating BOOLEAN;
735: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
736: l_balance_type hr_organization_information.org_information1%TYPE;
737:
738: --
739: -- Get the balance dimension given the defined balance.

Line 743: FROM pay_balance_dimensions pbd

739: -- Get the balance dimension given the defined balance.
740: --
741: CURSOR csr_get_dim_name IS
742: SELECT pbd.dimension_name
743: FROM pay_balance_dimensions pbd
744: ,pay_defined_balances pdb
745: WHERE pdb.defined_balance_id = p_defined_balance_id
746: AND pdb.balance_dimension_id = pbd.balance_dimension_id;
747: