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_GB_COURT_ORDER_UPGRADE dependencies on DUAL

Line 146: from dual

142: l_result_rec.assignment_action_id
143: ,l_result_rec.assignment_id
144: ,l_context_id
145: ,l_result_rec.result_value
146: from dual
147: where NOT EXISTS (SELECT NULL
148: FROM pay_action_contexts pac
149: WHERE pac.assignment_id = l_result_rec.assignment_id
150: AND pac.assignment_action_id = l_result_rec.assignment_action_id

Line 197: FROM dual;

193: -- To get date
194: CURSOR csr_date
195: is
196: SELECT to_date(SYSDATE,'DD-MM-YYYY')
197: FROM dual;
198:
199:
200: -- To get defined balance id
201: CURSOR csr_defined_balance_id