APPS.OTA_FR_TRG_SUM dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 118: from hr_assignment_set_amendments hsa

114:
115:
116: cursor c_asg_amendments is
117: select hsa.include_or_exclude ioe
118: from hr_assignment_set_amendments hsa
119: where hsa.assignment_set_id =p_assignment_set_id;
120:
121: p_asg_emp varchar2(30);
122: l_c_asg_amendments c_asg_amendments%ROWTYPE ;

Line 167: from hr_assignment_set_amendments hsa

163: and pef.person_id=paf.person_id
164: and paf.business_group_id=:p_business_group_id
165: and paf.business_group_id=pef.business_group_id
166: and paf.assignment_id in ( select assignment_id
167: from hr_assignment_set_amendments hsa
168: where hsa.assignment_set_id =:p_assignment_set_id
169: and hsa.include_or_exclude=''I'')
170: and ppos.person_id=pef.person_id
171: and ppos.period_of_service_id=paf.period_of_service_id

Line 205: from hr_assignment_set_amendments hsa

201: and pef.person_id=paf.person_id
202: and paf.business_group_id=:p_business_group_id
203: and paf.business_group_id=pef.business_group_id
204: and paf.assignment_id not in ( select assignment_id
205: from hr_assignment_set_amendments hsa
206: where hsa.assignment_set_id =:p_assignment_set_id
207: and hsa.include_or_exclude=''E'')
208: and ppos.person_id=pef.person_id
209: and ppos.period_of_service_id=paf.period_of_service_id

Line 242: from hr_assignment_set_amendments hsa

238: and pef.person_id=paf.person_id
239: and paf.business_group_id=:p_business_group_id
240: and paf.business_group_id=pef.business_group_id
241: and paf.assignment_id not in ( select assignment_id
242: from hr_assignment_set_amendments hsa
243: where hsa.assignment_set_id =:p_assignment_set_id
244: and hsa.include_or_exclude=''E'')
245: and ppos.person_id=pef.person_id
246: and ppos.period_of_service_id=paf.period_of_service_id