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

450: AND status_code <> 'A';
451:
452: CURSOR adj_lines_cur(P_PAYROLL_CONTROL_ID IN NUMBER) IS
453: SELECT count(*)
454: FROM psp_adjustment_lines
455: WHERE payroll_control_id = p_payroll_control_id
456: AND gl_code_combination_id is not null
457: AND status_code <> 'A';
458:

Line 643: FROM psp_adjustment_lines pal,

639: DECODE(g_dff_grouping_option, 'Y', pal.attribute7, NULL) attribute7,
640: DECODE(g_dff_grouping_option, 'Y', pal.attribute8, NULL) attribute8,
641: DECODE(g_dff_grouping_option, 'Y', pal.attribute9, NULL) attribute9,
642: DECODE(g_dff_grouping_option, 'Y', pal.attribute10, NULL) attribute10
643: FROM psp_adjustment_lines pal,
644: psp_distribution_lines_history pdlh,
645: psp_summary_lines psl
646: WHERE pal.status_code = 'N'
647: AND pal.gl_code_combination_id is not null

Line 674: FROM psp_adjustment_lines pal,

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

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

701: DECODE(g_dff_grouping_option, 'Y', pal.attribute7, NULL) attribute7,
702: DECODE(g_dff_grouping_option, 'Y', pal.attribute8, NULL) attribute8,
703: DECODE(g_dff_grouping_option, 'Y', pal.attribute9, NULL) attribute9,
704: DECODE(g_dff_grouping_option, 'Y', pal.attribute10, NULL) attribute10
705: FROM psp_adjustment_lines pal,
706: psp_pre_gen_dist_lines_history pglh,
707: psp_summary_lines psl
708: WHERE pal.status_code = 'N'
709: AND pal.gl_code_combination_id is not null

Line 895: UPDATE psp_adjustment_lines

891:
892: l_dist_line_id := dist_line_id(j);
893:
894: IF gl_sum_lines_rec.tab_flag = 'A' THEN
895: UPDATE psp_adjustment_lines
896: SET summary_line_id = l_summary_line_id
897: WHERE adjustment_line_id = l_dist_line_id;
898: END IF;
899:

Line 901: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Updated psp_adjustment_lines 1');

897: WHERE adjustment_line_id = l_dist_line_id;
898: END IF;
899:
900: END LOOP;
901: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Updated psp_adjustment_lines 1');
902:
903:
904: -- initialise the summary amount and dist_line_id
905: l_summary_amount := 0;

Line 985: UPDATE psp_adjustment_lines

981: FOR j IN 1 .. dist_line_id.COUNT LOOP
982: l_dist_line_id := dist_line_id(j);
983:
984: IF gl_sum_lines_rec.tab_flag = 'A' THEN
985: UPDATE psp_adjustment_lines
986: SET summary_line_id = l_summary_line_id,
987: status_code = 'N'
988: WHERE adjustment_line_id = l_dist_line_id;
989: END IF;

Line 991: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Updated psp_adjustment_lines 2 set status_code to N');

987: status_code = 'N'
988: WHERE adjustment_line_id = l_dist_line_id;
989: END IF;
990: END LOOP;
991: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Updated psp_adjustment_lines 2 set status_code to N');
992:
993: -- moved this code from above for 3108109
994: if dist_line_id.count > 0 then
995: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Calling gl_balance_transaction');

Line 1315: FROM psp_adjustment_lines pal

1311: CURSOR employee_name_cur IS
1312: SELECT full_name
1313: FROM per_people_f ppf
1314: WHERE ppf.person_id = (SELECT pal.person_id
1315: FROM psp_adjustment_lines pal
1316: WHERE pal.payroll_control_id = gl_batch_rec.payroll_control_id
1317: AND rownum = 1); --Bug 2133056 removed distinct and replace batch_name with payroll_control_id
1318:
1319: BEGIN

Line 1681: FROM psp_adjustment_lines

1677: AND payroll_control_id = p_payroll_control_id;
1678:
1679: CURSOR gl_reversal_cur(p_summary_line_id IN NUMBER) IS
1680: SELECT reversal_entry_flag
1681: FROM psp_adjustment_lines
1682: WHERE summary_line_id = p_summary_line_id;
1683:
1684: CURSOR gl_tie_back_cur(p_batch_name IN VARCHAR2) IS
1685: SELECT payroll_control_id,

Line 1902: UPDATE psp_adjustment_lines

1898: ELSIF l_dr_cr_flag = 'C' THEN
1899: l_cr_summary_amount := l_cr_summary_amount + l_summary_amount;
1900: END IF;
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

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

1929: attribute5,attribute6,attribute7,attribute8,attribute9,attribute10,attribute11,
1930: attribute12,attribute13,attribute14,attribute15,SYSDATE,FND_GLOBAL.USER_ID,
1931: FND_GLOBAL.LOGIN_ID,FND_GLOBAL.USER_ID,SYSDATE, business_group_id,
1932: adj_set_number, line_number --- added cols 2634557 DA Multiple element Enh
1933: FROM psp_adjustment_lines
1934: WHERE status_code = 'A'
1935: AND summary_line_id = l_summary_line_id;
1936:
1937: DELETE FROM psp_adjustment_lines

