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_BF_BAL_UPLOAD dependencies on HR_SOFT_CODING_KEYFLEX

Line 77: ,hr_soft_coding_keyflex SCL

73: ,p_effective_date date
74: ) is
75: select to_number(SCL.segment1) tax_unit_id
76: from per_assignments_f ASG
77: ,hr_soft_coding_keyflex SCL
78: where ASG.assignment_id = p_assignment_id
79: and SCL.soft_coding_keyflex_id = ASG.soft_coding_keyflex_id
80: and p_effective_date between ASG.effective_start_date
81: and ASG.effective_end_date;

Line 204: ,hr_soft_coding_Keyflex SCL

200: ) is
201: select nvl(greatest(p_expiry_date, min(ASS.effective_start_date)),
202: END_OF_TIME)
203: from per_assignments_f ASS
204: ,hr_soft_coding_Keyflex SCL
205: where ASS.assignment_id = p_assignment_id
206: and ASS.effective_start_date <= p_upload_date
207: and ASS.effective_end_date >= p_expiry_date
208: and SCL.soft_coding_keyflex_id = ASS.soft_coding_keyflex_id

Line 236: ,hr_soft_coding_keyflex SCL

232: ) is
233: select nvl(min(ASS.effective_start_date),
234: END_OF_TIME)
235: from per_assignments_f ASS
236: ,hr_soft_coding_keyflex SCL
237: where ASS.assignment_id = p_assignment_id
238: and SCL.soft_coding_keyflex_id = ASS.soft_coding_keyflex_id
239: and ASS.effective_start_date <= p_upload_date
240: and SCL.segment1 = to_char(p_tax_unit_id);