APPS.PA_RESOURCE_UTILS dependencies on PER_PERIODS_OF_SERVICE

Line 3536: from per_periods_of_service

3532: select asgn.assignment_id
3533: from per_all_assignments_f asgn,
3534: per_assignment_status_types status,
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

Line 3555: from per_periods_of_service

3551: is
3552: select asgn.assignment_id
3553: from per_all_assignments_f asgn,
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

Line 3573: from per_periods_of_service

3569: is
3570: select asgn.job_id
3571: from per_all_assignments_f asgn,
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

Line 4465: l_leav_reas PER_PERIODS_OF_SERVICE.LEAVING_REASON%TYPE ;

4461: l_formula_id NUMBER;
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

Line 4483: FROM per_periods_of_service

4479: CURSOR c_leav_reas (c_person_id PA_EMPLOYEES.PERSON_ID%TYPE)
4480: IS
4481: SELECT leaving_reason
4482: FROM (SELECT leaving_reason
4483: FROM per_periods_of_service
4484: WHERE person_id = c_person_id
4485: AND actual_termination_date IS NOT NULL
4486: ORDER BY actual_termination_date DESC)
4487: WHERE ROWNUM = 1;

Line 4883: FROM per_periods_of_service

4879: IF ( l_resource_person_type = 'EMP') THEN
4880:
4881: SELECT TRUNC (NVL( MAX(actual_termination_date), SYSDATE ))
4882: INTO l_end_date
4883: FROM per_periods_of_service
4884: WHERE person_id = p_person_id
4885: AND actual_termination_date IS NOT NULL;
4886:
4887: ELSIF (l_resource_person_type = 'CWK' ) THEN

Line 5030: FROM per_periods_of_service

5026: IS
5027: SELECT TRUNC (NVL (ACT_TERM_DATE, sysdate))
5028: FROM
5029: (SELECT MAX(actual_termination_date)"ACT_TERM_DATE"
5030: FROM per_periods_of_service
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"