[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
2052: ,c_dimension_name IN Varchar2
2053: ,c_business_group_id IN Number) IS
2054: SELECT db.defined_balance_id
2055: FROM pay_balance_types pbt
2056: ,pay_defined_balances db
2057: ,pay_balance_dimensions bd
2058: WHERE pbt.balance_name = c_balance_name
2059: AND pbt.balance_type_id = db.balance_type_id
2060: AND bd.balance_dimension_id = db.balance_dimension_id
3074: CURSOR c_def_bal_cur(c_dim_name IN pay_balance_dimensions.dimension_name%TYPE) IS
3075: select pdb.defined_balance_id
3076: from pay_balance_types pbt
3077: ,pay_balance_dimensions pbd
3078: ,pay_defined_balances pdb
3079: where balance_name = p_salary_balance_name
3080: and pbd.dimension_name = c_dim_name
3081: and pdb.balance_type_id = pbt.balance_type_id
3082: and pbd.balance_dimension_id = pdb.balance_dimension_id
4447: l_prev_run_year number;
4448: l_payroll_id pay_payrolls_f.payroll_id%type;
4449: l_asg_action_id pay_assignment_actions.assignment_action_id%type;
4450: l_time_period_id per_time_periods.time_period_id%type;
4451: l_defined_bal_id pay_defined_balances.defined_balance_id%type;
4452: l_start_date per_time_periods.start_date%type;
4453: l_end_date per_time_periods.end_date%type;
4454: l_periods_per_yr number := 1;
4455: l_ret_val number := 0;
4471: CURSOR c_get_defined_bal_id
4472: (c_balance_type_id IN pay_balance_types.balance_type_id%TYPE) IS
4473: SELECT pdb.defined_balance_id
4474: FROM pay_balance_dimensions pbd
4475: ,pay_defined_balances pdb
4476: WHERE pbd.dimension_name = 'Assignment Year To Date'
4477: AND pdb.balance_type_id = c_balance_type_id
4478: AND pbd.balance_dimension_id = pdb.balance_dimension_id
4479: AND pbd.legislation_code = 'NL';