DBA Data[Home] [Help]

APPS.PAY_CA_RL2_AMEND_MAG dependencies on HR_ORGANIZATION_INFORMATION

Line 317: hr_organization_information hoi

313: pay_ca_eoy_rl2_trans_info_v tran,
314: pay_assignment_actions paa_arch,
315: pay_payroll_actions ppa_arch,
316: pay_payroll_actions ppa_mag,
317: hr_organization_information hoi
318: where ppa_mag.payroll_action_id = :payroll_action_id
319: and ppa_arch.business_group_id+0 = ppa_mag.business_group_id
320: and ppa_arch.effective_date = ppa_mag.effective_date
321: and ppa_arch.report_type = ''CAEOY_RL2_AMEND_PP''

Line 380: hr_organization_information hoi

376: max(ppa_arch.payroll_action_id)
377: FROM pay_payroll_actions ppa_arch,
378: pay_assignment_actions paa_arch,
379: per_all_assignments_f paf,
380: hr_organization_information hoi
381: WHERE ppa_arch.report_type = 'CAEOY_RL2_AMEND_PP'
382: AND ppa_arch.business_group_id+0 = p_business_grpid
383: AND ppa_arch.effective_date = p_effective_dt
384: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id