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_ASSIGNMENT_ACTIONS

Line 810: /*FROM pay_assignment_actions paa,

806:
807: SELECT SUM(RESULT_VALUE)--prrv1.* ,paa.assignment_id
808: /* prrv2.result_value fourteenth_date,
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,

Line 833: FROM pay_assignment_actions paa,

829: AND pivf.NAME=p_input_name; --'Waiting Day'*/
830:
831: SELECT SUM(prrv2.RESULT_VALUE) /*fnd_date.canonical_to_date(prrv1.RESULT_VALUE),prrv2.RESULT_VALUE,
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--,

Line 875: FROM pay_assignment_actions paa,

871: csr_v_start_date DATE,
872: csr_v_end_date DATE)
873: IS
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