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.HRI_OPL_CMNTS_ACTLS dependencies on HRI_MB_ACTLS_CT

Line 145: FROM hri_mb_actls_ct actl

141: ,nvl(cmnts.grade_id, -1) grade_id
142: ,cmnts.element_type_id
143: ,cmnts.input_value_id
144: ,(SELECT distinct actl.cost_allocation_keyflex_id
145: FROM hri_mb_actls_ct actl
146: WHERE actl.assignment_id = cmnts.assignment_id
147: AND actl.element_type_id = cmnts.element_type_id
148: -- AND actl.input_value_id = cmnts.input_value_id
149: AND actl.effective_date BETWEEN cmnts.effective_start_date AND cmnts.effective_end_date

Line 153: FROM hri_mb_actls_ct actls

149: AND actl.effective_date BETWEEN cmnts.effective_start_date AND cmnts.effective_end_date
150: AND ROWNUM = 1) cost_allocation_keyflex_id
151: ,cmnts.commitment_value
152: ,(SELECT sum(actls.actual_value)
153: FROM hri_mb_actls_ct actls
154: WHERE actls.assignment_id = cmnts.assignment_id
155: AND actls.element_type_id = cmnts.element_type_id
156: AND actls.input_value_id = NVL(( SELECT input_value_id
157: FROM pay_input_values_f