APPS.PAY_CA_RL2_AMEND_MAG dependencies on HR_ORGANIZATION_INFORMATION

Line 31: FROM hr_organization_information hoi,

27:
28: CURSOR mag_amend_rl2_transmitter IS
29: SELECT 'BUSINESS_GROUP_ID=C',ppa.business_group_id,
30: 'PAYROLL_ACTION_ID=P',MAX(ppa.payroll_action_id)
31: FROM hr_organization_information hoi,
32: pay_payroll_actions ppa
33: WHERE to_char(hoi.organization_id) = pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')
34: AND hoi.org_information_context='Prov Reporting Est'
35: AND ppa.report_type = 'CAEOY_RL2_AMEND_PP' -- RL2 Amendment Archiver Report Type

Line 57: hr_organization_information hoi

53: 'BUSINESS_GROUP_ID=C',ppa.business_group_id,
54: 'PAYROLL_ACTION_ID=C',MAX(ppa.payroll_action_id),
55: 'PAYROLL_ACTION_ID=P',MAX(ppa.payroll_action_id)
56: FROM pay_payroll_actions ppa,
57: hr_organization_information hoi
58: WHERE decode(hoi.org_information3,'Y',to_char(hoi.organization_id) ,hoi.org_information20) =
59: pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')
60: AND hoi.org_information_context='Prov Reporting Est'
61: AND to_char(hoi.organization_id) = pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)