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

Line 390: FROM psp_adjustment_lines

386: AND status_code <> 'A';
387:
388: CURSOR adj_lines_cur(P_PAYROLL_CONTROL_ID IN NUMBER) IS
389: SELECT count(*)
390: FROM psp_adjustment_lines
391: WHERE payroll_control_id = p_payroll_control_id
392: AND gl_code_combination_id is not null
393: AND status_code <> 'A';
394:

Line 567: FROM psp_adjustment_lines pal,

563: DECODE(g_dff_grouping_option, 'Y', pal.attribute7, NULL) attribute7,
564: DECODE(g_dff_grouping_option, 'Y', pal.attribute8, NULL) attribute8,
565: DECODE(g_dff_grouping_option, 'Y', pal.attribute9, NULL) attribute9,
566: DECODE(g_dff_grouping_option, 'Y', pal.attribute10, NULL) attribute10
567: FROM psp_adjustment_lines pal,
568: psp_distribution_lines_history pdlh,
569: psp_summary_lines psl
570: WHERE pal.status_code = 'N'
571: AND pal.gl_code_combination_id is not null

Line 598: FROM psp_adjustment_lines pal,

594: DECODE(g_dff_grouping_option, 'Y', pal.attribute7, NULL) attribute7,
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

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 629: FROM psp_adjustment_lines pal,

625: DECODE(g_dff_grouping_option, 'Y', pal.attribute7, NULL) attribute7,
626: DECODE(g_dff_grouping_option, 'Y', pal.attribute8, NULL) attribute8,
627: DECODE(g_dff_grouping_option, 'Y', pal.attribute9, NULL) attribute9,
628: DECODE(g_dff_grouping_option, 'Y', pal.attribute10, NULL) attribute10
629: FROM psp_adjustment_lines pal,
630: psp_pre_gen_dist_lines_history pglh,
631: psp_summary_lines psl
632: WHERE pal.status_code = 'N'
633: AND pal.gl_code_combination_id is not null

Line 811: UPDATE psp_adjustment_lines

807:
808: l_dist_line_id := dist_line_id(j);
809:
810: IF gl_sum_lines_rec.tab_flag = 'A' THEN
811: UPDATE psp_adjustment_lines
812: SET summary_line_id = l_summary_line_id
813: WHERE adjustment_line_id = l_dist_line_id;
814: END IF;
815:

Line 897: UPDATE psp_adjustment_lines

893: FOR j IN 1 .. dist_line_id.COUNT LOOP
894: l_dist_line_id := dist_line_id(j);
895:
896: IF gl_sum_lines_rec.tab_flag = 'A' THEN
897: UPDATE psp_adjustment_lines
898: SET summary_line_id = l_summary_line_id,
899: status_code = 'N'
900: WHERE adjustment_line_id = l_dist_line_id;
901: END IF;

Line 1223: FROM psp_adjustment_lines pal

1219: CURSOR employee_name_cur IS
1220: SELECT full_name
1221: FROM per_people_f ppf
1222: WHERE ppf.person_id = (SELECT pal.person_id
1223: FROM psp_adjustment_lines pal
1224: WHERE pal.payroll_control_id = gl_batch_rec.payroll_control_id
1225: AND rownum = 1); --Bug 2133056 removed distinct and replace batch_name with payroll_control_id
1226:
1227: BEGIN

Line 1574: FROM psp_adjustment_lines

1570: AND payroll_control_id = p_payroll_control_id;
1571:
1572: CURSOR gl_reversal_cur(p_summary_line_id IN NUMBER) IS
1573: SELECT reversal_entry_flag
1574: FROM psp_adjustment_lines
1575: WHERE summary_line_id = p_summary_line_id;
1576:
1577: CURSOR gl_tie_back_cur(p_batch_name IN VARCHAR2) IS
1578: SELECT payroll_control_id,

Line 1784: UPDATE psp_adjustment_lines

1780: ELSIF l_dr_cr_flag = 'C' THEN
1781: l_cr_summary_amount := l_cr_summary_amount + l_summary_amount;
1782: END IF;
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

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 1815: FROM psp_adjustment_lines

1811: attribute5,attribute6,attribute7,attribute8,attribute9,attribute10,attribute11,
1812: attribute12,attribute13,attribute14,attribute15,SYSDATE,FND_GLOBAL.USER_ID,
1813: FND_GLOBAL.LOGIN_ID,FND_GLOBAL.USER_ID,SYSDATE, business_group_id,
1814: adj_set_number, line_number --- added cols 2634557 DA Multiple element Enh
1815: FROM psp_adjustment_lines
1816: WHERE status_code = 'A'
1817: AND summary_line_id = l_summary_line_id;
1818:
1819: DELETE FROM psp_adjustment_lines