Line 1937: DELETE FROM psp_adjustment_lines

1933: FROM psp_adjustment_lines
1934: WHERE status_code = 'A'
1935: AND summary_line_id = l_summary_line_id;
1936:
1937: DELETE FROM psp_adjustment_lines
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

Line 1941: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Updated psp_summary_lines, psp_adjustment_lines inserted into

1937: DELETE FROM psp_adjustment_lines
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:

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 2022: from psp_adjustment_lines

2018: -- Redundant balancing lines created for GL Balanced Batch Bug 1977893
2019: -- Added following two cursors and two variables for credit amount and debit amount
2020: cursor control_rec_debit_amount_cur is
2021: select sum(nvl(distribution_amount,0))
2022: from psp_adjustment_lines
2023: where dr_cr_flag = 'D'
2024: and gl_code_combination_id is not null
2025: and payroll_control_id = p_payroll_control_id;
2026:

Line 2029: from psp_adjustment_lines

2025: and payroll_control_id = p_payroll_control_id;
2026:
2027: cursor control_rec_credit_amount_cur is
2028: select sum(nvl(distribution_amount,0))
2029: from psp_adjustment_lines
2030: where dr_cr_flag = 'C'
2031: and gl_code_combination_id is not null
2032: and payroll_control_id = p_payroll_control_id;
2033:

Line 2041: from psp_adjustment_lines

2037:
2038: --- added following cursor for 3108109
2039: cursor get_element_type_id(p_summary_line_id number) is
2040: select element_type_id
2041: from psp_adjustment_lines
2042: where summary_line_id = p_summary_line_id
2043: and rownum = 1;
2044:
2045:

Line 2082: DELETE FROM psp_adjustment_lines

2078: END IF;
2079: CLOSE reversing_gl_ccid_cur;
2080: END;
2081:
2082: DELETE FROM psp_adjustment_lines
2083: WHERE reversal_entry_flag = 'Y'
2084: AND status_code = 'N'
2085: AND payroll_control_id = p_payroll_control_id;
2086:

Line 2155: insert into psp_adjustment_lines

