DBA Data[Home] [Help]

APPS.PAY_CA_RL2_MAG dependencies on HR_ORGANIZATION_INFORMATION

Line 307: hr_organization_information hoi

303: pay_ca_eoy_rl2_trans_info_v tran,
304: pay_assignment_actions paa_arch,
305: pay_payroll_actions ppa_arch,
306: pay_payroll_actions ppa_mag,
307: hr_organization_information hoi
308: where ppa_mag.payroll_action_id = :payroll_action_id
309: and ppa_arch.business_group_id+0 = ppa_mag.business_group_id
310: and ppa_arch.effective_date = ppa_mag.effective_date
311: and ppa_arch.report_type = ''RL2''

Line 370: hr_organization_information hoi

366: ppa_arch.payroll_action_id
367: FROM pay_payroll_actions ppa_arch,
368: pay_assignment_actions paa_arch,
369: per_all_assignments_f paf,
370: hr_organization_information hoi
371: WHERE ppa_arch.report_type = 'RL2'
372: AND ppa_arch.business_group_id+0 = p_business_grpid
373: AND ppa_arch.effective_date = p_effective_dt
374: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id