DBA Data[Home] [Help]

APPS.PAY_CA_RL1_AMEND_MAG dependencies on HR_ORGANIZATION_INFORMATION

Line 398: hr_organization_information hoi

394: ff_database_items fdi2,
395: pay_assignment_actions paa,
396: pay_payroll_actions ppa,
397: pay_payroll_actions ppa1,
398: hr_organization_information hoi
399: where ppa1.payroll_action_id = :payroll_action_id
400: and ppa.business_group_id+0 = ppa1.business_group_id
401: and ppa.effective_date = ppa1.effective_date
402: and ppa.report_type = ''CAEOY_RL1_AMEND_PP''

Line 460: hr_organization_information hoi

456: FROM pay_payroll_actions ppa,
457: pay_assignment_actions paa,
458: per_all_assignments_f paf,
459: pay_payroll_actions ppa1,
460: hr_organization_information hoi
461: WHERE ppa1.payroll_action_id = p_pactid
462: AND ppa.report_type ='CAEOY_RL1_AMEND_PP'
463: AND ppa.business_group_id+0 = ppa1.business_group_id
464: AND ppa.effective_date = ppa1.effective_date