APPS.PAY_JP_ITWB_DML_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 9100: from hr_organization_information hoi,

9096: fnd_number.canonical_to_number(hoi.org_information7) dbal_id,
9097: hoi.org_information8 rep_name,
9098: fnd_number.canonical_to_number(hoi.org_information9) rep_seq,
9099: hoi.org_information10 null_valid
9100: from hr_organization_information hoi,
9101: pay_all_payrolls_f pap
9102: where hoi.organization_id = p_itax_organization_id
9103: and hoi.org_information_context = c_org_information_context
9104: and pap.payroll_id = fnd_number.canonical_to_number(hoi.org_information1)

Line 9250: from hr_organization_information hoi,

9246: --
9247: cursor csr_itax_org
9248: is
9249: select hoi.organization_id
9250: from hr_organization_information hoi,
9251: hr_all_organization_units hou
9252: where hoi.organization_id = p_itax_organization_id
9253: and hoi.org_information_context = 'JP_TAX_SWOT_INFO'
9254: and hou.organization_id = hoi.organization_id;

Line 9293: from hr_organization_information hoi

9289: --
9290: cursor csr_duplicate
9291: is
9292: select hoi.org_information_id
9293: from hr_organization_information hoi
9294: where hoi.organization_id = p_itax_organization_id
9295: and hoi.org_information_context = c_org_information_context
9296: and fnd_number.canonical_to_number(hoi.org_information1) = p_payroll_id
9297: and hoi.org_information2 = p_category

Line 9673: from hr_organization_information hoi

9669: cursor csr_item_info
9670: is
9671: select hoi.rowid row_id,
9672: hoi.org_information_id
9673: from hr_organization_information hoi
9674: where hoi.organization_id = p_itax_organization_id
9675: and hoi.org_information_context = c_org_information_context
9676: and fnd_number.canonical_to_number(hoi.org_information1) = p_payroll_id
9677: and hoi.org_information2 = p_category