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.PAY_SE_STAT_OFFICE_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

Line 494: pay_run_result_values prrv1,

490: prrv4.result_value part_day
491: FROM pay_assignment_actions paa,
492: pay_payroll_actions ppa,
493: pay_run_results prr,
494: pay_run_result_values prrv1,
495: pay_run_result_values prrv2,
496: pay_run_result_values prrv3,
497: pay_run_result_values prrv4
498: WHERE ppa.effective_date BETWEEN p_report_start_date

Line 495: pay_run_result_values prrv2,

491: FROM pay_assignment_actions paa,
492: pay_payroll_actions ppa,
493: pay_run_results prr,
494: pay_run_result_values prrv1,
495: pay_run_result_values prrv2,
496: pay_run_result_values prrv3,
497: pay_run_result_values prrv4
498: WHERE ppa.effective_date BETWEEN p_report_start_date
499: AND p_report_end_date

Line 496: pay_run_result_values prrv3,

492: pay_payroll_actions ppa,
493: pay_run_results prr,
494: pay_run_result_values prrv1,
495: pay_run_result_values prrv2,
496: pay_run_result_values prrv3,
497: pay_run_result_values prrv4
498: WHERE ppa.effective_date BETWEEN p_report_start_date
499: AND p_report_end_date
500: AND ppa.payroll_action_id = paa.payroll_action_id

Line 497: pay_run_result_values prrv4

493: pay_run_results prr,
494: pay_run_result_values prrv1,
495: pay_run_result_values prrv2,
496: pay_run_result_values prrv3,
497: pay_run_result_values prrv4
498: WHERE ppa.effective_date BETWEEN p_report_start_date
499: AND p_report_end_date
500: AND ppa.payroll_action_id = paa.payroll_action_id
501: AND paa.assignment_id = p_assignment_id

Line 527: pay_run_result_values prrv1

523: SELECT max(to_number(prrv1.result_value)) full_day
524: FROM pay_assignment_actions paa,
525: pay_payroll_actions ppa,
526: pay_run_results prr,
527: pay_run_result_values prrv1
528: WHERE ppa.effective_date BETWEEN p_report_start_date
529: AND p_report_end_date
530: AND ppa.payroll_action_id = paa.payroll_action_id
531: AND paa.assignment_id = p_assignment_id

Line 555: pay_run_result_values prrv1,

551: prrv4.result_value employer_days
552: FROM pay_assignment_actions paa,
553: pay_payroll_actions ppa,
554: pay_run_results prr,
555: pay_run_result_values prrv1,
556: pay_run_result_values prrv2,
557: pay_run_result_values prrv3,
558: pay_run_result_values prrv4
559: WHERE ppa.effective_date BETWEEN p_report_start_date

Line 556: pay_run_result_values prrv2,

552: FROM pay_assignment_actions paa,
553: pay_payroll_actions ppa,
554: pay_run_results prr,
555: pay_run_result_values prrv1,
556: pay_run_result_values prrv2,
557: pay_run_result_values prrv3,
558: pay_run_result_values prrv4
559: WHERE ppa.effective_date BETWEEN p_report_start_date
560: AND p_report_end_date

Line 557: pay_run_result_values prrv3,

553: pay_payroll_actions ppa,
554: pay_run_results prr,
555: pay_run_result_values prrv1,
556: pay_run_result_values prrv2,
557: pay_run_result_values prrv3,
558: pay_run_result_values prrv4
559: WHERE ppa.effective_date BETWEEN p_report_start_date
560: AND p_report_end_date
561: AND ppa.payroll_action_id = paa.payroll_action_id

Line 558: pay_run_result_values prrv4

554: pay_run_results prr,
555: pay_run_result_values prrv1,
556: pay_run_result_values prrv2,
557: pay_run_result_values prrv3,
558: pay_run_result_values prrv4
559: WHERE ppa.effective_date BETWEEN p_report_start_date
560: AND p_report_end_date
561: AND ppa.payroll_action_id = paa.payroll_action_id
562: AND paa.assignment_id = p_assignment_id