DBA Data[Home] [Help]

APPS.PAY_IN_EXC dependencies on HR_ORGANIZATION_INFORMATION

Line 782: hr_organization_information target,

778: cursor csr_freq IS
779: select target.org_information2
780: from per_all_assignments_f assign,
781: hr_soft_coding_keyflex hsc,
782: hr_organization_information target,
783: pay_assignment_actions paa
784: WHERE paa.assignment_action_id = p_asg_action
785: AND paa.assignment_id = assign.assignment_id
786: AND p_effective_date BETWEEN ASSIGN.effective_start_date AND ASSIGN.effective_end_date