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_ABSENCE dependencies on PAY_RUN_RESULT_VALUES

Line 813: pay_run_result_values prrv1,

809: prrv3.result_value end_date*/
810: /*FROM pay_assignment_actions paa,
811: pay_payroll_actions ppa,
812: pay_run_results prr,
813: pay_run_result_values prrv1,
814: pay_input_values_f pivf,
815: pay_element_types_f petf
816: /* pay_run_result_values prrv2,
817: pay_run_result_values prrv3*/

Line 816: /* pay_run_result_values prrv2,

812: pay_run_results prr,
813: pay_run_result_values prrv1,
814: pay_input_values_f pivf,
815: pay_element_types_f petf
816: /* pay_run_result_values prrv2,
817: pay_run_result_values prrv3*/
818: /*WHERE ppa.effective_date BETWEEN p_group_start_date --'01-jun-1999' --p_report_start_date
819: /* AND p_group_end_date /*'01-jun-2000' */--p_report_end_date
820: /* AND ppa.payroll_action_id = paa.payroll_action_id

Line 817: pay_run_result_values prrv3*/

813: pay_run_result_values prrv1,
814: pay_input_values_f pivf,
815: pay_element_types_f petf
816: /* pay_run_result_values prrv2,
817: pay_run_result_values prrv3*/
818: /*WHERE ppa.effective_date BETWEEN p_group_start_date --'01-jun-1999' --p_report_start_date
819: /* AND p_group_end_date /*'01-jun-2000' */--p_report_end_date
820: /* AND ppa.payroll_action_id = paa.payroll_action_id
821: AND paa.assignment_id =p_assignment_id --21035 --p_assignment_id

Line 836: pay_run_result_values prrv1,

832: ADD_MONTHS('15-nov-2000',-12), '15-nov-2000' --*, prrv1.result_value*/
833: FROM pay_assignment_actions paa,
834: pay_payroll_actions ppa,
835: pay_run_results prr,
836: pay_run_result_values prrv1,
837: pay_run_result_values prrv2--,
838: -- pay_run_result_values prrv3
839: WHERE ppa.effective_date BETWEEN p_start_date --ADD_MONTHS('15-nov-2000',-12)
840: AND p_end_date --'15-nov-2000'

Line 837: pay_run_result_values prrv2--,

833: FROM pay_assignment_actions paa,
834: pay_payroll_actions ppa,
835: pay_run_results prr,
836: pay_run_result_values prrv1,
837: pay_run_result_values prrv2--,
838: -- pay_run_result_values prrv3
839: WHERE ppa.effective_date BETWEEN p_start_date --ADD_MONTHS('15-nov-2000',-12)
840: AND p_end_date --'15-nov-2000'
841: AND ppa.payroll_action_id = paa.payroll_action_id

Line 838: -- pay_run_result_values prrv3

834: pay_payroll_actions ppa,
835: pay_run_results prr,
836: pay_run_result_values prrv1,
837: pay_run_result_values prrv2--,
838: -- pay_run_result_values prrv3
839: WHERE ppa.effective_date BETWEEN p_start_date --ADD_MONTHS('15-nov-2000',-12)
840: AND p_end_date --'15-nov-2000'
841: AND ppa.payroll_action_id = paa.payroll_action_id
842: AND paa.assignment_id = p_assignment_id --22145 -- p_assignment_id

Line 878: pay_run_result_values prrv1--,

874: SELECT nvl(SUM(prrv1.RESULT_VALUE),0)
875: FROM pay_assignment_actions paa,
876: pay_payroll_actions ppa,
877: pay_run_results prr,
878: pay_run_result_values prrv1--,
879: --pay_run_result_values prrv2
880: WHERE ppa.effective_date BETWEEN csr_v_start_date --ADD_MONTHS('15-nov-2000',-12)
881: AND csr_v_end_date --'15-nov-2000'
882: AND ppa.payroll_action_id = paa.payroll_action_id

Line 879: --pay_run_result_values prrv2

875: FROM pay_assignment_actions paa,
876: pay_payroll_actions ppa,
877: pay_run_results prr,
878: pay_run_result_values prrv1--,
879: --pay_run_result_values prrv2
880: WHERE ppa.effective_date BETWEEN csr_v_start_date --ADD_MONTHS('15-nov-2000',-12)
881: AND csr_v_end_date --'15-nov-2000'
882: AND ppa.payroll_action_id = paa.payroll_action_id
883: AND paa.assignment_id = csr_v_assignment_id --22145 -- p_assignment_id