APPS.PA_RESOURCE_UTILS dependencies on PER_PERIODS_OF_PLACEMENT

Line 3875: from per_periods_of_placement) po -- FP M CWK

3871: (select person_id, actual_termination_date
3872: from per_periods_of_service
3873: union all
3874: select person_id, actual_termination_date
3875: from per_periods_of_placement) po -- FP M CWK
3876: where asgn.person_id = p_person_id
3877: and nvl(po.actual_termination_date, trunc(sysdate)) >= trunc(sysdate)
3878: and asgn.person_id = po.person_id
3879: and po.person_id = p_person_id

Line 3894: from per_periods_of_placement) po -- FP M CWK

3890: (select person_id, actual_termination_date
3891: from per_periods_of_service
3892: union all
3893: select person_id, actual_termination_date
3894: from per_periods_of_placement) po -- FP M CWK
3895: where asgn.person_id = p_person_id
3896: and asgn.primary_flag = 'Y'
3897: and po.person_id = p_person_id
3898: and nvl(po.actual_termination_date, trunc(sysdate)) >= trunc(sysdate)

Line 3912: from per_periods_of_placement) po -- FP M CWK

3908: (select person_id, actual_termination_date
3909: from per_periods_of_service
3910: union all
3911: select person_id, actual_termination_date
3912: from per_periods_of_placement) po -- FP M CWK
3913: where asgn.person_id = p_person_id
3914: and asgn.primary_flag = 'Y'
3915: and po.person_id = p_person_id
3916: and nvl(po.actual_termination_date, trunc(sysdate)) >= trunc(sysdate)

Line 4617: per_periods_of_placement pp

4613:
4614: SELECT NVL(pp.projected_termination_date, asg.projected_assignment_end) -- Bug#14594489
4615: INTO l_term_date
4616: FROM per_all_assignments_f asg,
4617: per_periods_of_placement pp
4618: WHERE asg.person_id = p_person_id
4619: AND pp.person_id = p_person_id
4620: AND asg.primary_flag = 'Y'
4621: AND asg.assignment_type = 'C'

Line 4802: l_term_reas PER_PERIODS_OF_PLACEMENT.TERMINATION_REASON%TYPE ;

4798: l_term_type VARCHAR2(1);
4799: l_resource_person_type PA_RESOURCES_DENORM.RESOURCE_PERSON_TYPE%TYPE ;
4800:
4801: l_leav_reas PER_PERIODS_OF_SERVICE.LEAVING_REASON%TYPE ;
4802: l_term_reas PER_PERIODS_OF_PLACEMENT.TERMINATION_REASON%TYPE ;
4803:
4804: CURSOR c_formula
4805: IS
4806: SELECT formula_id

Line 4829: FROM per_periods_of_placement

4825: CURSOR c_term_reas (c_person_id PA_EMPLOYEES.PERSON_ID%TYPE)
4826: IS
4827: SELECT termination_reason
4828: FROM (SELECT termination_reason
4829: FROM per_periods_of_placement
4830: WHERE person_id = c_person_id
4831: AND actual_termination_date IS NOT NULL
4832: ORDER BY actual_termination_date DESC)
4833: WHERE ROWNUM = 1;

Line 5247: FROM per_periods_of_placement

5243: ELSIF (l_resource_person_type = 'CWK' ) THEN
5244:
5245: SELECT TRUNC (NVL( MAX(actual_termination_date), SYSDATE ))
5246: INTO l_end_date
5247: FROM per_periods_of_placement
5248: WHERE person_id = p_person_id
5249: AND actual_termination_date IS NOT NULL;
5250:
5251: END IF ; --IF (l_system_person_type = 'EMP' )

Line 5391: FROM per_periods_of_placement

5387: WHERE person_id = c_person_id
5388: AND actual_termination_date IS NOT NULL
5389: UNION
5390: SELECT MAX(actual_termination_date)"ACT_TERM_DATE"
5391: FROM per_periods_of_placement
5392: WHERE person_id = c_person_id
5393: AND actual_termination_date IS NOT NULL )
5394: WHERE ACT_TERM_DATE IS NOT NULL ;
5395: