APPS.PAY_CA_T4A_CANCEL_MAG dependencies on HR_ORGANIZATION_INFORMATION

Line 15: hr_organization_information hoi

11: to_char(hoi.organization_id)
12: FROM
13: pay_payroll_actions ppa,
14: pay_assignment_actions paa,
15: hr_organization_information hoi
16: WHERE
17: ppa.payroll_action_id = paa.payroll_action_id
18: AND hoi.org_information_context = 'Fed Magnetic Reporting'
19: AND hoi.organization_id = paa.tax_unit_id

Line 34: hr_organization_information hoi

30: pay_payroll_actions ppa1,
31: pay_assignment_actions paa,
32: pay_assignment_actions paa1,
33: pay_action_interlocks int,
34: hr_organization_information hoi
35: WHERE
36: ppa.payroll_action_id = paa.payroll_action_id
37: AND hoi.org_information_context = 'Fed Magnetic Reporting'
38: AND hoi.organization_id = paa1.tax_unit_id

Line 65: hr_organization_information hoi1

61: pay_assignment_actions paa,
62: pay_payroll_actions ppa1,
63: pay_assignment_actions paa1,
64: pay_action_interlocks int,
65: hr_organization_information hoi1
66: WHERE paa.payroll_action_id = ppa.payroll_action_id
67: AND hoi1.organization_id = paa1.tax_unit_id
68: AND ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))
69: AND int.locking_action_id = paa.assignment_action_id