APPS.PAY_US_EARNINGS_TEMPLATE dependencies on PAY_BALANCE_DIMENSIONS

Line 47: l_asg_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

43: t_form_id TypeIdNumber;
44: t_ipv_id TypeIdNumber;
45: t_def_val TypeIdChar;
46: t_we_flag TypeIdChar;
47: l_asg_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
48:
49: l_config2_amt CHAR(1) := 'N';
50: l_config3_perc CHAR(1) := 'N';
51: l_config4_hr CHAR(1) := 'N';

Line 129: FROM pay_balance_dimensions

125: -- AS per US Payroll Team request
126:
127: CURSOR get_asg_gre_run_dim_id IS
128: SELECT balance_dimension_id
129: FROM pay_balance_dimensions
130: WHERE dimension_name = 'Assignment within Government Reporting Entity Run'
131: AND legislation_code = 'US';
132:
133: CURSOR c_get_shadow_formula(p_formula_name IN VARCHAR) IS