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

Line 94: ,per_all_assignments_f paf

90: select segment1 T4_RL1_GRE
91: ,segment11 T4A_RL1_GRE
92: ,segment12 T4A_RL2_GRE
93: from hr_soft_coding_keyflex hsck
94: ,per_all_assignments_f paf
95: ,pay_assignment_actions paa
96: ,pay_payroll_actions ppa
97: where paa.assignment_action_id = cp_asg_act_id
98: and ppa.payroll_action_id = paa.payroll_action_id

Line 116: ,per_all_assignments_f paf

112: decode(segment11, NULL, 0, 1 ) +
113: decode(segment12, NULL, 0, 1 ) tot_no_of_tu
114: ,nvl(segment1, nvl(segment11,segment12) ) tax_unit_id
115: from hr_soft_coding_keyflex hsck
116: ,per_all_assignments_f paf
117: ,pay_assignment_actions paa
118: ,pay_payroll_actions ppa
119: where paa.assignment_action_id = cp_asg_act_id
120: and ppa.payroll_action_id = paa.payroll_action_id

Line 365: per_all_assignments_f ASSIGN

361: p_assignment_id number) IS
362: SELECT target.SEGMENT4
363: FROM /* route for SCL keyflex - assignment level */
364: hr_soft_coding_keyflex target,
365: per_all_assignments_f ASSIGN
366: WHERE p_date_earned BETWEEN ASSIGN.effective_start_date
367: AND ASSIGN.effective_end_date
368: AND ASSIGN.assignment_id = p_assignment_id
369: AND target.soft_coding_keyflex_id = ASSIGN.soft_coding_keyflex_id