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.HXC_TK_GRP_QUERY_CRITERIA_API dependencies on FND_SESSIONS

Line 727: FROM per_assignments_f asg,fnd_sessions ss,per_people_f ppf

723: WHERE p.person_id = p_criteria_id;
724:
725: CURSOR csr_get_full_name IS
726: SELECT ppf.full_name
727: FROM per_assignments_f asg,fnd_sessions ss,per_people_f ppf
728: WHERE asg.effective_start_date <= ss.effective_date
729: AND asg.effective_end_date >= ss.effective_date
730: AND ss.session_id = USERENV ('sessionid')
731: AND ppf.effective_start_date <= ss.effective_date

Line 877: FROM fnd_sessions

873: WHERE rp.recurring_period_id = TO_NUMBER(p_rp_id);
874:
875: CURSOR csr_get_effective_date IS
876: SELECT effective_date
877: FROM fnd_sessions
878: WHERE session_id = USERENV('sessionid');
879:
880: BEGIN
881:

Line 944: FROM fnd_sessions

940: l_audit VARCHAR2(150);
941:
942: CURSOR csr_get_effective_date IS
943: SELECT effective_date
944: FROM fnd_sessions
945: WHERE session_id = USERENV('SESSIONID');
946:
947: BEGIN
948: