DBA Data[Home] [Help]

APPS.PAY_NO_EERR_CONTINUOUS dependencies on HR_GENERAL

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

2544: l_retrospective_date <> l_detailed_output (cnt).effective_date
2545: and l_detailed_output (cnt).dated_table_id = l_table3 then /* 5519729 and 5525683 */
2546: l_emp_end_date := j.emp_end_date ;
2547: l_eff_end_date_need := 'Y';
2548: if l_detailed_output(cnt).effective_date <> trunc(hr_general.end_of_time) then
2549: for cont in l_detailed_output.first .. l_detailed_output.last
2550: loop
2551: if l_detailed_output (cont).column_name = 'ASSIGNMENT_STATUS_TYPE_ID'
2552: and l_detailed_output(cont).effective_date = (l_emp_end_date + 1) then

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

2558: if l_corr_change_flag = 'M' then
2559: collemptable (4).temination_date := l_emp_end_date;
2560: collemptable (4).value_flag := 'Y';
2561: else
2562: If l_emp_end_date is null or l_detailed_output(cnt).effective_date = trunc(hr_general.end_of_time) then
2563: l_emp_end_date := null;
2564: collemptable (3).rev_temination := '--------' ;
2565: end if;
2566: If l_detailed_output(cnt).effective_date < g_start_date then

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

2570: else
2571: l_old_date := null ;
2572: l_old_date :=substr (l_detailed_output (cnt).change_values,0,
2573: instr (l_detailed_output (cnt).change_values,'->')- 1 );
2574: if l_detailed_output(cnt).effective_date = trunc(hr_general.end_of_time) and
2575: l_old_date < g_start_date then
2576: collemptable (3).temination_date :=l_emp_end_date;
2577: collemptable (3).start_date := l_empl_start_date;
2578: collemptable (3).value_flag := 'Y';