DBA Data[Home] [Help]

APPS.PAY_CA_T4A_AMEND_MAG dependencies on PYCADAR_PKG

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

16: pay_payroll_actions ppa
17: WHERE hoi.organization_id = pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE')
18: AND hoi.org_information_context = 'Fed Magnetic Reporting'
19: AND ppa.report_type = 'CAEOY_T4A_AMEND_PP'
20: AND hoi.organization_id = pycadar_pkg.get_parameter('TRANSFER_GRE'
21: ,ppa.legislative_parameters)
22: AND to_char(ppa.effective_date
23: ,'YYYY') = pay_magtape_generic.get_parameter_value('REPORTING_YEAR')
24: AND to_char(ppa.effective_date

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

54: AND to_char(ppa.effective_date
55: ,'YYYY') = pay_magtape_generic.get_parameter_value('REPORTING_YEAR')
56: AND to_char(ppa.effective_date
57: ,'DD-MM') = '31-12'
58: AND hoi1.organization_id = pycadar_pkg.get_parameter('TRANSFER_GRE'
59: ,ppa.legislative_parameters)
60: AND fdi.user_name = 'CAEOY_EMPLOYER_NAME'
61: AND ppa.payroll_action_id = fai.context1
62: AND fdi.user_entity_id = fai.user_entity_id