Line 1819: DELETE FROM psp_adjustment_lines

1815: FROM psp_adjustment_lines
1816: WHERE status_code = 'A'
1817: AND summary_line_id = l_summary_line_id;
1818:
1819: DELETE FROM psp_adjustment_lines
1820: WHERE status_code = 'A'
1821: AND summary_line_id = l_summary_line_id;
1822:
1823: END LOOP;

Line 1898: from psp_adjustment_lines

1894: -- Redundant balancing lines created for GL Balanced Batch Bug 1977893
1895: -- Added following two cursors and two variables for credit amount and debit amount
1896: cursor control_rec_debit_amount_cur is
1897: select sum(nvl(distribution_amount,0))
1898: from psp_adjustment_lines
1899: where dr_cr_flag = 'D'
1900: and gl_code_combination_id is not null
1901: and payroll_control_id = p_payroll_control_id;
1902:

Line 1905: from psp_adjustment_lines

1901: and payroll_control_id = p_payroll_control_id;
1902:
1903: cursor control_rec_credit_amount_cur is
1904: select sum(nvl(distribution_amount,0))
1905: from psp_adjustment_lines
1906: where dr_cr_flag = 'C'
1907: and gl_code_combination_id is not null
1908: and payroll_control_id = p_payroll_control_id;
1909:

Line 1917: from psp_adjustment_lines

1913:
1914: --- added following cursor for 3108109
1915: cursor get_element_type_id(p_summary_line_id number) is
1916: select element_type_id
1917: from psp_adjustment_lines
1918: where summary_line_id = p_summary_line_id
1919: and rownum = 1;
1920:
1921:

Line 1958: DELETE FROM psp_adjustment_lines

1954: END IF;
1955: CLOSE reversing_gl_ccid_cur;
1956: END;
1957:
1958: DELETE FROM psp_adjustment_lines
1959: WHERE reversal_entry_flag = 'Y'
1960: AND status_code = 'N'
1961: AND payroll_control_id = p_payroll_control_id;
1962:

Line 2031: insert into psp_adjustment_lines

