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

Line 474: FROM PER_ALL_ASSIGNMENTS_F ASG

470: ,HR_ORGANIZATION_INFORMATION hoi2
471: ,HR_ORGANIZATION_INFORMATION hoi3
472: ,HR_ORGANIZATION_INFORMATION hoi4
473: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
474: FROM PER_ALL_ASSIGNMENTS_F ASG
475: ,HR_SOFT_CODING_KEYFLEX SCL
476: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
477: AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID
478: AND p_date_earned BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE ) X

Line 608: FROM per_all_assignments_f paaf

604: IS
605: SELECT fnd_date.canonical_to_date(peevf1.SCREEN_ENTRY_VALUE) start_date
606: ,fnd_date.canonical_to_date(peevf2.SCREEN_ENTRY_VALUE) end_date
607: ,fnd_number.canonical_to_number(peevf4.SCREEN_ENTRY_VALUE) Absence_Percentage
608: FROM per_all_assignments_f paaf
609: ,pay_element_types_f et
610: ,pay_element_entries_f ee
611: ,pay_element_entry_values_f peevf1
612: ,pay_element_entry_values_f peevf2

Line 665: FROM PER_ALL_ASSIGNMENTS_F ASG

661: ,HR_ORGANIZATION_INFORMATION hoi2
662: ,HR_ORGANIZATION_INFORMATION hoi3
663: ,HR_ORGANIZATION_INFORMATION hoi4
664: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
665: FROM PER_ALL_ASSIGNMENTS_F ASG
666: ,HR_SOFT_CODING_KEYFLEX SCL
667: WHERE ASG.ASSIGNMENT_ID = csr_v_assignment_id
668: AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID
669: AND csr_v_effective_date BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE ) X