APPS.PA_RESOURCE_UTILS dependencies on PER_PERIODS_OF_SERVICE

Line 3872: from per_periods_of_service

3868: select asgn.assignment_id
3869: from per_all_assignments_f asgn,
3870: per_assignment_status_types status,
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

Line 3891: from per_periods_of_service

3887: is
3888: select asgn.assignment_id
3889: from per_all_assignments_f asgn,
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

Line 3909: from per_periods_of_service

3905: is
3906: select asgn.job_id
3907: from per_all_assignments_f asgn,
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

Line 4801: l_leav_reas PER_PERIODS_OF_SERVICE.LEAVING_REASON%TYPE ;

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

Line 4819: FROM per_periods_of_service

4815: CURSOR c_leav_reas (c_person_id PA_EMPLOYEES.PERSON_ID%TYPE)
4816: IS
4817: SELECT leaving_reason
4818: FROM (SELECT leaving_reason
4819: FROM per_periods_of_service
4820: WHERE person_id = c_person_id
4821: AND actual_termination_date IS NOT NULL
4822: ORDER BY actual_termination_date DESC)
4823: WHERE ROWNUM = 1;

Line 5239: FROM per_periods_of_service

5235: IF ( l_resource_person_type = 'EMP') THEN
5236:
5237: SELECT TRUNC (NVL( MAX(actual_termination_date), SYSDATE ))
5238: INTO l_end_date
5239: FROM per_periods_of_service
5240: WHERE person_id = p_person_id
5241: AND actual_termination_date IS NOT NULL;
5242:
5243: ELSIF (l_resource_person_type = 'CWK' ) THEN

Line 5386: FROM per_periods_of_service

5382: IS
5383: SELECT TRUNC (NVL (ACT_TERM_DATE, sysdate))
5384: FROM
5385: (SELECT MAX(actual_termination_date)"ACT_TERM_DATE"
5386: FROM per_periods_of_service
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"