APPS.PAY_NL_TAX_PKG dependencies on HR_GENERAL

Line 847: and p_date_earned between date_start and nvl(actual_termination_date,hr_general.end_of_time)

843: where pps.person_id = paa.person_id
844: and paa.assignment_id = p_assignment_id
845: and pps.business_group_id = p_business_group_id
846: and paa.business_group_id = p_business_group_id
847: and p_date_earned between date_start and nvl(actual_termination_date,hr_general.end_of_time)
848: and p_date_earned between paa.effective_start_date and paa.effective_end_date;
849: --
850: -- Cursor to get_dob
851: --

Line 960: and nvl(FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION2),hr_general.END_OF_TIME)

956: WHERE
957: paei.assignment_id = p_assignment_id
958: AND p_date_earned between
959: FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION1)
960: and nvl(FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION2),hr_general.END_OF_TIME)
961: and paei.INFORMATION_TYPE = 'NL_TTD';
962:
963: l_discount_type NUMBER :=-1;
964: l_proc varchar2(100) := g_package||'get_temporary_tax_discount';