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

Line 91: from per_all_assignments_f ASG

87: p_assignment_id number
88: ,p_upload_date date
89: ) is
90: select nvl(min(ASG.effective_start_date), END_OF_TIME)
91: from per_all_assignments_f ASG
92: where ASG.assignment_id = p_assignment_id
93: and ASG.effective_start_date <= p_upload_date;
94: --
95: cursor csr_asg_start_date

Line 102: from per_all_assignments_f ASS

98: ,p_expiry_date date
99: ) is
100: select nvl(greatest(min(ASS.effective_start_date), p_expiry_date),
101: END_OF_TIME)
102: from per_all_assignments_f ASS
103: where ASS.assignment_id = p_assignment_id
104: and ASS.effective_start_date <= p_upload_date
105: and ASS.effective_end_date >= p_expiry_date;
106: --