DBA Data[Home] [Help]

APPS.PAY_CA_T4_MAG dependencies on PAY_CA_LEGISLATION_INFO

Line 984: pay_ca_legislation_info pcli,

980: c_year VARCHAR2) is
981: Select ppa.payroll_action_id, ppa.business_group_id
982: from hr_organization_information hoi,
983: pay_payroll_actions PPA,
984: pay_ca_legislation_info pcli,
985: pay_ca_legislation_info pcli1
986: where hoi.organization_id = to_number(c_trans_id)
987: and hoi.org_information_context='Fed Magnetic Reporting'
988: and ppa.report_type = 'T4' -- T4 Archiver Report Type

Line 985: pay_ca_legislation_info pcli1

981: Select ppa.payroll_action_id, ppa.business_group_id
982: from hr_organization_information hoi,
983: pay_payroll_actions PPA,
984: pay_ca_legislation_info pcli,
985: pay_ca_legislation_info pcli1
986: where hoi.organization_id = to_number(c_trans_id)
987: and hoi.org_information_context='Fed Magnetic Reporting'
988: and ppa.report_type = 'T4' -- T4 Archiver Report Type
989: and hoi.organization_id = substr(ppa.legislative_parameters,instr(ppa.legislative_parameters,'TRANSFER_GRE=')+LENGTH('TRANSFER_GRE='))