DBA Data[Home] [Help]

APPS.PAY_CA_RL1_AMEND_MAG dependencies on PAY_CA_RL1_REG

Line 69: pay_ca_rl1_reg.get_parameter('PRE_ORGANIZATION_ID', ppa.legislative_parameters)

65: WHERE decode(hoi.org_information3,'Y',to_char(hoi.organization_id) ,hoi.org_information20) =
66: pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')
67: and hoi.org_information_context='Prov Reporting Est'
68: and to_char(hoi.organization_id) =
69: pay_ca_rl1_reg.get_parameter('PRE_ORGANIZATION_ID', ppa.legislative_parameters)
70: and ppa.action_status = 'C'
71: and to_char(ppa.effective_date,'YYYY') = pay_magtape_generic.get_parameter_value('REPORTING_YEAR')
72: and to_char(ppa.effective_date,'DD-MM') = '31-12'
73: and ppa.report_type= 'CAEOY_RL1_AMEND_PP'