DBA Data[Home] [Help]

APPS.PAY_PPM_BUS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 679: -- hr_all_organization_units instead of view hr_organization_units

675: -- Check that the organization is valid and is in the same business group
676: -- as the personal payment method.
677: --
678: -- Bug 6617741 : Changed the cursor to fetch record from table
679: -- hr_all_organization_units instead of view hr_organization_units
680: -- to bypass the check for valid organization.
681:
682: cursor csr_chk_organization is
683: select oru.business_group_id

Line 684: from hr_all_organization_units oru

680: -- to bypass the check for valid organization.
681:
682: cursor csr_chk_organization is
683: select oru.business_group_id
684: from hr_all_organization_units oru
685: where oru.organization_id = p_payee_id
686: and p_effective_date between oru.date_from and
687: nvl(oru.date_to, hr_api.g_eot);
688: --