DBA Data[Home] [Help]

APPS.PAY_CA_T4_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 41: hr_organization_information hoi1

37: pay_assignment_actions paa,
38: pay_payroll_actions ppa1,
39: pay_assignment_actions paa1,
40: pay_action_interlocks int,
41: hr_organization_information hoi1
42: WHERE paa.payroll_action_id = ppa.payroll_action_id
43: AND hoi1.organization_id = paa1.tax_unit_id
44: AND ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))
45: AND int.locking_action_id = paa.assignment_action_id