APPS.PAY_JP_REPORT_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 908: from hr_organization_information hoi,

904: decode(p_kanji_flag,
905: '1',hoi.org_information6||hoi.org_information7||hoi.org_information8,
906: hoi.org_information9||hoi.org_information10||hoi.org_information11),1,255) EMPLOYER_ADDRESS,
907: peev.effective_end_date PREV_SWOT_TERM_DATE
908: from hr_organization_information hoi,
909: pay_element_entry_values_f peev,
910: pay_element_entries_f pee
911: where hoi.organization_id(+) = cp_itax_organization_id
912: and hoi.org_information_context(+) = 'JP_TAX_SWOT_INFO'

Line 1609: l_dpnt_control_method hr_organization_information.org_information1%type;

1605: p_business_group_id in number)
1606: return varchar2
1607: is
1608: --
1609: l_dpnt_control_method hr_organization_information.org_information1%type;
1610: l_return varchar2(1);
1611: --
1612: cursor csr_get_bg_info
1613: is

Line 1615: from hr_organization_information hoi

1611: --
1612: cursor csr_get_bg_info
1613: is
1614: select hoi.org_information1
1615: from hr_organization_information hoi
1616: where hoi.organization_id = p_business_group_id
1617: and hoi.org_information_context = 'JP_BUSINESS_GROUP_INFO';
1618: --
1619: begin