[Home] [Help]
1749: select 'Y'
1750: from dual
1751: where not exists(
1752: select null
1753: from hr_organization_information hoi,
1754: hr_all_organization_units hou
1755: where hoi.org_information_context = 'CLASS'
1756: and hoi.org_information1 = 'JP_TAX_SWOT'
1757: and hoi.organization_id = nvl(g_itax_organization_id,hoi.organization_id)
3734: hoi.org_information3 item_type,
3735: hoi.org_information8 item_rep_name,
3736: fnd_number.canonical_to_number(hoi.org_information9) item_rep_seq,
3737: hoi.org_information10 item_null_valid
3738: from hr_organization_information hoi
3739: where hoi.organization_id = g_itax_organization_id
3740: and hoi.org_information_context = 'JP_ITWB_ITEM_INFO'
3741: and fnd_number.canonical_to_number(hoi.org_information1) = p_payroll_id
3742: and not exists(
3740: and hoi.org_information_context = 'JP_ITWB_ITEM_INFO'
3741: and fnd_number.canonical_to_number(hoi.org_information1) = p_payroll_id
3742: and not exists(
3743: select null
3744: from hr_organization_information hoi2
3745: where hoi2.organization_id = g_itax_organization_id
3746: and hoi2.org_information_context = 'JP_ITWB_ITEM_INFO'
3747: and fnd_number.canonical_to_number(hoi2.org_information1) = p_payroll_id
3748: and hoi2.org_information2 = hoi.org_information2
3995: sum(nvl(fnd_number.canonical_to_number(prrv.result_value),0)) rslt_val
3996: from (select /*+ ORDERED */
3997: piv.element_type_id,
3998: piv.input_value_id
3999: from hr_organization_information hoi,
4000: pay_input_values_f piv
4001: where hoi.organization_id = g_itax_organization_id
4002: and hoi.org_information_context = 'JP_ITWB_ITEM_INFO'
4003: and hoi.org_information3 = 'IV'
4008: and p_data_ass_date_earned
4009: between piv.effective_start_date and piv.effective_end_date
4010: and not exists(
4011: select null
4012: from hr_organization_information hoi2
4013: where hoi2.organization_id = g_itax_organization_id
4014: and hoi2.org_information_context = 'JP_ITWB_ITEM_INFO'
4015: and hoi2.org_information3 = 'IV'
4016: and fnd_number.canonical_to_number(hoi2.org_information1) = p_data_ass_payroll_id
5464: cursor csr_bg_itax_dpnt_ref_type
5465: is
5466: select nvl(hoi.org_information2,'CTR_EE')
5467: from /* Business Group details */
5468: hr_organization_information hoi
5469: where hoi.organization_id = g_business_group_id
5470: and hoi.org_information_context = 'JP_BUSINESS_GROUP_INFO';
5471: --
5472: cursor csr_rep_info
5472: cursor csr_rep_info
5473: is
5474: select ltrim(rtrim(replace(hoi.org_information1,';',''))) org_cust_proc,
5475: nvl(hoi.org_information2,'Y') dpnt_ref_dec_flag
5476: from hr_organization_information hoi
5477: where hoi.organization_id = g_itax_organization_id
5478: and hoi.org_information_context = 'JP_ITWB_REP_INFO';
5479: --
5480: l_csr_action csr_action%rowtype;
5826: hoi.org_information12 phone,
5827: hoiw.org_information4 serial1,
5828: hoiw.org_information5 serial2
5829: from hr_all_organization_units hou,
5830: hr_organization_information hoi,
5831: hr_organization_information hoiw
5832: where hou.organization_id = g_itax_organization_id
5833: and hoi.organization_id(+) = hou.organization_id
5834: and hoi.org_information_context(+) = 'JP_TAX_SWOT_INFO'
5827: hoiw.org_information4 serial1,
5828: hoiw.org_information5 serial2
5829: from hr_all_organization_units hou,
5830: hr_organization_information hoi,
5831: hr_organization_information hoiw
5832: where hou.organization_id = g_itax_organization_id
5833: and hoi.organization_id(+) = hou.organization_id
5834: and hoi.org_information_context(+) = 'JP_TAX_SWOT_INFO'
5835: and hoiw.organization_id(+) = hou.organization_id