APPS.PAY_GB_EOY_ARCHIVE dependencies on HR_GENERAL

Line 206: paye_eff_date DATE := hr_general.start_of_time,

202: widows NUMBER(15) := 0,
203: taxable NUMBER(15) := 0,
204: student_ln NUMBER(15) := 0,
205: ni_arrears NUMBER(15) := 0,
206: paye_eff_date DATE := hr_general.start_of_time,
207: tax_code VARCHAR2(10) := NULL,
208: tax_basis VARCHAR(1) := NULL,
209: pay_previous NUMBER(15) := 0,
210: tax_previous NUMBER(15) := 0,

Line 625: g_min_start_year := hr_general.end_of_time;

621: --
622: BEGIN
623: --
624: -- Default start/end year globals
625: g_min_start_year := hr_general.end_of_time;
626: g_max_end_year := hr_general.start_of_time;
627: --
628: FOR payroll_rec in get_payroll_id(p_payroll_action_id,p_permit_ueid) LOOP
629: --

Line 626: g_max_end_year := hr_general.start_of_time;

622: BEGIN
623: --
624: -- Default start/end year globals
625: g_min_start_year := hr_general.end_of_time;
626: g_max_end_year := hr_general.start_of_time;
627: --
628: FOR payroll_rec in get_payroll_id(p_payroll_action_id,p_permit_ueid) LOOP
629: --
630: g_payroll_end_yr_tab(payroll_rec.payroll_id) :=

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

3383: cursor csr_get_scon_bal(cp_l_asg_id NUMBER, cp_scon_inp_val NUMBER,
3384: cp_cat_inp_val NUMBER, cp_element_type NUMBER) IS
3385: SELECT /*+ RULE */
3386: substr(bal.balance_name,4,1) cat_code,
3387: substr(hr_general.decode_lookup('GB_SCON',
3388: decode(substr(bal.balance_name,4,1),
3389: 'F',nvl(max(decode(ev_cat.screen_entry_value,
3390: 'F',ev_scon.screen_entry_value)),
3391: pay_gb_eoy_archive.get_nearest_scon(

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

3530: --
3531: cursor csr_current_cat(p_asgid NUMBER, l_asg_end DATE,
3532: p_end_year DATE) IS
3533: SELECT v.screen_entry_value ni_cat,
3534: substr(hr_general.decode_lookup('GB_SCON',scon.screen_entry_value)
3535: ,1,9) ni_scon
3536: FROM pay_element_entries_f e,
3537: pay_element_entry_values_f v,
3538: pay_element_entry_values_f scon,

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

4413: IF l_multiple_asg_flag = 'Y' THEN
4414: -- for multiple assignment check if aggregated active end date
4415: -- is before the actual termination date and EOY, if yes then set
4416: -- termination date to aggregated active end date
4417: IF l_agg_active_end < least(nvl(l_actual_termination_date, hr_general.end_of_time), g_end_year) THEN
4418: l_termination_date := l_agg_active_end;
4419: END IF;
4420: ELSE
4421: -- for non aggregated assignments check if this assignments

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

4421: -- for non aggregated assignments check if this assignments
4422: -- active end date is before the actual termination date and EOY, if
4423: -- yes then set termination date to this assignment's active
4424: -- end date
4425: IF l_active_end < least(nvl(l_actual_termination_date, hr_general.end_of_time), g_end_year) THEN
4426: l_termination_date := l_active_end;
4427: END IF;
4428: END IF;
4429: --

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

5093: CLOSE get_week_53_start;
5094: --
5095: hr_utility.trace('After get_week_53_start, l_week_53_start='||
5096: fnd_date.date_to_displaydate(l_week_53_start));
5097: IF nvl(l_week_53_start, hr_general.end_of_time) <= l_active_end THEN
5098: l_week_53_indicator := substr(to_char(l_payroll_max_period_number),2,1);
5099: END IF;
5100: else
5101: l_week_53_indicator := ' ';