APPS.PAY_GB_EOY_ARCHIVE dependencies on HR_GENERAL

Line 229: paye_eff_date DATE := hr_general.start_of_time,

225: widows NUMBER(15) := 0,
226: taxable NUMBER(15) := 0,
227: student_ln NUMBER(15) := 0,
228: ni_arrears NUMBER(15) := 0,
229: paye_eff_date DATE := hr_general.start_of_time,
230: tax_code VARCHAR2(10) := NULL,
231: tax_basis VARCHAR(1) := NULL,
232: pay_previous NUMBER(15) := 0,
233: tax_previous NUMBER(15) := 0,

Line 649: g_min_start_year := hr_general.end_of_time;

645: --
646: BEGIN
647: --
648: -- Default start/end year globals
649: g_min_start_year := hr_general.end_of_time;
650: g_max_end_year := hr_general.start_of_time;
651: --
652: FOR payroll_rec in get_payroll_id(p_payroll_action_id,p_permit_ueid) LOOP
653: --

Line 650: g_max_end_year := hr_general.start_of_time;

646: BEGIN
647: --
648: -- Default start/end year globals
649: g_min_start_year := hr_general.end_of_time;
650: g_max_end_year := hr_general.start_of_time;
651: --
652: FOR payroll_rec in get_payroll_id(p_payroll_action_id,p_permit_ueid) LOOP
653: --
654: g_payroll_end_yr_tab(payroll_rec.payroll_id) :=

Line 3517: substr(hr_general.decode_lookup('GB_SCON',

3513: /*cursor csr_get_scon_bal(cp_l_asg_id NUMBER, cp_scon_inp_val NUMBER,
3514: cp_cat_inp_val NUMBER, cp_element_type NUMBER) IS
3515: SELECT /*+ RULE
3516: substr(bal.balance_name,4,1) cat_code,
3517: substr(hr_general.decode_lookup('GB_SCON',
3518: decode(substr(bal.balance_name,4,1),
3519: 'F',nvl(max(decode(ev_cat.screen_entry_value,
3520: 'F',ev_scon.screen_entry_value)),
3521: pay_gb_eoy_archive.get_nearest_scon(

Line 3672: substr(hr_general.decode_lookup('GB_SCON',scon.screen_entry_value)

3668: /*EOY 2012/2013 begin block*/
3669: /* cursor csr_current_cat(p_asgid NUMBER, l_asg_end DATE,
3670: p_end_year DATE) IS
3671: SELECT v.screen_entry_value ni_cat,
3672: substr(hr_general.decode_lookup('GB_SCON',scon.screen_entry_value)
3673: ,1,9) ni_scon
3674: FROM pay_element_entries_f e,
3675: pay_element_entry_values_f v,
3676: pay_element_entry_values_f scon,

Line 4602: IF l_agg_active_end < least(nvl(l_actual_termination_date, hr_general.end_of_time), g_end_year) THEN

4598: IF l_multiple_asg_flag = 'Y' THEN
4599: -- for multiple assignment check if aggregated active end date
4600: -- is before the actual termination date and EOY, if yes then set
4601: -- termination date to aggregated active end date
4602: IF l_agg_active_end < least(nvl(l_actual_termination_date, hr_general.end_of_time), g_end_year) THEN
4603: l_termination_date := l_agg_active_end;
4604: END IF;
4605: ELSE
4606: -- for non aggregated assignments check if this assignments

Line 4610: IF l_active_end < least(nvl(l_actual_termination_date, hr_general.end_of_time), g_end_year) THEN

4606: -- for non aggregated assignments check if this assignments
4607: -- active end date is before the actual termination date and EOY, if
4608: -- yes then set termination date to this assignment's active
4609: -- end date
4610: IF l_active_end < least(nvl(l_actual_termination_date, hr_general.end_of_time), g_end_year) THEN
4611: l_termination_date := l_active_end;
4612: END IF;
4613: END IF;
4614: --

Line 5314: IF nvl(l_week_53_start, hr_general.end_of_time) <= l_active_end THEN

5310: CLOSE get_week_53_start;
5311: --
5312: hr_utility.trace('After get_week_53_start, l_week_53_start='||
5313: fnd_date.date_to_displaydate(l_week_53_start));
5314: IF nvl(l_week_53_start, hr_general.end_of_time) <= l_active_end THEN
5315: l_week_53_indicator := substr(to_char(l_payroll_max_period_number),2,1);
5316: END IF;
5317: else
5318: l_week_53_indicator := ' ';