APPS.OTA_CRT_FINANCE_SEGMENT dependencies on PER_ALL_ASSIGNMENTS_F

Line 159: PER_ALL_ASSIGNMENTS_F asg

155:
156: CURSOR OFA IS
157: SELECT hr.COST_ALLOCATION_KEYFLEX_ID
158: FROM HR_ALL_ORGANIZATION_UNITS hr ,
159: PER_ALL_ASSIGNMENTS_F asg
160: WHERE hr.organization_id = asg.organization_id and
161: asg.organization_id = p_organization_id and
162: asg.assignment_id = p_assignment_id and
163: trunc(sysdate) between asg.effective_start_date and

Line 294: PER_ALL_ASSIGNMENTS_F asg

290: FETCH OFA INTO l_cost_allocation_keyflex_id ;
291: CLOSE OFA;
292: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
293: FROM HR_ALL_ORGANIZATION_UNITS hr ,
294: PER_ALL_ASSIGNMENTS_F asg
295: WHERE hr.organization_id = asg.organization_id and
296: asg.organization_id = p_organization_id and
297: asg.assignment_id = p_assignment_id ; */
298:

Line 533: PER_ALL_ASSIGNMENTS_F asg

529: FETCH OFA INTO l_cost_allocation_keyflex_id ;
530: CLOSE OFA;
531: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
532: FROM HR_ALL_ORGANIZATION_UNITS hr ,
533: PER_ALL_ASSIGNMENTS_F asg
534: WHERE hr.organization_id = asg.organization_id and
535: asg.organization_id = p_organization_id and
536: asg.assignment_id = p_assignment_id ; */
537: