[Home] [Help]
362: p_return_status OUT NOCOPY VARCHAR2) IS
363:
364: CURSOR payroll_control_cur2 IS
365: SELECT payroll_control_id
366: FROM psp_payroll_controls
367: WHERE source_type = nvl(p_source_type,source_type)
368: AND payroll_source_code = nvl(p_source_code,payroll_source_code)
369: AND payroll_id = NVL (p_payroll_id, payroll_id) -- Bug 7137063
370: AND time_period_id = nvl(p_time_period_id,time_period_id)
384: payroll_source_code,
385: time_period_id,
386: batch_name,
387: phase
388: FROM psp_payroll_controls
389: where status_code in ('N','I')
390: and source_type <> 'A'
391: and payroll_control_id = l_payroll_control_id
392: or parent_payroll_control_id = l_payroll_control_id;
412: IF payroll_control_cur%NOTFOUND THEN
413: CLOSE payroll_control_cur;
414: EXIT;
415: END IF;
416: UPDATE psp_payroll_controls
417: SET status_code = 'I',
418: run_id = g_run_id
419: WHERE payroll_control_id = payroll_control_rec.payroll_control_id;
420:
469: payroll_source_code,
470: time_period_id,
471: batch_name,
472: phase
473: FROM psp_payroll_controls
474: WHERE status_code = 'I'
475: AND run_id = g_run_id
476: AND source_type <> 'A';
477:
536: --- Also removed update statment that makes summary lines status = R
537: -- whenever status = 'N', becos there is a new phase Summarize
538:
539: -- This part is used to delete the rejected summary lines, mark the status_code
540: -- in psp_payroll_controls to 'P' or 'N',delete the zero line reversal entry records
541: /* Bug 1929317.. Did some changes here...deleted the original code.....Look into previous version
542: to compare .. Basically to check the number of lines in dist lines ...instead of summing on dist amount
543: for deciding wether to change control rec status to either 'P' or 'N' */
544: IF payroll_control_rec.source_type = 'O' OR payroll_control_rec.source_type = 'N' THEN
547: WHERE distribution_amount = 0
548: AND payroll_sub_line_id IN (
549: select payroll_sub_line_id from psp_payroll_sub_lines where payroll_line_id IN (
550: select payroll_line_id from psp_payroll_lines where payroll_control_id IN (
551: select payroll_control_id from psp_payroll_controls where payroll_control_id=
552: payroll_control_rec.payroll_control_id)));
553:
554: SELECT count(*)
555: INTO l_line_counter
568: WHERE payroll_control_id = payroll_control_rec.payroll_control_id
569: AND status_code = 'R';
570: */
571:
572: -- update status_code to 'P' in psp_payroll_controls
573: UPDATE psp_payroll_controls
574: SET status_code = 'P',
575: run_id = NULL,
576: phase = NULL
569: AND status_code = 'R';
570: */
571:
572: -- update status_code to 'P' in psp_payroll_controls
573: UPDATE psp_payroll_controls
574: SET status_code = 'P',
575: run_id = NULL,
576: phase = NULL
577: WHERE payroll_control_id = payroll_control_rec.payroll_control_id;
575: run_id = NULL,
576: phase = NULL
577: WHERE payroll_control_id = payroll_control_rec.payroll_control_id;
578: ELSE
579: UPDATE psp_payroll_controls
580: SET status_code = 'N',
581: run_id = NULL
582: WHERE payroll_control_id = payroll_control_rec.payroll_control_id;
583: END IF;
600: WHERE payroll_control_id = payroll_control_rec.payroll_control_id
601: AND status_code = 'R';
602: */
603:
604: UPDATE psp_payroll_controls
605: SET status_code = 'P',
606: run_id = NULL,
607: phase = NULL
608: WHERE payroll_control_id = payroll_control_rec.payroll_control_id;
606: run_id = NULL,
607: phase = NULL
608: WHERE payroll_control_id = payroll_control_rec.payroll_control_id;
609: ELSE
610: UPDATE psp_payroll_controls
611: SET status_code = 'N',
612: run_id = NULL
613: WHERE payroll_control_id = payroll_control_rec.payroll_control_id;
614: END IF;
645: gl_posting_override_date,
646: business_group_id,
647: set_of_books_id,
648: currency_code -- Introduced for Bug 2916848 Ilo Mrc
649: FROM psp_payroll_controls
650: WHERE source_type <> 'A'
651: AND run_id = g_run_id
652: AND (phase is null or
653: phase in ('GMS_Tie_Back', 'GL_Tie_Back')); ---- added for 2444657
687: psp_organization_accounts pod,
688: psp_organization_accounts pos,
689: psp_element_type_accounts pea,
690: psp_default_labor_schedules pdls,
691: psp_payroll_controls ppc,
692: psp_payroll_lines ppl,
693: psp_payroll_sub_lines ppsl,
694: psp_distribution_lines pdl
695: WHERE pdl.status_code = 'N'
734: DECODE(g_dff_grouping_option, 'Y', DECODE(ppg.suspense_org_account_id, NULL, ppg.attribute10, pos.attribute10), NULL) attribute10
735: ---decode(ppg.suspense_org_Account_id, NULL, 'N', 'Y') Suspense_Flag commented for 2663344
736: FROM psp_pre_gen_dist_lines ppg,
737: psp_organization_accounts pos,
738: psp_payroll_controls ppc
739: WHERE ppg.status_code = 'N'
740: /* changed following condition for bug 2007521 */
741: AND ((ppg.gl_code_combination_id IS NOT NULL and pos.project_id is null)
742: OR pos.gl_code_combination_id IS NOT NULL)
769: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute7, pos.attribute8), NULL) attribute7,
770: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute8, pos.attribute8), NULL) attribute8,
771: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute9, pos.attribute9), NULL) attribute9,
772: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute10, pos.attribute10), NULL) attribute10
773: FROM psp_payroll_controls ppc,
774: psp_payroll_lines ppl,
775: psp_payroll_sub_lines ppsl,
776: psp_organization_accounts pos,
777: psp_distribution_lines pdl
890: IF gl_sum_lines_cursor%ROWCOUNT = 0 THEN
891: CLOSE gl_sum_lines_cursor;
892: EXIT;
893: ELSIF gl_sum_lines_cursor%NOTFOUND THEN
894: update psp_payroll_controls set phase = 'Summarize_GL_Lines' ---2444657:changed from NULL
895: where payroll_control_id = payroll_control_rec.payroll_control_id;
896: CLOSE gl_sum_lines_cursor;
897: EXIT;
898: END IF;
1295: time_period_id,
1296: batch_name,
1297: phase --- 2444657, to separate the old and new gl imports
1298: --- S and T can pull control recs with statuses 'I' and 'N' now
1299: FROM psp_payroll_controls
1300: WHERE status_code = 'I'
1301: AND source_type <> 'A'
1302: AND run_id = g_run_id
1303: AND phase in ('Summarize_GL_Lines', 'Submitted_JI_Request'); --- 2444657: added the condition
1310: SELECT payroll_control_id,
1311: currency_code,
1312: exchange_rate_type,
1313: phase --- 2444657: added
1314: FROM psp_payroll_controls
1315: WHERE source_type = p_source_type
1316: AND payroll_source_code = p_source_code
1317: AND time_period_id = p_time_period_id
1318: AND nvl(batch_name,'N') = nvl(nvl(p_batch_name,batch_name),'N')
1550: into l_group_id
1551: from psp_summary_lines
1552: where payroll_control_id in
1553: (SELECT payroll_control_id
1554: FROM psp_payroll_controls
1555: WHERE source_type = gl_batch_rec.source_type
1556: AND payroll_source_code = gl_batch_rec.payroll_source_code
1557: AND time_period_id = gl_batch_rec.time_period_id
1558: AND nvl(batch_name,'N') = nvl(nvl(gl_batch_rec.batch_name,batch_name),'N')
1622:
1623: ELSE
1624:
1625: -- Added the update for Rollback purposes.
1626: UPDATE psp_payroll_controls
1627: SET phase = 'Submitted_JI_Request'
1628: -- Introduced selective payroll control filter for bug fix 3157895
1629: WHERE source_type = NVL(gl_batch_rec.source_type, source_type)
1630: AND payroll_source_code = NVL(gl_batch_rec.payroll_source_code, payroll_source_code)
1635: AND set_of_books_id = p_set_of_books_id
1636: AND run_id = g_run_id;
1637: commit;
1638:
1639: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Committed after updating psp_payroll_controls SET phase = Submitted_JI_Request count: '||sql%rowcount);
1640:
1641: gl_batch_rec.phase := 'Submitted_JI_Request'; ---2444657
1642: call_status := fnd_concurrent.wait_for_request(req_id, 20, 0,
1643: rphase, rstatus, dphase, dstatus, message);
2068: and je_source_name = l_user_je_source_name;
2069:
2070: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from gl_interface_control count: '||sql%rowcount);
2071:
2072: update psp_payroll_controls
2073: set phase = null
2074: where payroll_control_id = p_payroll_control_id;
2075:
2076: commit;
2073: set phase = null
2074: where payroll_control_id = p_payroll_control_id;
2075:
2076: commit;
2077: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_payroll_controls count: '||sql%rowcount);
2078:
2079: --- bug 4328598--- fix end
2080: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Commit');
2081:
2103: --- moved this statement from transfer_to_gl procedure to the beginning of this
2104: -- procedure, becuase it not being set when user defined exceptions are occuring
2105: --- like invalid suspense FATAL error. Since there is a single commit for TIE-BACK
2106: -- this will work fine... for Bug fix 2444657
2107: UPDATE psp_payroll_controls
2108: SET phase = 'GL_Tie_Back'
2109: WHERE payroll_control_id = p_payroll_control_id;
2110:
2111: IF l_cnt_gl_interface > 0 THEN
2675: END IF;
2676:
2677: END LOOP;
2678:
2679: UPDATE psp_payroll_controls
2680: SET gl_dr_amount = nvl(gl_dr_amount,0) + l_dr_summary_amount,
2681: gl_cr_amount = nvl(gl_cr_amount,0) + l_cr_summary_amount
2682: WHERE payroll_control_id = p_payroll_control_id;
2683:
2680: SET gl_dr_amount = nvl(gl_dr_amount,0) + l_dr_summary_amount,
2681: gl_cr_amount = nvl(gl_cr_amount,0) + l_cr_summary_amount
2682: WHERE payroll_control_id = p_payroll_control_id;
2683:
2684: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_payroll_controls count: '||sql%rowcount);
2685:
2686:
2687: END IF;
2688: --
2744: pdl.set_of_books_id
2745: FROM psp_distribution_lines pdl,
2746: psp_payroll_sub_lines ppsl,
2747: psp_payroll_lines ppl,
2748: psp_payroll_controls ppc
2749: WHERE ppc.payroll_control_id = p_payroll_control_id
2750: AND ppc.payroll_control_id = ppl.payroll_control_id
2751: AND ppl.payroll_line_id = ppsl.payroll_line_id
2752: AND ppsl.payroll_sub_line_id = pdl.payroll_sub_line_id
2804: AND status_code = 'N'
2805: AND payroll_sub_line_id IN (
2806: select payroll_sub_line_id from psp_payroll_sub_lines where payroll_line_id IN (
2807: select payroll_line_id from psp_payroll_lines where payroll_control_id IN (
2808: select payroll_control_id from psp_payroll_controls where payroll_control_id=
2809: p_payroll_control_id)));
2810:
2811:
2812: -- recalculate and update the reversal sub-line amounts
2836: INTO l_cr_amount, l_dr_amount
2837: FROM psp_distribution_lines pdl,
2838: psp_payroll_sub_lines ppsl,
2839: psp_payroll_lines ppl,
2840: psp_payroll_controls ppc
2841: WHERE ppc.payroll_control_id = p_payroll_control_id
2842: AND ppc.payroll_control_id = ppl.payroll_control_id
2843: AND ppl.payroll_line_id = ppsl.payroll_line_id
2844: AND ppsl.payroll_sub_line_id = pdl.payroll_sub_line_id
2852: END IF;
2853:
2854: ELSIF p_source_type = 'P' THEN
2855: SELECT payroll_id INTO l_payroll_id
2856: FROM psp_payroll_controls
2857: WHERE payroll_control_id = p_payroll_control_id;
2858:
2859: BEGIN
2860: SELECT reversing_gl_ccid
3136: time_period_id,
3137: batch_name,
3138: business_group_id,
3139: set_of_books_id
3140: FROM psp_payroll_controls
3141: WHERE status_code = 'I'
3142: AND source_type <> 'A'
3143: AND run_id = g_run_id
3144: AND (phase is null or
3198: psp_organization_accounts pod,
3199: psp_organization_accounts pos,
3200: psp_element_type_accounts pea,
3201: psp_default_labor_schedules pdls,
3202: psp_payroll_controls ppc,
3203: psp_payroll_lines ppl,
3204: psp_payroll_sub_lines ppsl,
3205: psp_distribution_lines pdl
3206: WHERE pdl.status_code = 'N'
3252: DECODE(g_dff_grouping_option, 'Y', DECODE(ppg.suspense_org_account_id, NULL, ppg.attribute10, pos.attribute10), NULL) attribute10
3253: ---decode(ppg.suspense_org_Account_id, NULL, 'N', 'Y') Suspense_Flag commented for 2663344
3254: FROM psp_pre_gen_dist_lines ppg,
3255: psp_organization_accounts pos,
3256: psp_payroll_controls ppc
3257: WHERE ppg.status_code = 'N'
3258: /* changed following condn. First Pass can have suspense: Bug 2007521 */
3259: AND ((ppg.gl_code_combination_id IS NULL and pos.gl_code_combination_id is null) OR
3260: pos.project_id is not null)
3291: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute9, pos.attribute9), NULL) attribute9,
3292: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute10, pos.attribute10), NULL) attribute10
3293: ---decode(pdl.suspense_org_account_id, NULL, 'N', 'Y') Suspense_Flag uncommented for 2663344
3294: FROM psp_organization_accounts pos,
3295: psp_payroll_controls ppc,
3296: psp_payroll_lines ppl,
3297: psp_payroll_sub_lines ppsl,
3298: psp_distribution_lines pdl
3299: WHERE pdl.status_code = 'N'
3399: CLOSE gms_sum_lines_cursor;
3400: EXIT;
3401: ELSIF gms_sum_lines_cursor%NOTFOUND THEN
3402: if (l_rec_count > 1) then
3403: update psp_payroll_controls
3404: set phase = 'Summarize_GMS_Lines' ----2444657: Replaced NULL
3405: where payroll_control_id = payroll_control_rec.payroll_control_id;
3406: end if;
3407: CLOSE gms_sum_lines_cursor;
3669: -- Introduced the following currency_code,exchange_rate_type for bug 2916848
3670: Currency_code,
3671: exchange_rate_type,
3672: phase --- added for 2444657
3673: FROM psp_payroll_controls
3674: WHERE status_code = 'I'
3675: AND source_type <> 'A'
3676: AND run_id = g_run_id
3677: AND phase in ('Summarize_GMS_Lines','Submitted_TI_Request');
4198: END LOOP;
4199:
4200: END IF; -- g_create_stat_batch_in_gms -- change
4201:
4202: update psp_payroll_controls
4203: set phase = 'Submitted_TI_Request'
4204: WHERE payroll_control_id = gms_batch_rec.payroll_control_id;
4205:
4206: commit;
4203: set phase = 'Submitted_TI_Request'
4204: WHERE payroll_control_id = gms_batch_rec.payroll_control_id;
4205:
4206: commit;
4207: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Committed after updating psp_payroll_controls SET phase = Submitted_TI_Request count: '||sql%rowcount);
4208:
4209:
4210: IF g_skip_flag_gms = 'N' THEN -- bug 6902514 -- change
4211:
4650:
4651: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' selected pa_transaction_interface_all with status_code in R,PO,PI,PR l_cnt_gms_interface :'||l_cnt_gms_interface);
4652:
4653: /* moved this statement to beginning for 2444657 */
4654: UPDATE psp_payroll_controls
4655: SET phase = 'GL_Tie_Back'
4656: WHERE payroll_control_id = p_payroll_control_id;
4657: hr_utility.trace('entered gms_tie_back3');
4658: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' update psp_payroll_controls SQL%ROWCOUNT :'||SQL%ROWCOUNT);
4654: UPDATE psp_payroll_controls
4655: SET phase = 'GL_Tie_Back'
4656: WHERE payroll_control_id = p_payroll_control_id;
4657: hr_utility.trace('entered gms_tie_back3');
4658: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' update psp_payroll_controls SQL%ROWCOUNT :'||SQL%ROWCOUNT);
4659: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' entered gms_tie_back3');
4660:
4661:
4662: IF l_cnt_gms_interface > 0 THEN
5108: END LOOP;
5109: hr_utility.trace('update control record');
5110: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' update control record');
5111:
5112: UPDATE psp_payroll_controls
5113: SET ogm_dr_amount = nvl(ogm_dr_amount,0) + l_dr_summary_amount,
5114: ogm_cr_amount = nvl(ogm_cr_amount,0) + l_cr_summary_amount
5115: WHERE payroll_control_id = p_payroll_control_id;
5116: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_payroll_controls count: '||sql%rowcount);
5112: UPDATE psp_payroll_controls
5113: SET ogm_dr_amount = nvl(ogm_dr_amount,0) + l_dr_summary_amount,
5114: ogm_cr_amount = nvl(ogm_cr_amount,0) + l_cr_summary_amount
5115: WHERE payroll_control_id = p_payroll_control_id;
5116: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_payroll_controls count: '||sql%rowcount);
5117:
5118:
5119: -- Introduced for bug fix 2643228
5120: DELETE pa_transaction_interface_all
5427: --Moved delete xface stmnts from here to below for bug 2445196:
5428: END IF;
5429: END LOOP;
5430:
5431: UPDATE psp_payroll_controls
5432: SET ogm_dr_amount = nvl(ogm_dr_amount,0) + l_dr_summary_amount,
5433: ogm_cr_amount = nvl(ogm_cr_amount,0) + l_cr_summary_amount
5434: WHERE payroll_control_id = p_payroll_control_id;
5435: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_payroll_controls count: '||sql%rowcount);
5431: UPDATE psp_payroll_controls
5432: SET ogm_dr_amount = nvl(ogm_dr_amount,0) + l_dr_summary_amount,
5433: ogm_cr_amount = nvl(ogm_cr_amount,0) + l_cr_summary_amount
5434: WHERE payroll_control_id = p_payroll_control_id;
5435: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_payroll_controls count: '||sql%rowcount);
5436:
5437:
5438: -- Introduced for bug fix 2643228
5439: DELETE pa_transaction_interface_all
5684: --- get all ER template runs, that overlapp S_AND_T time periods.
5685: cursor check_er_template_h is
5686: Select distinct pth.template_id,
5687: pth.request_id
5688: From psp_payroll_controls ppc,
5689: Psp_report_templates_h pth,
5690: Per_time_periods ptp
5691: Where ppc.run_id = p_run_id
5692: And ppc.time_period_id = ptp.time_period_id
5706: per.person_id,
5707: min(pal.summary_line_id) summary_line_id
5708: From psp_adjustment_lines_history pal,
5709: Psp_eff_reports per,
5710: Psp_payroll_controls ppc
5711: Where pal.distribution_date between per.start_date and per.end_date
5712: And per.request_id in ( select -person_id from psp_supercede_persons_gt where person_id < 0)
5713: And ppc.run_id = p_run_id
5714: And pal.person_id = per.person_id
5738: per.person_id,
5739: min(pregen.summary_line_id)
5740: From psp_pre_gen_dist_lines_history pregen,
5741: Psp_eff_reports per,
5742: Psp_payroll_controls ppc
5743: Where pregen.distribution_date between per.start_date and per.end_date
5744: And per.request_id in (select -person_id from psp_supercede_persons_gt where person_id < 0)
5745: And ppc.run_id = p_run_id
5746: And pregen.person_id = per.person_id
5774: per.person_id,
5775: MIN(dlh.summary_line_id) summary_line_id
5776: From psp_eff_reports per,
5777: Psp_distribution_lines_history DLH,
5778: Psp_payroll_controls ppc,
5779: psp_payroll_sub_lines psub,
5780: psp_payroll_lines ppl
5781: Where dlh.payroll_sub_line_id = psub.payroll_sub_line_id
5782: And per.request_id in (select -person_id from psp_supercede_persons_gt where person_id < 0)
5818: per.person_id,
5819: dlh.summary_line_id summary_line_id
5820: From psp_eff_reports per,
5821: Psp_distribution_lines_history DLH,
5822: Psp_payroll_controls ppc,
5823: psp_payroll_sub_lines psub,
5824: psp_payroll_lines ppl
5825: Where dlh.payroll_sub_line_id = psub.payroll_sub_line_id
5826: And per.request_id in (select -person_id from psp_supercede_persons_gt)
5856: per.person_id,
5857: pregen.summary_line_id summary_line_id
5858: From psp_pre_gen_dist_lines_history pregen,
5859: Psp_eff_reports per,
5860: Psp_payroll_controls ppc
5861: Where pregen.distribution_date between per.start_date and per.end_date
5862: And per.request_id in ( select -person_id from psp_supercede_persons_gt )
5863: And ppc.run_id = p_run_id
5864: And pregen.person_id = per.person_id
5893: per.person_id,
5894: min(pal.summary_line_id) summary_line_id
5895: From psp_adjustment_lines_history pal,
5896: Psp_eff_reports per,
5897: Psp_payroll_controls ppc,
5898: psp_eff_report_details perd
5899: Where pal.distribution_date between per.start_date and per.end_date
5900: and perd.effort_report_id = per.effort_report_id
5901: and perd.assignment_id = pal.assignment_id
5928: per.person_id,
5929: min(pregen.summary_line_id)
5930: From psp_pre_gen_dist_lines_history pregen,
5931: Psp_eff_reports per,
5932: Psp_payroll_controls ppc,
5933: psp_eff_report_details perd
5934: Where pregen.distribution_date between per.start_date and per.end_date
5935: and perd.effort_report_id = per.effort_report_id
5936: and perd.assignment_id = pregen.assignment_id
5967: per.person_id,
5968: MIN(dlh.summary_line_id) summary_line_id
5969: From psp_eff_reports per,
5970: Psp_distribution_lines_history DLH,
5971: Psp_payroll_controls ppc,
5972: psp_payroll_sub_lines psub,
5973: psp_payroll_lines ppl,
5974: psp_eff_report_details perd
5975: Where dlh.payroll_sub_line_id = psub.payroll_sub_line_id
6015: per.person_id,
6016: dlh.summary_line_id summary_line_id
6017: From psp_eff_reports per,
6018: Psp_distribution_lines_history DLH,
6019: Psp_payroll_controls ppc,
6020: psp_payroll_sub_lines psub,
6021: psp_payroll_lines ppl,
6022: psp_eff_report_details perd
6023: Where dlh.payroll_sub_line_id = psub.payroll_sub_line_id
6056: per.person_id,
6057: pregen.summary_line_id summary_line_id
6058: From psp_pre_gen_dist_lines_history pregen,
6059: Psp_eff_reports per,
6060: Psp_payroll_controls ppc,
6061: psp_eff_report_details perd
6062: Where pregen.distribution_date between per.start_date and per.end_date
6063: and perd.effort_report_id = per.effort_report_id
6064: and perd.assignment_id = pregen.assignment_id
6095: psp_summary_lines psl
6096: where per.person_id = psl.person_id
6097: and psl.payroll_control_id in
6098: (select payroll_control_id
6099: from psp_payroll_controls
6100: where run_id = p_run_id)
6101: and rownum = 1
6102: and per.request_id in
6103: (select abs(person_id)