APPS.PAY_NO_EERR_CONTINUOUS dependencies on HR_GENERAL

Line 2735: if l_detailed_output(cnt).effective_date <> trunc(hr_general.end_of_time) then

2731: l_retrospective_date <> l_detailed_output (cnt).effective_date
2732: and l_detailed_output (cnt).dated_table_id = l_table3 then /* 5519729 and 5525683 */
2733: l_emp_end_date := j.emp_end_date ;
2734: l_eff_end_date_need := 'Y';
2735: if l_detailed_output(cnt).effective_date <> trunc(hr_general.end_of_time) then
2736: for cont in l_detailed_output.first .. l_detailed_output.last
2737: loop
2738: if l_detailed_output (cont).column_name = 'ASSIGNMENT_STATUS_TYPE_ID'
2739: and l_detailed_output(cont).effective_date = (l_emp_end_date + 1) then

Line 2749: If l_emp_end_date is null or l_detailed_output(cnt).effective_date = trunc(hr_general.end_of_time) then

2745: if l_corr_change_flag = 'M' then
2746: collemptable (4).temination_date := l_emp_end_date;
2747: collemptable (4).value_flag := 'Y';
2748: else
2749: If l_emp_end_date is null or l_detailed_output(cnt).effective_date = trunc(hr_general.end_of_time) then
2750: l_emp_end_date := null;
2751: collemptable (3).rev_temination := '--------' ;
2752: end if;
2753: If l_detailed_output(cnt).effective_date < g_start_date then

Line 2761: if l_detailed_output(cnt).effective_date = trunc(hr_general.end_of_time) and

2757: else
2758: l_old_date := null ;
2759: l_old_date :=substr (l_detailed_output (cnt).change_values,0,
2760: instr (l_detailed_output (cnt).change_values,'->')- 1 );
2761: if l_detailed_output(cnt).effective_date = trunc(hr_general.end_of_time) and
2762: l_old_date < g_start_date then
2763: collemptable (3).temination_date :=l_emp_end_date;
2764: collemptable (3).start_date := l_empl_start_date;
2765: collemptable (3).value_flag := 'Y';