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_AMEND_MAG dependencies on HR_ORGANIZATION_INFORMATION

Line 79: hr_organization_information hoi1

75: FROM pay_payroll_actions ppa,
76: pay_assignment_actions paa,
77: per_all_assignments_f paf,
78: pay_payroll_actions ppa1,
79: hr_organization_information hoi1
80: WHERE ppa1.payroll_action_id = p_pactid
81: AND ppa.report_type = 'CAEOY_T4A_AMEND_PP'
82: AND ppa.report_qualifier = 'CAEOY_T4A_AMEND_PPQ'
83: AND ppa.report_category = 'ARCHIVE'

Line 312: FROM hr_organization_information hoi,

308: ----
309: CURSOR c_trans_payid (c_trans_id IN VARCHAR2,
310: c_year IN VARCHAR2) IS
311: SELECT ppa.payroll_action_id,ppa.business_group_id
312: FROM hr_organization_information hoi,
313: pay_payroll_actions ppa
314: WHERE hoi.organization_id = to_number(c_trans_id)
315: AND hoi.org_information_context='Fed Magnetic Reporting'
316: AND ppa.report_type = 'CAEOY_T4A_AMEND_PP' -- T4A Archiver Report Type

Line 333: hr_organization_information hoi,

329: p_year IN VARCHAR2,
330: p_bg_id IN NUMBER) IS
331: SELECT DISTINCT ppa.payroll_action_id, hoi.organization_id, hou.name
332: FROM pay_payroll_actions ppa,
333: hr_organization_information hoi,
334: hr_all_organization_units hou
335: WHERE hoi.org_information_context = 'Canada Employer Identification'
336: AND hoi.org_information11 = p_trans
337: AND hou.business_group_id = p_bg_id