DBA Data[Home] [Help]

APPS.PAY_P45_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 1226: from hr_organization_information oi,

1222: cursor employer_addr(L_ASSIGNMENT_ID number, c_assignment_end_date date) is
1223: select oi.ORG_INFORMATION3,
1224: oi.ORG_INFORMATION4,
1225: ass.ASSIGNMENT_ID
1226: from hr_organization_information oi,
1227: pay_payrolls_f roll,
1228: hr_soft_coding_keyflex flex,
1229: per_assignments_f ass,
1230: fnd_sessions sess

Line 1513: hr_organization_information org

1509: substr(org.org_information4,1,60) employers_address_line,
1510: substr(org.org_information2 ,1,40) tax_district_name
1511: FROM
1512: pay_payroll_actions ppa,
1513: hr_organization_information org
1514: WHERE ppa.payroll_action_id = p_payroll_action_id
1515: AND org.org_information_context = 'Tax Details References'
1516: AND NVL(org.org_information10,'UK') = 'UK'
1517: AND org.organization_id = ppa.business_group_id