APPS.PAY_JP_LTAX_IMP_PKG dependencies on HR_API

Line 758: and nvl(hou.date_to,hr_api.g_eot) >= g_effective_soy

754: and hoi.organization_id = nvl(g_organization_id,hoi.organization_id)
755: and hou.organization_id = hoi.organization_id
756: and hou.business_group_id + 0 = g_business_group_id
757: and hou.date_from <= g_effective_eoy
758: and nvl(hou.date_to,hr_api.g_eot) >= g_effective_soy
759: and pjsn_act.organization_id = hou.organization_id
760: and pjsn_rep.organization_id = pjsn_act.organization_id
761: and pjsn_rep.district_code = nvl(pjsn_act.report_district_code,pjsn_act.district_code)
762: and substrb(nvl(pjsn_act.report_district_code,pjsn_act.district_code),1,5) = nvl(g_district_code,substrb(nvl(pjsn_act.report_district_code,pjsn_act.district_code),1,5))

Line 801: and nvl(hou.date_to,hr_api.g_eot) >= g_effective_soy

797: and hoi.organization_id = nvl(g_organization_id,hoi.organization_id)
798: and hou.organization_id = hoi.organization_id
799: and hou.business_group_id + 0 = g_business_group_id
800: and hou.date_from <= g_effective_eoy
801: and nvl(hou.date_to,hr_api.g_eot) >= g_effective_soy
802: and pjsn_act.organization_id = hou.organization_id
803: and pjsn_rep.organization_id = pjsn_act.organization_id
804: and pjsn_rep.district_code = nvl(pjsn_act.report_district_code,pjsn_act.district_code)
805: and substrb(nvl(pjsn_act.report_district_code,pjsn_act.district_code),1,5) = nvl(g_district_code,substrb(nvl(pjsn_act.report_district_code,pjsn_act.district_code),1,5))

Line 815: between pad.date_from and nvl(pad.date_to,hr_api.g_eot)

811: and pad.address_type in ('JP_R','JP_C')
812: and pad.business_group_id + 0 = g_business_group_id
813: and ppos.person_id = pad.person_id
814: and nvl(ppos.actual_termination_date, g_effective_soy)
815: between pad.date_from and nvl(pad.date_to,hr_api.g_eot)
816: and pa.period_of_service_id = ppos.period_of_service_id
817: and pa.effective_start_date <= g_effective_eom
818: and pa.effective_end_date >= g_effective_som
819: and pa.primary_flag = 'Y'

Line 1495: between pad.date_from and nvl(pad.date_to,hr_api.g_eot)

1491: hr_organization_information hoi
1492: where pad.person_id = pp.person_id
1493: and pad.address_type in ('JP_C','JP_R')
1494: and nvl(ppos.actual_termination_date,g_effective_soy)
1495: between pad.date_from and nvl(pad.date_to,hr_api.g_eot)
1496: and substrb(pjsn_act.district_code,1,5) = pad.town_or_city
1497: and pjsn_rep.organization_id = pjsn_act.organization_id
1498: and pjsn_rep.district_code = nvl(pjsn_act.report_district_code,pjsn_act.district_code)
1499: and substrb(nvl(pjsn_act.report_district_code,pjsn_act.district_code),1,5) = nvl(g_district_code,substrb(nvl(pjsn_act.report_district_code,pjsn_act.district_code),1,5))

Line 1506: and nvl(hou.date_to,hr_api.g_eot) >= g_effective_soy

1502: and pjsn_rep.swot_number = p_swot_number
1503: and hou.organization_id = pjsn_rep.organization_id
1504: and hou.business_group_id + 0 = g_business_group_id
1505: and hou.date_from <= g_effective_eoy
1506: and nvl(hou.date_to,hr_api.g_eot) >= g_effective_soy
1507: and hou.organization_id = nvl(g_organization_id,hou.organization_id)
1508: and hou.organization_id = hoi.organization_id
1509: and hoi.org_information_context = 'CLASS'
1510: and hoi.org_information1 = 'JP_TAX_SWOT'

Line 1684: l_res_date := nvl(pay_jp_balance_pkg.get_entry_value_date(c_res_date_iv_id,p_assignment_id,p_regular_payment_date),hr_api.g_eot);

1680: --
1681: if l_valid then
1682: --
1683: l_non_res_date := pay_jp_balance_pkg.get_entry_value_date(c_non_res_date_iv_id,p_assignment_id,p_regular_payment_date);
1684: l_res_date := nvl(pay_jp_balance_pkg.get_entry_value_date(c_res_date_iv_id,p_assignment_id,p_regular_payment_date),hr_api.g_eot);
1685: --
1686: if g_debug
1687: and g_detail_debug = 'Y' then
1688: hr_utility.set_location(l_proc,30);