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_ARCHIVE_TETA dependencies on PER_ALL_ASSIGNMENTS_F

Line 259: per_all_assignments_f assign

255: , csr_v_effective_date DATE )
256: IS
257: SELECT assign.assignment_id
258: FROM
259: per_all_assignments_f assign
260: ,hr_soft_coding_keyflex scl
261: ,hr_organization_units o1
262: ,hr_organization_information hoi1
263: ,hr_organization_information hoi2

Line 380: per_all_assignments_f assign

376: ,hoi3.organization_id, assign.employment_category
377: , trunc(assign.effective_start_date) effective_start_date
378: ,trunc(decode(assign.effective_end_date,to_date('31/12/4712','dd/mm/yyyy'), g_date_report ,assign.effective_end_date) ) effective_end_date
379: FROM
380: per_all_assignments_f assign
381: ,hr_soft_coding_keyflex scl
382: ,hr_organization_units o1
383: ,hr_organization_information hoi1
384: ,hr_organization_information hoi2

Line 415: per_all_assignments_f assign

411: SELECT assign.assignment_id
412: ,hoi3.organization_id, assign.employment_category
413: ,sum(decode(assign.effective_end_date,to_date('31/12/4712','dd/mm/yyyy'), g_date_report ,assign.effective_end_date) - assign.effective_start_date ) days_worked
414: FROM
415: per_all_assignments_f assign
416: ,hr_soft_coding_keyflex scl
417: ,hr_organization_units o1
418: ,hr_organization_information hoi1
419: ,hr_organization_information hoi2