DBA Data[Home] [Help]

APPS.PAY_CA_RL1_MAG dependencies on PAY_CA_LEGISLATION_INFO

Line 51: pay_ca_legislation_info pcli

47: Select 'PAYROLL_ACTION_ID=P',ppa.payroll_action_id,
48: 'TRANSFER_CPP_MAX=P', pcli.information_value
49: FROM hr_organization_information hoi,
50: pay_payroll_actions PPA,
51: pay_ca_legislation_info pcli
52: WHERE to_char(hoi.organization_id) = pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')
53: and hoi.org_information_context='Prov Reporting Est'
54: and ppa.report_type = 'RL1' -- RL1 Archiver Report Type
55: and to_char(hoi.organization_id) = substr(ppa.legislative_parameters,instr(ppa.legislative_parameters,'PRE_ORGANIZATION_ID=')+LENGTH('PRE_ORGANIZATION_ID='))