DBA Data[Home] [Help]

APPS.PAY_P45_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 1119: from hr_organization_information oi,

1115: cursor employer_addr(L_ASSIGNMENT_ID number, c_assignment_end_date date) is
1116: select oi.ORG_INFORMATION3,
1117: oi.ORG_INFORMATION4,
1118: ass.ASSIGNMENT_ID
1119: from hr_organization_information oi,
1120: pay_payrolls_f roll,
1121: hr_soft_coding_keyflex flex,
1122: per_assignments_f ass,
1123: fnd_sessions sess

Line 1396: hr_organization_information org

1392: substr(org.org_information4,1,60) employers_address_line,
1393: substr(org.org_information2 ,1,40) tax_district_name
1394: FROM
1395: pay_payroll_actions ppa,
1396: hr_organization_information org
1397: WHERE ppa.payroll_action_id = p_payroll_action_id
1398: AND org.org_information_context = 'Tax Details References'
1399: AND NVL(org.org_information10,'UK') = 'UK'
1400: AND org.organization_id = ppa.business_group_id