APPS.PAY_JP_REPORT_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 917: from hr_organization_information hoi,

913: decode(p_kanji_flag,
914: '1',hoi.org_information6||hoi.org_information7||hoi.org_information8,
915: hoi.org_information9||hoi.org_information10||hoi.org_information11),1,255) EMPLOYER_ADDRESS,
916: peev.effective_end_date PREV_SWOT_TERM_DATE
917: from hr_organization_information hoi,
918: pay_element_entry_values_f peev,
919: pay_element_entries_f pee
920: where hoi.organization_id(+) = cp_itax_organization_id
921: and hoi.org_information_context(+) = 'JP_TAX_SWOT_INFO'

Line 1618: l_dpnt_control_method hr_organization_information.org_information1%type;

1614: p_business_group_id in number)
1615: return varchar2
1616: is
1617: --
1618: l_dpnt_control_method hr_organization_information.org_information1%type;
1619: l_return varchar2(1);
1620: --
1621: cursor csr_get_bg_info
1622: is

Line 1624: from hr_organization_information hoi

1620: --
1621: cursor csr_get_bg_info
1622: is
1623: select hoi.org_information1
1624: from hr_organization_information hoi
1625: where hoi.organization_id = p_business_group_id
1626: and hoi.org_information_context = 'JP_BUSINESS_GROUP_INFO';
1627: --
1628: begin