APPS.HR_DE_TAX_SUPPORT dependencies on HR_DE_TAX_INFORMATION_V

Line 83: ,HR_DE_TAX_INFORMATION_V hdt

79: ,hdt.element_entry_id
80: ,hdt.object_version_number
81: FROM PER_ALL_ASSIGNMENTS_F asg
82: ,HR_ASSIGNMENT_SET_AMENDMENTS amn
83: ,HR_DE_TAX_INFORMATION_V hdt
84: WHERE asg.business_group_id = P_BUSINESS_GROUP_ID
85: AND asg.assignment_id = amn.assignment_id
86: AND amn.include_or_exclude = 'I'
87: AND amn.assignment_set_id = P_ASSIGNMENT_SET

Line 106: ,hr_de_tax_information_v hdt

102: ,hdt.element_entry_id
103: ,hdt.object_version_number
104:
105: from per_all_assignments_f paf
106: ,hr_de_tax_information_v hdt
107: where paf.business_group_id = P_BUSINESS_GROUP_ID
108: and paf.assignment_type = 'E'
109: and P_DATE_FROM between paf.effective_start_date and nvl(paf.effective_end_date,TO_DATE('31/12/4712','DD/MM/YYYY'))
110: AND paf.assignment_id = hdt.assignment_id

Line 127: ,hr_de_tax_information_v hdt

123: ,HDT.EFFECTIVE_START_DATE
124: ,hdt.element_entry_id
125: ,hdt.object_version_number
126: from per_all_assignments_f paf
127: ,hr_de_tax_information_v hdt
128: where paf.business_group_id = P_BUSINESS_GROUP_ID
129: and paf.organization_id = P_ORGANIZATION_ID
130: and paf.assignment_type = 'E'
131: and P_DATE_FROM between paf.effective_start_date and nvl(paf.effective_end_date,TO_DATE('31/12/4712','DD/MM/YYYY'))

Line 401: from hr_de_tax_information_v hdt

397: CURSOR c_get_tax_rec ( p_assignment_id number,
398: p_date_from date)
399: IS
400: select '1'
401: from hr_de_tax_information_v hdt
402: where hdt.assignment_id = p_assignment_id
403: and to_char(hdt.effective_start_date,'YYYY') < to_char(p_date_from,'YYYY')
404: and nvl(hdt.effective_end_date,TO_DATE('31/12/4712','DD/MM/YYYY')) > p_date_from
405: and hdt.tax_class IN ('I','II','III','IV','V','VI')