DBA Data[Home] [Help]

APPS.PAY_GB_EOY_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 1351: hr_organization_information org

1347: flex.segment18 * 100 spp_compensation
1348: End 4011263 */
1349: FROM pay_all_payrolls_f p,
1350: hr_soft_coding_keyflex flex,
1351: hr_organization_information org
1352: WHERE p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
1353: AND org.org_information_context = 'Tax Details References'
1354: AND org.org_information1 = flex.segment1
1355: AND NVL(org.org_information10,'UK') = 'UK'

Line 1859: hr_organization_information org,

1855: 'N' tax_ref_xfer
1856: FROM per_all_assignments_f asg,
1857: pay_all_payrolls_f ppf,
1858: hr_soft_coding_keyflex flex,
1859: hr_organization_information org,
1860: per_all_people_f per
1861: WHERE asg.person_id BETWEEN stperson AND endperson
1862: AND asg.business_group_id +0 = p_bg_id
1863: AND asg.effective_end_date >= p_min_start_year_date