DBA Data[Home] [Help]

APPS.PAY_CA_RL2_MAG dependencies on HR_ORGANIZATION_INFORMATION

Line 233: hr_organization_information hoi

229: pay_ca_eoy_rl2_trans_info_v tran,
230: pay_assignment_actions paa_arch,
231: pay_payroll_actions ppa_arch,
232: pay_payroll_actions ppa_mag,
233: hr_organization_information hoi
234: where ppa_mag.payroll_action_id = :payroll_action_id
235: and ppa_arch.business_group_id+0 = ppa_mag.business_group_id
236: and ppa_arch.effective_date = ppa_mag.effective_date
237: and ppa_arch.report_type = ''RL2''

Line 296: hr_organization_information hoi

292: ppa_arch.payroll_action_id
293: FROM pay_payroll_actions ppa_arch,
294: pay_assignment_actions paa_arch,
295: per_all_assignments_f paf,
296: hr_organization_information hoi
297: WHERE ppa_arch.report_type = 'RL2'
298: AND ppa_arch.business_group_id+0 = p_business_grpid
299: AND ppa_arch.effective_date = p_effective_dt
300: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id