APPS.PAY_CA_USER_INIT_EARN dependencies on PAY_BALANCE_DIMENSIONS

Line 256: FROM pay_balance_dimensions

252: prt.shortname like 'LS_T4%' );
253:
254: CURSOR get_asg_gre_run_dim_id IS
255: SELECT balance_dimension_id
256: FROM pay_balance_dimensions
257: WHERE dimension_name = 'Assignment within Government Reporting Entity Run'
258: AND legislation_code = 'CA';
259:
260: CURSOR get_asg_jd_gre_run_dim_id IS

Line 262: FROM pay_balance_dimensions

258: AND legislation_code = 'CA';
259:
260: CURSOR get_asg_jd_gre_run_dim_id IS
261: SELECT balance_dimension_id
262: FROM pay_balance_dimensions
263: WHERE dimension_name = 'Assignment in JD within GRE Run'
264: AND legislation_code = 'CA';
265:
266: l_asg_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

Line 266: l_asg_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

262: FROM pay_balance_dimensions
263: WHERE dimension_name = 'Assignment in JD within GRE Run'
264: AND legislation_code = 'CA';
265:
266: l_asg_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
267: l_asg_jd_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
268:
269: --
270: -- Hours by Rate Variables

Line 267: l_asg_jd_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

263: WHERE dimension_name = 'Assignment in JD within GRE Run'
264: AND legislation_code = 'CA';
265:
266: l_asg_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
267: l_asg_jd_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
268:
269: --
270: -- Hours by Rate Variables
271: --