[Home] [Help]
13: ,c_dimension_name IN Varchar2
14: ,c_business_group_id IN Number) IS
15: SELECT db.defined_balance_id
16: FROM pay_balance_types pbt
17: ,pay_defined_balances db
18: ,pay_balance_dimensions bd
19: WHERE pbt.balance_name = c_balance_name
20: AND pbt.balance_type_id = db.balance_type_id
21: AND bd.balance_dimension_id = db.balance_dimension_id
2117: ,c_dimension_name IN Varchar2
2118: ,c_business_group_id IN Number) IS
2119: SELECT db.defined_balance_id
2120: FROM pay_balance_types pbt
2121: ,pay_defined_balances db
2122: ,pay_balance_dimensions bd
2123: WHERE pbt.balance_name = c_balance_name
2124: AND pbt.balance_type_id = db.balance_type_id
2125: AND bd.balance_dimension_id = db.balance_dimension_id
3171: CURSOR c_def_bal_cur(c_dim_name IN pay_balance_dimensions.dimension_name%TYPE) IS
3172: select pdb.defined_balance_id
3173: from pay_balance_types pbt
3174: ,pay_balance_dimensions pbd
3175: ,pay_defined_balances pdb
3176: where balance_name = p_salary_balance_name
3177: and pbd.dimension_name = c_dim_name
3178: and pdb.balance_type_id = pbt.balance_type_id
3179: and pbd.balance_dimension_id = pdb.balance_dimension_id
4544: l_prev_run_year number;
4545: l_payroll_id pay_payrolls_f.payroll_id%type;
4546: l_asg_action_id pay_assignment_actions.assignment_action_id%type;
4547: l_time_period_id per_time_periods.time_period_id%type;
4548: l_defined_bal_id pay_defined_balances.defined_balance_id%type;
4549: l_start_date per_time_periods.start_date%type;
4550: l_end_date per_time_periods.end_date%type;
4551: l_periods_per_yr number := 1;
4552: l_ret_val number := 0;
4568: CURSOR c_get_defined_bal_id
4569: (c_balance_type_id IN pay_balance_types.balance_type_id%TYPE) IS
4570: SELECT pdb.defined_balance_id
4571: FROM pay_balance_dimensions pbd
4572: ,pay_defined_balances pdb
4573: WHERE pbd.dimension_name = 'Assignment Year To Date'
4574: AND pdb.balance_type_id = c_balance_type_id
4575: AND pbd.balance_dimension_id = pdb.balance_dimension_id
4576: AND pbd.legislation_code = 'NL';