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.

APPS.PSP_SUM_ADJ dependencies on PSP_ADJUSTMENT_LINES_HISTORY

Line 675: psp_adjustment_lines_history palh,

671: DECODE(g_dff_grouping_option, 'Y', pal.attribute8, NULL) attribute8,
672: DECODE(g_dff_grouping_option, 'Y', pal.attribute9, NULL) attribute9,
673: DECODE(g_dff_grouping_option, 'Y', pal.attribute10, NULL) attribute10
674: FROM psp_adjustment_lines pal,
675: psp_adjustment_lines_history palh,
676: psp_summary_lines psl
677: WHERE pal.status_code = 'N'
678: AND pal.gl_code_combination_id is not null
679: AND pal.payroll_control_id = p_payroll_control_id

Line 1905: -- move the transferred records to psp_adjustment_lines_history

1901:
1902: UPDATE psp_adjustment_lines
1903: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
1904:
1905: -- move the transferred records to psp_adjustment_lines_history
1906: INSERT INTO psp_adjustment_lines_history
1907: (adjustment_line_id,person_id,assignment_id,element_type_id,
1908: distribution_date,effective_date,distribution_amount,
1909: dr_cr_flag,payroll_control_id,source_type,source_code,time_period_id,

Line 1906: INSERT INTO psp_adjustment_lines_history

1902: UPDATE psp_adjustment_lines
1903: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
1904:
1905: -- move the transferred records to psp_adjustment_lines_history
1906: INSERT INTO psp_adjustment_lines_history
1907: (adjustment_line_id,person_id,assignment_id,element_type_id,
1908: distribution_date,effective_date,distribution_amount,
1909: dr_cr_flag,payroll_control_id,source_type,source_code,time_period_id,
1910: batch_name,status_code,set_of_books_id,gl_code_combination_id,project_id,

Line 1942: psp_adjustment_lines_history then deleted from psp_adjustment_lines for summary_line_id : '||l_summary_line_id);

1938: WHERE status_code = 'A'
1939: AND summary_line_id = l_summary_line_id;
1940:
1941: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Updated psp_summary_lines, psp_adjustment_lines inserted into
1942: psp_adjustment_lines_history then deleted from psp_adjustment_lines for summary_line_id : '||l_summary_line_id);
1943:
1944: END LOOP;
1945:
1946: UPDATE psp_payroll_controls

Line 2455: psp_adjustment_lines_history pal2,

2451: DECODE(g_dff_grouping_option, 'Y', pal.attribute8, NULL) attribute8,
2452: DECODE(g_dff_grouping_option, 'Y', pal.attribute9, NULL) attribute9,
2453: DECODE(g_dff_grouping_option, 'Y', pal.attribute10, NULL) attribute10
2454: FROM psp_adjustment_lines pal,
2455: psp_adjustment_lines_history pal2,
2456: psp_summary_lines psl
2457: WHERE pal.status_code = 'N'
2458: AND pal.gl_code_combination_id IS NULL
2459: AND pal.payroll_control_id = p_payroll_control_id

Line 4213: -- move the transferred records to psp_adjustment_lines_history

4209:
4210: UPDATE psp_adjustment_lines
4211: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
4212:
4213: -- move the transferred records to psp_adjustment_lines_history
4214: INSERT INTO psp_adjustment_lines_history
4215: (adjustment_line_id,person_id,assignment_id,element_type_id,
4216: distribution_date,effective_date,distribution_amount,
4217: dr_cr_flag,payroll_control_id,source_type,source_code,time_period_id,

Line 4214: INSERT INTO psp_adjustment_lines_history

4210: UPDATE psp_adjustment_lines
4211: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
4212:
4213: -- move the transferred records to psp_adjustment_lines_history
4214: INSERT INTO psp_adjustment_lines_history
4215: (adjustment_line_id,person_id,assignment_id,element_type_id,
4216: distribution_date,effective_date,distribution_amount,
4217: dr_cr_flag,payroll_control_id,source_type,source_code,time_period_id,
4218: batch_name,status_code,set_of_books_id,gl_code_combination_id,project_id,

Line 4257: psp_adjustment_lines_history then deleted from psp_adjustment_lines for summary_line_id : '||l_summary_line_id);

4253: WHERE orig_transaction_reference = to_char(l_summary_line_id)
4254: AND transaction_status_code = 'A'
4255: AND transaction_source = l_txn_source; */
4256: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Updated psp_summary_lines, psp_adjustment_lines inserted into
4257: psp_adjustment_lines_history then deleted from psp_adjustment_lines for summary_line_id : '||l_summary_line_id);
4258:
4259:
4260: END LOOP; -- End loop for gms_tie_back_success_cur
4261:

Line 4452: FROM psp_adjustment_lines_history palh,

4448: AND pal.reversal_entry_flag IS NULL
4449: UNION ALL -- added hist table for 2133056
4450: SELECT palh.orig_source_type,
4451: palh.orig_line_id
4452: FROM psp_adjustment_lines_history palh,
4453: psp_payroll_controls ppc
4454: WHERE palh.reversal_entry_flag IS NULL
4455: AND ppc.source_type ='A'
4456: AND ppc.batch_name = p_batch_name

Line 4621: update psp_adjustment_lines_history

4617: update psp_pre_gen_dist_lines_history
4618: set adjustment_batch_name = NULL
4619: where pre_gen_dist_line_id = adj_batch_rec.orig_line_id;
4620: elsif adj_batch_rec.orig_source_type = 'A' then
4621: update psp_adjustment_lines_history
4622: set adjustment_batch_name = NULL
4623: where adjustment_line_id = adj_batch_rec.orig_line_id;
4624: end if;
4625: end loop;

Line 4627: delete from psp_adjustment_lines_history

4623: where adjustment_line_id = adj_batch_rec.orig_line_id;
4624: end if;
4625: end loop;
4626:
4627: delete from psp_adjustment_lines_history
4628: where payroll_control_id in --- Corrected this statment 2133056
4629: ( SELECT ppc.payroll_control_id
4630: FROM psp_payroll_controls ppc
4631: WHERE ppc.batch_name = l_batch_name