2151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2152: END IF;
2153:
2154: -- insert the reversal entry record into distribution lines
2155: insert into psp_adjustment_lines
2156: (adjustment_line_id,person_id,assignment_id,element_type_id,
2157: distribution_date,effective_date,distribution_amount,dr_cr_flag,
2158: payroll_control_id,source_type,source_code,time_period_id,batch_name,
2159: status_code,gl_code_combination_id,reversal_entry_flag,last_update_date,last_updated_by,

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

2159: status_code,gl_code_combination_id,reversal_entry_flag,last_update_date,last_updated_by,
2160: last_update_login,created_by,creation_date, business_group_id, set_of_books_id,
2161: summary_line_id)
2162: values
2163: (PSP_ADJUSTMENT_LINES_S.NEXTVAL,ad_reversal_entry_rec.person_id,
2164: ad_reversal_entry_rec.assignment_id,ad_reversal_entry_rec.element_type_id,
2165: ad_reversal_entry_rec.effective_date,ad_reversal_entry_rec.effective_date,
2166: ad_reversal_entry_rec.reversal_dist_amount, ----l_reversal_dist_amount, Bug 1976999
2167: ad_reversal_entry_rec.dr_cr_flag,

Line 2419: FROM psp_adjustment_lines pal,

2415: DECODE(g_dff_grouping_option, 'Y', pal.attribute7, NULL) attribute7,
2416: DECODE(g_dff_grouping_option, 'Y', pal.attribute8, NULL) attribute8,
2417: DECODE(g_dff_grouping_option, 'Y', pal.attribute9, NULL) attribute9,
2418: DECODE(g_dff_grouping_option, 'Y', pal.attribute10, NULL) attribute10
2419: FROM psp_adjustment_lines pal,
2420: psp_distribution_lines_history pdh,
2421: psp_summary_lines psl
2422: WHERE pal.status_code = 'N'
2423: AND pal.gl_code_combination_id IS NULL

Line 2454: FROM psp_adjustment_lines pal,

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

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

2485: DECODE(g_dff_grouping_option, 'Y', pal.attribute7, NULL) attribute7,
2486: DECODE(g_dff_grouping_option, 'Y', pal.attribute8, NULL) attribute8,
2487: DECODE(g_dff_grouping_option, 'Y', pal.attribute9, NULL) attribute9,
2488: DECODE(g_dff_grouping_option, 'Y', pal.attribute10, NULL) attribute10
2489: FROM psp_adjustment_lines pal,
2490: psp_pre_gen_dist_lines_history pgh,
2491: psp_summary_lines psl
2492: WHERE pal.status_code = 'N'
2493: AND pal.gl_code_combination_id IS NULL

Line 2686: UPDATE psp_adjustment_lines

2682:
2683: FOR j IN 1 .. dist_line_id.COUNT LOOP
2684: l_dist_line_id := dist_line_id(j);
2685: IF gms_sum_lines_rec.tab_flag = 'A' THEN
2686: UPDATE psp_adjustment_lines
2687: SET summary_line_id = l_summary_line_id WHERE adjustment_line_id = l_dist_line_id;
2688: END IF;
2689: END LOOP;
2690: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Updated psp_adjustment_lines 3');

Line 2690: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Updated psp_adjustment_lines 3');

2686: UPDATE psp_adjustment_lines
2687: SET summary_line_id = l_summary_line_id WHERE adjustment_line_id = l_dist_line_id;
2688: END IF;
2689: END LOOP;
2690: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Updated psp_adjustment_lines 3');
2691:
2692:
2693: -- initialise the summary amount and dist_line_id
2694: l_summary_amount := 0;

Line 2785: UPDATE psp_adjustment_lines

2781: FOR j IN 1 .. dist_line_id.COUNT LOOP
2782: l_dist_line_id := dist_line_id(j);
2783:
2784: IF gms_sum_lines_rec.tab_flag = 'A' THEN
2785: UPDATE psp_adjustment_lines
2786: SET summary_line_id = l_summary_line_id,
2787: status_code = 'N'
2788: WHERE adjustment_line_id = l_dist_line_id;
2789: END IF;

Line 2791: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Updated psp_adjustment_lines 4 set status_code to N');

2787: status_code = 'N'
2788: WHERE adjustment_line_id = l_dist_line_id;
2789: END IF;
2790: END LOOP;
2791: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Updated psp_adjustment_lines 4 set status_code to N');
2792:
2793: dist_line_id.delete;
2794: END IF;
2795:

Line 2971: FROM psp_adjustment_lines pal

2967: CURSOR employee_name_cur IS
2968: SELECT full_name
2969: FROM per_people_f ppf
2970: WHERE ppf.person_id = (SELECT pal.person_id
2971: FROM psp_adjustment_lines pal
2972: WHERE pal.payroll_control_id = gms_batch_rec.payroll_control_id
2973: AND rownum = 1); -- Bug 2133056 Replaced batch_name with payroll_control_id and removed DISTINCT
2974: -- WHERE ppf.person_id = gms_interface_cur.person_id; Commented this cond. as part of 1828519
2975:

Line 4210: UPDATE psp_adjustment_lines

4206: ELSIF l_dr_cr_flag = 'C' THEN
4207: l_cr_summary_amount := l_cr_summary_amount - l_summary_amount;
4208: END IF;
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

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

4237: attribute5,attribute6,attribute7,attribute8,attribute9,attribute10,attribute11,
4238: attribute12,attribute13,attribute14,attribute15,SYSDATE,FND_GLOBAL.USER_ID,
4239: FND_GLOBAL.LOGIN_ID,FND_GLOBAL.USER_ID,SYSDATE, business_group_id,
4240: adj_set_number, line_number --- added cols 2634557 DA Multiple element Enh
4241: FROM psp_adjustment_lines
4242: WHERE status_code = 'A'
4243: AND summary_line_id = l_summary_line_id
4244: AND payroll_control_id = gms_tie_back_rec.payroll_control_id;
4245:

Line 4246: DELETE FROM psp_adjustment_lines

4242: WHERE status_code = 'A'
4243: AND summary_line_id = l_summary_line_id
4244: AND payroll_control_id = gms_tie_back_rec.payroll_control_id;
4245:
4246: DELETE FROM psp_adjustment_lines
4247: WHERE status_code = 'A'
4248: AND summary_line_id = l_summary_line_id
4249: AND payroll_control_id = gms_tie_back_rec.payroll_control_id;
4250:

Line 4256: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Updated psp_summary_lines, psp_adjustment_lines inserted into

4252: DELETE FROM pa_transaction_interface_all
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

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 4443: from psp_adjustment_lines pal,

4439:
4440: cursor adj_batch_cur (p_batch_name IN VARCHAR2) IS
4441: select orig_source_type,
4442: orig_line_id
4443: from psp_adjustment_lines pal,
4444: psp_payroll_controls ppc
4445: WHERE ppc.source_type ='A'
4446: AND ppc.batch_name = p_batch_name
4447: AND pal.payroll_control_id = ppc.payroll_control_id

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

Line 4635: delete from psp_adjustment_lines

4631: WHERE ppc.batch_name = l_batch_name
4632: AND ppc.source_type = 'A');
4633:
4634:
4635: delete from psp_adjustment_lines
4636: where batch_name = l_batch_name;
4637:
4638: delete from psp_summary_lines
4639: where payroll_control_id in (select payroll_control_id