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 495: pay_run_result_values prrv1,

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

Line 496: pay_run_result_values prrv2,

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

Line 497: pay_run_result_values prrv3,

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

Line 498: pay_run_result_values prrv4

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

Line 528: pay_run_result_values prrv1

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

Line 556: pay_run_result_values prrv1,

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

Line 557: pay_run_result_values prrv2,

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

Line 558: pay_run_result_values prrv3,

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

Line 559: pay_run_result_values prrv4

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