DBA Data[Home] [Help]

APPS.PAY_GB_EOY_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 1325: hr_organization_information org

1321: flex.segment18 * 100 spp_compensation
1322: End 4011263 */
1323: FROM pay_all_payrolls_f p,
1324: hr_soft_coding_keyflex flex,
1325: hr_organization_information org
1326: WHERE p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
1327: AND org.org_information_context = 'Tax Details References'
1328: AND org.org_information1 = flex.segment1
1329: AND NVL(org.org_information10,'UK') = 'UK'

Line 1812: hr_organization_information org,

1808: 'N' tax_ref_xfer
1809: FROM per_all_assignments_f asg,
1810: pay_all_payrolls_f ppf,
1811: hr_soft_coding_keyflex flex,
1812: hr_organization_information org,
1813: per_all_people_f per
1814: WHERE asg.person_id BETWEEN stperson AND endperson
1815: AND asg.business_group_id +0 = p_bg_id
1816: AND asg.effective_end_date >= p_min_start_year_date