APPS.PAY_CA_RL2_MAG dependencies on PYCADAR_PKG

Line 75: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID', ppa.legislative_parameters)

71: WHERE decode(hoi.org_information3,'Y',to_char(hoi.organization_id) ,hoi.org_information20) =
72: pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')
73: AND hoi.org_information_context='Prov Reporting Est'
74: AND to_char(hoi.organization_id) =
75: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID', ppa.legislative_parameters)
76: AND ppa.action_status = 'C'
77: AND to_char(ppa.effective_date,'YYYY') = pay_magtape_generic.get_parameter_value('REPORTING_YEAR')
78: AND to_char(ppa.effective_date,'DD-MM') = '31-12'
79: AND ppa.report_type = 'RL2';