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_EFFORTS_PKG dependencies on PSP_SUMMARY_LINES

Line 538: psp_summary_lines psl

534: 'distribution_lines' source
535: FROM psp_distribution_lines_history pdlh,
536: psp_payroll_sub_lines pps,
537: psp_payroll_lines ppl,
538: psp_summary_lines psl
539: WHERE
540: psl.person_id = person_id1 AND
541: pdlh.summary_line_id = psl.summary_line_id AND
542: psl.status_code||''='A' and

Line 574: psp_summary_lines psl

570: TO_NUMBER(NULL),
571: TO_NUMBER(NULL),
572: 'pre_gen_dist_lines'
573: FROM psp_pre_gen_dist_lines_history ppgh,
574: psp_summary_lines psl
575: WHERE
576: psl.person_id=person_id1 and
577: ppgh.summary_line_id=psl.summary_line_id
578: and psl.status_code||''='A' and

Line 607: psp_summary_lines psl

603: TO_NUMBER(NULL),
604: TO_NUMBER(NULL),
605: 'adjustment_lines'
606: FROM psp_adjustment_lines_history palh,
607: psp_summary_lines psl
608: WHERE
609: psl.person_id=person_id1 and
610: palh.summary_line_id=psl.summary_line_id and
611: psl.status_code||''='A' and

Line 653: psp_Summary_lines psl,

649: effective_start_date,
650: to_date(NULL) effective_end_date
651: FROM
652: per_all_assignments_f paf,
653: psp_Summary_lines psl,
654: psp_effort_report_templates pet
655: WHERE
656: (pet.template_id=a_template_id and
657: pet.person_id is null and

Line 716: FROM psp_Summary_lines psl,

712: SELECT
713: pet.person_id,
714: pet.effective_start_date,
715: pet.effective_end_date
716: FROM psp_Summary_lines psl,
717: psp_effort_report_templates pet
718: WHERE
719: pet.template_id=a_template_id and
720: pet.person_id=psl.person_id and