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_WORK_TIME_CERTIFICATE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 521: ,csr_v_information_type per_assignment_extra_info.information_type%TYPE

517: lr_assignment_info csr_assignment_info%ROWTYPE;
518:
519: CURSOR csr_extra_assignment_info (
520: csr_v_assignment_id per_all_assignments_f.person_id%TYPE
521: ,csr_v_information_type per_assignment_extra_info.information_type%TYPE
522: )
523: IS
524: SELECT *
525: FROM per_assignment_extra_info

Line 525: FROM per_assignment_extra_info

521: ,csr_v_information_type per_assignment_extra_info.information_type%TYPE
522: )
523: IS
524: SELECT *
525: FROM per_assignment_extra_info
526: WHERE assignment_id = csr_v_assignment_id
527: AND information_type = csr_v_information_type;
528:
529: lr_extra_assignment_info csr_extra_assignment_info%ROWTYPE;

Line 533: ,csr_v_year per_assignment_extra_info.aei_information1%TYPE

529: lr_extra_assignment_info csr_extra_assignment_info%ROWTYPE;
530:
531: CURSOR csr_se_wtc_time_worked_info (
532: csr_v_assignment_id per_all_assignments_f.person_id%TYPE
533: ,csr_v_year per_assignment_extra_info.aei_information1%TYPE
534: )
535: IS
536: SELECT *
537: FROM per_assignment_extra_info

Line 537: FROM per_assignment_extra_info

533: ,csr_v_year per_assignment_extra_info.aei_information1%TYPE
534: )
535: IS
536: SELECT *
537: FROM per_assignment_extra_info
538: WHERE assignment_id = csr_v_assignment_id
539: AND information_type = 'SE_WTC_TIME_WORKED_INFO'
540: AND aei_information1 = csr_v_year;
541: