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_IN_SOE dependencies on PAY_APAC_PAYSLIP_ELEMENTS_V

Line 262: FROM pay_apac_payslip_elements_v

258: ,'Earnings', element_reporting_name
259: ,'Paid Monetary Perquisite', SUBSTR(element_reporting_name, 0,
260: LENGTH(element_reporting_name) - 8)) ename
261: ,current_amount amt
262: FROM pay_apac_payslip_elements_v
263: WHERE action_context_id = p_action_context_id
264: AND (element_classification = p_classification_name
265: OR element_classification = 'Paid Monetary Perquisite');
266:

Line 272: FROM pay_apac_payslip_elements_v

268: IS
269: --
270: SELECT element_reporting_name ename
271: ,current_amount amt
272: FROM pay_apac_payslip_elements_v
273: WHERE action_context_id = p_action_context_id
274: AND element_classification = p_classification_name;
275:
276: l_total NUMBER;

Line 417: FROM pay_apac_payslip_elements_v

413: CURSOR csr_sum_amt(p_classification_name VARCHAR2)
414: IS
415: --
416: SELECT sum(current_amount) amt
417: FROM pay_apac_payslip_elements_v
418: WHERE action_context_id = p_action_context_id
419: AND element_classification = p_classification_name;
420:
421: l_gross_earnings NUMBER;