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 FND_DATE

Line 831: SELECT SUM(prrv2.RESULT_VALUE) /*fnd_date.canonical_to_date(prrv1.RESULT_VALUE),prrv2.RESULT_VALUE,

827: AND prr.run_result_id = prrv1.run_result_id
828: AND prrv1.input_value_id =pivf.input_value_id --139722 --p_input_value_id;
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,

Line 849: AND fnd_date.canonical_to_date(prrv1.result_value) BETWEEN p_start_date --ADD_MONTHS('15-nov-2000',-12)

845: AND prr.run_result_id = prrv1.run_result_id
846: AND prrv1.input_value_id = p_start_date_iv --139718 --p_start_date_iv
847: AND prr.run_result_id = prrv2.run_result_id
848: AND prrv2.input_value_id = p_waiting_day_iv --139722 --p_full_day_iv
849: AND fnd_date.canonical_to_date(prrv1.result_value) BETWEEN p_start_date --ADD_MONTHS('15-nov-2000',-12)
850: AND p_end_date ; --'15-nov-2000'
851:
852:
853: CURSOR csr_element(p_element_name VARCHAR2)

Line 902: SELECT greatest(fnd_date.canonical_to_date(peevf1.SCREEN_ENTRY_VALUE),csr_v_start_date) date_start,

898:
899: CURSOR csr_absence_period(csr_v_assignment_id NUMBER,
900: csr_v_start_date DATE, csr_v_end_date DATE )
901: IS
902: SELECT greatest(fnd_date.canonical_to_date(peevf1.SCREEN_ENTRY_VALUE),csr_v_start_date) date_start,
903: least(fnd_date.canonical_to_date(peevf2.SCREEN_ENTRY_VALUE),csr_v_end_date) date_end
904: FROM per_all_assignments_f paaf
905: ,pay_element_types_f et
906: ,pay_element_entries_f ee

Line 903: least(fnd_date.canonical_to_date(peevf2.SCREEN_ENTRY_VALUE),csr_v_end_date) date_end

899: CURSOR csr_absence_period(csr_v_assignment_id NUMBER,
900: csr_v_start_date DATE, csr_v_end_date DATE )
901: IS
902: SELECT greatest(fnd_date.canonical_to_date(peevf1.SCREEN_ENTRY_VALUE),csr_v_start_date) date_start,
903: least(fnd_date.canonical_to_date(peevf2.SCREEN_ENTRY_VALUE),csr_v_end_date) date_end
904: FROM per_all_assignments_f paaf
905: ,pay_element_types_f et
906: ,pay_element_entries_f ee
907: ,pay_element_entry_values_f peevf1