DBA Data[Home] [Help]

APPS.PAY_JP_DEF_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 102: from hr_organization_information hoi2,

98: cursor csr_org is
99: select hoi2.org_information1 tax_office_name,
100: hoi1.org_information1 salary_payer_name,
101: hoi1.org_information6 || hoi1.org_information7 || hoi1.org_information8 salary_payer_address
102: from hr_organization_information hoi2,
103: hr_organization_information hoi1,
104: hr_all_organization_units hou
105: where hou.organization_id = g_organization_id
106: and hoi1.organization_id(+) = hou.organization_id

Line 103: hr_organization_information hoi1,

99: select hoi2.org_information1 tax_office_name,
100: hoi1.org_information1 salary_payer_name,
101: hoi1.org_information6 || hoi1.org_information7 || hoi1.org_information8 salary_payer_address
102: from hr_organization_information hoi2,
103: hr_organization_information hoi1,
104: hr_all_organization_units hou
105: where hou.organization_id = g_organization_id
106: and hoi1.organization_id(+) = hou.organization_id
107: and hoi1.org_information_context(+) = 'JP_TAX_SWOT_INFO'