APPS.PQP_EARNINGS_TEMPLATE dependencies on PAY_BALANCE_DIMENSIONS

Line 71: l_asg_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

67: l_template_id number;
68: --
69: l_proc varchar2(80) := 'pqp_earnings_template.create_ele_template_objects';
70:
71: l_asg_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
72:
73: --
74: -- cursor to fetch the new element type id
75: --

Line 116: FROM pay_balance_dimensions

112: */
113:
114: CURSOR get_asg_gre_run_dim_id IS
115: SELECT balance_dimension_id
116: FROM pay_balance_dimensions
117: WHERE dimension_name = 'Assignment within Government Reporting Entity Run'
118: AND legislation_code = 'US';
119:
120: --