APPS.PSP_CREATE_EFF_REPORTS dependencies on PSP_ADJUSTMENT_LINES

Line 388: psp_adjustment_lineS_history pal,

384: psp_distribution_lines_history pdnh,
385: psp_summary_lines psl,
386: psp_Selected_persons_t pspt,
387: psp_pre_gen_dist_lines_history ppg,
388: psp_adjustment_lineS_history pal,
389: psp_payroll_sub_lines ppsl,
390: psp_payroll_lines ppl
391: WHERE psl.person_id = pspt.person_id
392: and pspt.request_id = :l_request_id

Line 1463: exists (select nvl(person_id,0) from psp_adjustment_lines where effective_date between g_psp_effort_start

1459: select psp_report_errors_s.nextval, p_request_id,'W',
1460: pspt.person_id , l_msg_str, p_retry_request_id , null, NULL, NULL, NULL
1461: from psp_selected_persons_t pspt where pspt.person_id between p_start_person and p_end_person and
1462: pspt.request_id = p_request_id and
1463: exists (select nvl(person_id,0) from psp_adjustment_lines where effective_date between g_psp_effort_start
1464: and g_psp_effort_end ) and pspt.person_id not in (select source_id from psp_report_errors where request_id=p_request_id) and
1465: pspt.person_id not in (select nvl(person_id, 0) from psp_eff_reports where g_psp_effort_end>=start_date and
1466: g_psp_effort_start <= end_date);
1467: end if;