APPS.PAY_CA_T4_AMEND_MAG dependencies on HR_ORGANIZATION_INFORMATION

Line 77: hr_organization_information hoi1

73: FROM pay_payroll_actions ppa,
74: pay_assignment_actions paa,
75: per_all_assignments_f paf,
76: pay_payroll_actions ppa1,
77: hr_organization_information hoi1
78: WHERE ppa1.payroll_action_id = p_pactid
79: AND ppa.report_type = 'CAEOY_T4_AMEND_PP'
80: AND ppa.report_qualifier = 'CAEOY_T4_AMEND_PPQ'
81: AND ppa.report_category = 'ARCHIVE'

Line 301: FROM hr_organization_information hoi,

297: ----
298: CURSOR c_trans_payid (c_trans_id IN VARCHAR2,
299: c_year IN VARCHAR2) IS
300: SELECT ppa.payroll_action_id,ppa.business_group_id
301: FROM hr_organization_information hoi,
302: pay_payroll_actions ppa
303: WHERE hoi.organization_id = to_number(c_trans_id)
304: AND hoi.org_information_context='Fed Magnetic Reporting'
305: AND ppa.report_type = 'CAEOY_T4_AMEND_PP' -- T4 Archiver Report Type

Line 322: hr_organization_information hoi,

318: p_year IN VARCHAR2,
319: p_bg_id IN NUMBER) IS
320: SELECT DISTINCT ppa.payroll_action_id, hoi.organization_id, hou.name
321: FROM pay_payroll_actions ppa,
322: hr_organization_information hoi,
323: hr_all_organization_units hou
324: WHERE hoi.org_information_context = 'Canada Employer Identification'
325: AND hoi.org_information11 = p_trans
326: AND hou.business_group_id = p_bg_id