DBA Data[Home] [Help]

APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on HR_ORGANIZATION_INFORMATION

Line 149: FROM pay_payrolls_f ppf, hr_soft_coding_keyflex flex, hr_organization_information org

145: IS
146: SELECT org.org_information1 employers_ref_no, org.org_information2 tax_office_name,
147: org.org_information8 tax_office_phone_no, org.org_information3 employer_name,
148: org.org_information4 employer_address
149: FROM pay_payrolls_f ppf, hr_soft_coding_keyflex flex, hr_organization_information org
150: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
151: AND fnd_date.canonical_to_date(v_benefit_end_date)
152: BETWEEN NVL(flex.start_date_active, fnd_date.canonical_to_date(v_benefit_end_date) )
153: AND NVL(flex.end_date_active, fnd_date.canonical_to_date(v_benefit_end_date) )