APPS.PAY_CA_USER_INIT_EARN dependencies on PAY_BALANCE_DIMENSIONS

Line 261: FROM pay_balance_dimensions

257: prt.shortname like 'LS_T4%' );
258:
259: CURSOR get_asg_gre_run_dim_id IS
260: SELECT balance_dimension_id
261: FROM pay_balance_dimensions
262: WHERE dimension_name = 'Assignment within Government Reporting Entity Run'
263: AND legislation_code = 'CA';
264:
265: CURSOR get_asg_jd_gre_run_dim_id IS

Line 267: FROM pay_balance_dimensions

263: AND legislation_code = 'CA';
264:
265: CURSOR get_asg_jd_gre_run_dim_id IS
266: SELECT balance_dimension_id
267: FROM pay_balance_dimensions
268: WHERE dimension_name = 'Assignment in JD within GRE Run'
269: AND legislation_code = 'CA';
270:
271: l_asg_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

Line 271: l_asg_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

267: FROM pay_balance_dimensions
268: WHERE dimension_name = 'Assignment in JD within GRE Run'
269: AND legislation_code = 'CA';
270:
271: l_asg_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
272: l_asg_jd_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
273:
274: --
275: -- Hours by Rate Variables

Line 272: l_asg_jd_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

268: WHERE dimension_name = 'Assignment in JD within GRE Run'
269: AND legislation_code = 'CA';
270:
271: l_asg_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
272: l_asg_jd_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
273:
274: --
275: -- Hours by Rate Variables
276: --