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

Line 180: FROM pay_assignment_actions paa, per_all_assignments_f paf

176: */
177: /* 9761058 start */
178: CURSOR csr_assignment IS
179: SELECT paf.assignment_id, paf.business_group_id
180: FROM pay_assignment_actions paa, per_all_assignments_f paf
181: WHERE paa.assignment_action_id=p_assignment_action_id
182: AND paa.assignment_id=paf.assignment_id
183: AND p_effective_date BETWEEN paf.EFFECTIVE_START_DATE AND paf.EFFECTIVE_END_DATE ;
184:

Line 197: FROM PER_ALL_ASSIGNMENTS_F ASG

193: ,HR_ORGANIZATION_INFORMATION hoi2
194: ,HR_ORGANIZATION_INFORMATION hoi3
195: ,HR_ORGANIZATION_INFORMATION hoi4
196: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
197: FROM PER_ALL_ASSIGNMENTS_F ASG
198: ,HR_SOFT_CODING_KEYFLEX SCL
199: WHERE ASG.ASSIGNMENT_ID = l_assignment_id
200: AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID
201: AND p_effective_date BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE ) X