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_T4A_MAG dependencies on PAY_ACTION_INFORMATION

Line 362: from pay_action_information pai,pay_payroll_actions ppa

358: cursor c_get_reg_no(cp_pact_id number,
359: cp_tax_unit_id number) is
360: select to_number(pai.action_information5) ppreg_amt,
361: pai.action_information4 ppreg_no
362: from pay_action_information pai,pay_payroll_actions ppa
363: where pai.action_context_id = cp_pact_id
364: and pai.tax_unit_id = cp_tax_unit_id
365: and ppa.payroll_action_id = pai.action_context_id
366: and pai.effective_date = ppa.effective_date

Line 415: from pay_action_information pai

411:
412: FUNCTION get_t4a_footnote_amounts ( p_assignment_action_id in number,p_footnote_code IN VARCHAR2) RETURN varchar2 IS
413: cursor c_get_footnote_amount( cp_assignment_action_id number,cp_footnote_code varchar2) is
414: select pai.action_information5
415: from pay_action_information pai
416: where pai.action_context_id = cp_assignment_action_id
417: and pai.action_information_category = 'CA FOOTNOTES'
418: and pai.action_information4 = cp_footnote_code
419: order by 1 desc;