DBA Data[Home] [Help]

APPS.PAY_GB_EDI_P46_CAR dependencies on HR_ORGANIZATION_INFORMATION

Line 440: hr_organization_information org

436: organization_id,
437: ppa.effective_date
438: FROM
439: pay_payroll_actions ppa,
440: hr_organization_information org
441: WHERE ppa.payroll_action_id = pactid
442: AND org.org_information_context = 'Tax Details References'
443: AND NVL(org.org_information10,'UK') = 'UK'
444: AND org.organization_id = ppa.business_group_id

Line 537: hr_organization_information org

533: organization_id,
534: ppa.effective_date
535: FROM
536: pay_payroll_actions ppa,
537: hr_organization_information org
538: WHERE ppa.payroll_action_id = pactid
539: AND org.org_information_context = 'Tax Details References'
540: AND NVL(org.org_information10,'UK') = 'UK'
541: AND org.organization_id = ppa.business_group_id

Line 634: hr_organization_information org

630: organization_id,
631: ppa.effective_date
632: FROM
633: pay_payroll_actions ppa,
634: hr_organization_information org
635: WHERE ppa.payroll_action_id = pactid
636: AND org.org_information_context = 'Tax Details References'
637: AND NVL(org.org_information10,'UK') = 'UK'
638: AND org.organization_id = ppa.business_group_id

Line 730: hr_organization_information org

726: organization_id,
727: ppa.effective_date
728: FROM
729: pay_payroll_actions ppa,
730: hr_organization_information org
731: WHERE ppa.payroll_action_id = pactid
732: AND org.org_information_context = 'Tax Details References'
733: AND NVL(org.org_information10,'UK') = 'UK'
734: AND org.organization_id = ppa.business_group_id