DBA Data[Home] [Help]

APPS.HR_DE_TAX_SUPPORT dependencies on PER_ALL_ASSIGNMENTS_F

Line 81: FROM PER_ALL_ASSIGNMENTS_F asg

77: ,hdt.effective_end_date
78: ,hdt.effective_start_date
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

Line 105: from per_all_assignments_f paf

101: ,hdt.effective_start_date
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'))

Line 126: from per_all_assignments_f paf

122: ,HDT.EFFECTIVE_END_DATE
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'