APPS.BEN_EXT_PAYROLL_BALANCE dependencies on PAY_BALANCE_DIMENSIONS

Line 48: ,pay_balance_dimensions pbd

44: select pbd.DIMENSION_NAME
45: from ff_contexts ffc
46: ,ff_route_context_usages frc
47: ,pay_defined_balances pdb
48: ,pay_balance_dimensions pbd
49: where pdb.defined_balance_id = p_defined_balance_id
50: and pdb.balance_dimension_id = pbd.balance_dimension_id
51: and pbd.route_id = frc.route_id
52: and frc.context_id = ffc.context_id

Line 59: l_DIMENSION_NAME pay_balance_dimensions.DIMENSION_NAME%type ;

55:
56: l_balance_amount number;
57: l_gre_id number;
58: l_jurisdiction_code varchar2(150);
59: l_DIMENSION_NAME pay_balance_dimensions.DIMENSION_NAME%type ;
60:
61: l_proc_name constant varchar2(150) := g_package ||'Get_us_Balance_Value';
62:
63: begin