DBA Data[Home] [Help]

APPS.PAY_CA_T4_AMEND_MAG dependencies on PYCADAR_PKG

Line 23: AND hoi.organization_id = pycadar_pkg.get_parameter('TRANSFER_GRE'

19: pay_ca_legislation_info pcli2
20: WHERE hoi.organization_id = pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE')
21: AND hoi.org_information_context = 'Fed Magnetic Reporting'
22: AND ppa.report_type = 'CAEOY_T4_AMEND_PP'
23: AND hoi.organization_id = pycadar_pkg.get_parameter('TRANSFER_GRE'
24: ,ppa.legislative_parameters)
25: AND to_char(ppa.effective_date
26: ,'YYYY') = pay_magtape_generic.get_parameter_value('REPORTING_YEAR')
27: AND to_char(ppa.effective_date

Line 63: AND hoi1.organization_id = pycadar_pkg.get_parameter('TRANSFER_GRE'

59: AND to_char(ppa.effective_date
60: ,'YYYY') = pay_magtape_generic.get_parameter_value('REPORTING_YEAR')
61: AND to_char(ppa.effective_date
62: ,'DD-MM') = '31-12'
63: AND hoi1.organization_id = pycadar_pkg.get_parameter('TRANSFER_GRE'
64: ,ppa.legislative_parameters)
65: AND fdi.user_name = 'CAEOY_EMPLOYER_NAME'
66: AND ppa.payroll_action_id = fai.context1
67: AND fdi.user_entity_id = fai.user_entity_id