APPS.PA_RESOURCE_UTILS dependencies on PER_PERIODS_OF_PLACEMENT

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

3535: (select person_id, actual_termination_date
3536: from per_periods_of_service
3537: union all
3538: select person_id, actual_termination_date
3539: from per_periods_of_placement) po -- FP M CWK
3540: where asgn.person_id = p_person_id
3541: and nvl(po.actual_termination_date, trunc(sysdate)) >= trunc(sysdate)
3542: and asgn.person_id = po.person_id
3543: and po.person_id = p_person_id

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

3554: (select person_id, actual_termination_date
3555: from per_periods_of_service
3556: union all
3557: select person_id, actual_termination_date
3558: from per_periods_of_placement) po -- FP M CWK
3559: where asgn.person_id = p_person_id
3560: and asgn.primary_flag = 'Y'
3561: and po.person_id = p_person_id
3562: and nvl(po.actual_termination_date, trunc(sysdate)) >= trunc(sysdate)

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

3572: (select person_id, actual_termination_date
3573: from per_periods_of_service
3574: union all
3575: select person_id, actual_termination_date
3576: from per_periods_of_placement) po -- FP M CWK
3577: where asgn.person_id = p_person_id
3578: and asgn.primary_flag = 'Y'
3579: and po.person_id = p_person_id
3580: and nvl(po.actual_termination_date, trunc(sysdate)) >= trunc(sysdate)

Line 4281: per_periods_of_placement pp

4277:
4278: SELECT pp.projected_termination_date
4279: INTO l_term_date
4280: FROM per_all_assignments_f asg,
4281: per_periods_of_placement pp
4282: WHERE asg.person_id = p_person_id
4283: AND pp.person_id = p_person_id
4284: AND asg.primary_flag = 'Y'
4285: AND asg.assignment_type = 'C'

Line 4466: l_term_reas PER_PERIODS_OF_PLACEMENT.TERMINATION_REASON%TYPE ;

4462: l_term_type VARCHAR2(1);
4463: l_resource_person_type PA_RESOURCES_DENORM.RESOURCE_PERSON_TYPE%TYPE ;
4464:
4465: l_leav_reas PER_PERIODS_OF_SERVICE.LEAVING_REASON%TYPE ;
4466: l_term_reas PER_PERIODS_OF_PLACEMENT.TERMINATION_REASON%TYPE ;
4467:
4468: CURSOR c_formula
4469: IS
4470: SELECT formula_id

Line 4493: FROM per_periods_of_placement

4489: CURSOR c_term_reas (c_person_id PA_EMPLOYEES.PERSON_ID%TYPE)
4490: IS
4491: SELECT termination_reason
4492: FROM (SELECT termination_reason
4493: FROM per_periods_of_placement
4494: WHERE person_id = c_person_id
4495: AND actual_termination_date IS NOT NULL
4496: ORDER BY actual_termination_date DESC)
4497: WHERE ROWNUM = 1;

Line 4891: FROM per_periods_of_placement

4887: ELSIF (l_resource_person_type = 'CWK' ) THEN
4888:
4889: SELECT TRUNC (NVL( MAX(actual_termination_date), SYSDATE ))
4890: INTO l_end_date
4891: FROM per_periods_of_placement
4892: WHERE person_id = p_person_id
4893: AND actual_termination_date IS NOT NULL;
4894:
4895: END IF ; --IF (l_system_person_type = 'EMP' )

Line 5035: FROM per_periods_of_placement

5031: WHERE person_id = c_person_id
5032: AND actual_termination_date IS NOT NULL
5033: UNION
5034: SELECT MAX(actual_termination_date)"ACT_TERM_DATE"
5035: FROM per_periods_of_placement
5036: WHERE person_id = c_person_id
5037: AND actual_termination_date IS NOT NULL )
5038: WHERE ACT_TERM_DATE IS NOT NULL ;
5039: