eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PSP_SUM_ADJ dependencies on PSP_ADJUSTMENT_LINES_HISTORY

Line 599: psp_adjustment_lines_history palh,

595: DECODE(g_dff_grouping_option, 'Y', pal.attribute8, NULL) attribute8,
596: DECODE(g_dff_grouping_option, 'Y', pal.attribute9, NULL) attribute9,
597: DECODE(g_dff_grouping_option, 'Y', pal.attribute10, NULL) attribute10
598: FROM psp_adjustment_lines pal,
599: psp_adjustment_lines_history palh,
600: psp_summary_lines psl
601: WHERE pal.status_code = 'N'
602: AND pal.gl_code_combination_id is not null
603: AND pal.payroll_control_id = p_payroll_control_id

Line 1787: -- move the transferred records to psp_adjustment_lines_history

1783:
1784: UPDATE psp_adjustment_lines
1785: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
1786:
1787: -- move the transferred records to psp_adjustment_lines_history
1788: INSERT INTO psp_adjustment_lines_history
1789: (adjustment_line_id,person_id,assignment_id,element_type_id,
1790: distribution_date,effective_date,distribution_amount,
1791: dr_cr_flag,payroll_control_id,source_type,source_code,time_period_id,

Line 1788: INSERT INTO psp_adjustment_lines_history

1784: UPDATE psp_adjustment_lines
1785: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
1786:
1787: -- move the transferred records to psp_adjustment_lines_history
1788: INSERT INTO psp_adjustment_lines_history
1789: (adjustment_line_id,person_id,assignment_id,element_type_id,
1790: distribution_date,effective_date,distribution_amount,
1791: dr_cr_flag,payroll_control_id,source_type,source_code,time_period_id,
1792: batch_name,status_code,set_of_books_id,gl_code_combination_id,project_id,

Line 2331: psp_adjustment_lines_history pal2,

2327: DECODE(g_dff_grouping_option, 'Y', pal.attribute8, NULL) attribute8,
2328: DECODE(g_dff_grouping_option, 'Y', pal.attribute9, NULL) attribute9,
2329: DECODE(g_dff_grouping_option, 'Y', pal.attribute10, NULL) attribute10
2330: FROM psp_adjustment_lines pal,
2331: psp_adjustment_lines_history pal2,
2332: psp_summary_lines psl
2333: WHERE pal.status_code = 'N'
2334: AND pal.gl_code_combination_id IS NULL
2335: AND pal.payroll_control_id = p_payroll_control_id

Line 3798: -- move the transferred records to psp_adjustment_lines_history

3794:
3795: UPDATE psp_adjustment_lines
3796: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
3797:
3798: -- move the transferred records to psp_adjustment_lines_history
3799: INSERT INTO psp_adjustment_lines_history
3800: (adjustment_line_id,person_id,assignment_id,element_type_id,
3801: distribution_date,effective_date,distribution_amount,
3802: dr_cr_flag,payroll_control_id,source_type,source_code,time_period_id,

Line 3799: INSERT INTO psp_adjustment_lines_history

3795: UPDATE psp_adjustment_lines
3796: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
3797:
3798: -- move the transferred records to psp_adjustment_lines_history
3799: INSERT INTO psp_adjustment_lines_history
3800: (adjustment_line_id,person_id,assignment_id,element_type_id,
3801: distribution_date,effective_date,distribution_amount,
3802: dr_cr_flag,payroll_control_id,source_type,source_code,time_period_id,
3803: batch_name,status_code,set_of_books_id,gl_code_combination_id,project_id,

Line 4021: FROM psp_adjustment_lines_history palh,

4017: AND pal.reversal_entry_flag IS NULL
4018: UNION ALL -- added hist table for 2133056
4019: SELECT palh.orig_source_type,
4020: palh.orig_line_id
4021: FROM psp_adjustment_lines_history palh,
4022: psp_payroll_controls ppc
4023: WHERE palh.reversal_entry_flag IS NULL
4024: AND ppc.source_type ='A'
4025: AND ppc.batch_name = p_batch_name

Line 4190: update psp_adjustment_lines_history

4186: update psp_pre_gen_dist_lines_history
4187: set adjustment_batch_name = NULL
4188: where pre_gen_dist_line_id = adj_batch_rec.orig_line_id;
4189: elsif adj_batch_rec.orig_source_type = 'A' then
4190: update psp_adjustment_lines_history
4191: set adjustment_batch_name = NULL
4192: where adjustment_line_id = adj_batch_rec.orig_line_id;
4193: end if;
4194: end loop;

Line 4196: delete from psp_adjustment_lines_history

4192: where adjustment_line_id = adj_batch_rec.orig_line_id;
4193: end if;
4194: end loop;
4195:
4196: delete from psp_adjustment_lines_history
4197: where payroll_control_id in --- Corrected this statment 2133056
4198: ( SELECT ppc.payroll_control_id
4199: FROM psp_payroll_controls ppc
4200: WHERE ppc.batch_name = l_batch_name