2027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2028: END IF;
2029:
2030: -- insert the reversal entry record into distribution lines
2031: insert into psp_adjustment_lines
2032: (adjustment_line_id,person_id,assignment_id,element_type_id,
2033: distribution_date,effective_date,distribution_amount,dr_cr_flag,
2034: payroll_control_id,source_type,source_code,time_period_id,batch_name,
2035: status_code,gl_code_combination_id,reversal_entry_flag,last_update_date,last_updated_by,

Line 2039: (PSP_ADJUSTMENT_LINES_S.NEXTVAL,ad_reversal_entry_rec.person_id,

2035: status_code,gl_code_combination_id,reversal_entry_flag,last_update_date,last_updated_by,
2036: last_update_login,created_by,creation_date, business_group_id, set_of_books_id,
2037: summary_line_id)
2038: values
2039: (PSP_ADJUSTMENT_LINES_S.NEXTVAL,ad_reversal_entry_rec.person_id,
2040: ad_reversal_entry_rec.assignment_id,ad_reversal_entry_rec.element_type_id,
2041: ad_reversal_entry_rec.effective_date,ad_reversal_entry_rec.effective_date,
2042: ad_reversal_entry_rec.reversal_dist_amount, ----l_reversal_dist_amount, Bug 1976999
2043: ad_reversal_entry_rec.dr_cr_flag,

Line 2295: FROM psp_adjustment_lines pal,

2291: DECODE(g_dff_grouping_option, 'Y', pal.attribute7, NULL) attribute7,
2292: DECODE(g_dff_grouping_option, 'Y', pal.attribute8, NULL) attribute8,
2293: DECODE(g_dff_grouping_option, 'Y', pal.attribute9, NULL) attribute9,
2294: DECODE(g_dff_grouping_option, 'Y', pal.attribute10, NULL) attribute10
2295: FROM psp_adjustment_lines pal,
2296: psp_distribution_lines_history pdh,
2297: psp_summary_lines psl
2298: WHERE pal.status_code = 'N'
2299: AND pal.gl_code_combination_id IS NULL

Line 2330: FROM psp_adjustment_lines pal,

2326: DECODE(g_dff_grouping_option, 'Y', pal.attribute7, NULL) attribute7,
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

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 2365: FROM psp_adjustment_lines pal,

2361: DECODE(g_dff_grouping_option, 'Y', pal.attribute7, NULL) attribute7,
2362: DECODE(g_dff_grouping_option, 'Y', pal.attribute8, NULL) attribute8,
2363: DECODE(g_dff_grouping_option, 'Y', pal.attribute9, NULL) attribute9,
2364: DECODE(g_dff_grouping_option, 'Y', pal.attribute10, NULL) attribute10
2365: FROM psp_adjustment_lines pal,
2366: psp_pre_gen_dist_lines_history pgh,
2367: psp_summary_lines psl
2368: WHERE pal.status_code = 'N'
2369: AND pal.gl_code_combination_id IS NULL

Line 2555: UPDATE psp_adjustment_lines

2551:
2552: FOR j IN 1 .. dist_line_id.COUNT LOOP
2553: l_dist_line_id := dist_line_id(j);
2554: IF gms_sum_lines_rec.tab_flag = 'A' THEN
2555: UPDATE psp_adjustment_lines
2556: SET summary_line_id = l_summary_line_id WHERE adjustment_line_id = l_dist_line_id;
2557: END IF;
2558: END LOOP;
2559:

Line 2650: UPDATE psp_adjustment_lines

2646: FOR j IN 1 .. dist_line_id.COUNT LOOP
2647: l_dist_line_id := dist_line_id(j);
2648:
2649: IF gms_sum_lines_rec.tab_flag = 'A' THEN
2650: UPDATE psp_adjustment_lines
2651: SET summary_line_id = l_summary_line_id,
2652: status_code = 'N'
2653: WHERE adjustment_line_id = l_dist_line_id;
2654: END IF;

Line 2827: FROM psp_adjustment_lines pal

2823: CURSOR employee_name_cur IS
2824: SELECT full_name
2825: FROM per_people_f ppf
2826: WHERE ppf.person_id = (SELECT pal.person_id
2827: FROM psp_adjustment_lines pal
2828: WHERE pal.payroll_control_id = gms_batch_rec.payroll_control_id
2829: AND rownum = 1); -- Bug 2133056 Replaced batch_name with payroll_control_id and removed DISTINCT
2830: -- WHERE ppf.person_id = gms_interface_cur.person_id; Commented this cond. as part of 1828519
2831:

Line 3795: UPDATE psp_adjustment_lines

3791: ELSIF l_dr_cr_flag = 'C' THEN
3792: l_cr_summary_amount := l_cr_summary_amount - l_summary_amount;
3793: END IF;
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

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 3826: FROM psp_adjustment_lines

3822: attribute5,attribute6,attribute7,attribute8,attribute9,attribute10,attribute11,
3823: attribute12,attribute13,attribute14,attribute15,SYSDATE,FND_GLOBAL.USER_ID,
3824: FND_GLOBAL.LOGIN_ID,FND_GLOBAL.USER_ID,SYSDATE, business_group_id,
3825: adj_set_number, line_number --- added cols 2634557 DA Multiple element Enh
3826: FROM psp_adjustment_lines
3827: WHERE status_code = 'A'
3828: AND summary_line_id = l_summary_line_id
3829: AND payroll_control_id = gms_tie_back_rec.payroll_control_id;
3830:

Line 3831: DELETE FROM psp_adjustment_lines

3827: WHERE status_code = 'A'
3828: AND summary_line_id = l_summary_line_id
3829: AND payroll_control_id = gms_tie_back_rec.payroll_control_id;
3830:
3831: DELETE FROM psp_adjustment_lines
3832: WHERE status_code = 'A'
3833: AND summary_line_id = l_summary_line_id
3834: AND payroll_control_id = gms_tie_back_rec.payroll_control_id;
3835:

Line 4012: from psp_adjustment_lines pal,

4008:
4009: cursor adj_batch_cur (p_batch_name IN VARCHAR2) IS
4010: select orig_source_type,
4011: orig_line_id
4012: from psp_adjustment_lines pal,
4013: psp_payroll_controls ppc
4014: WHERE ppc.source_type ='A'
4015: AND ppc.batch_name = p_batch_name
4016: AND pal.payroll_control_id = ppc.payroll_control_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

Line 4204: delete from psp_adjustment_lines

4200: WHERE ppc.batch_name = l_batch_name
4201: AND ppc.source_type = 'A');
4202:
4203:
4204: delete from psp_adjustment_lines
4205: where batch_name = l_batch_name;
4206:
4207: delete from psp_summary_lines
4208: where payroll_control_id in (select payroll_control_id