APPS.HR_CONTINGENT_WORKER_API dependencies on PER_PERIODS_OF_PLACEMENT

Line 1773: , per_periods_of_placement pdp

1769: , per.npw_number
1770: , per.applicant_number
1771: from per_all_people_f per
1772: , per_business_groups bus
1773: , per_periods_of_placement pdp
1774: where pdp.person_id = p_person_id
1775: and pdp.date_start = p_date_start
1776: and bus.business_group_id = pdp.business_group_id
1777: and per.person_id = pdp.person_id

Line 2348: , per_periods_of_placement pdp

2344: , pdp.last_standard_process_date
2345: , pdp.person_id
2346: , pdp.object_version_number
2347: from per_business_groups bus
2348: , per_periods_of_placement pdp
2349: where pdp.person_id = p_person_id
2350: and pdp.date_start = p_date_start
2351: and bus.business_group_id = pdp.business_group_id;
2352: --

Line 2773: from per_periods_of_placement

2769:
2770: cursor csr_get_pdp_details is
2771: select actual_termination_date
2772: ,final_process_date
2773: from per_periods_of_placement
2774: where person_id = p_person_id
2775: and date_start = p_date_start;
2776:
2777: -- fix 1370960

Line 3273: from per_periods_of_placement

3269: AND ptu.effective_start_date > p_actual_termination_date;
3270:
3271: cursor c1 is
3272: select *
3273: from per_periods_of_placement
3274: where person_id = p_person_id
3275: and actual_termination_date = p_actual_termination_date;
3276: --
3277:

Line 3366: FROM per_periods_of_placement pdp

3362: SELECT pdp.final_process_date
3363: , pdp.last_standard_process_date
3364: INTO l_final_process_date
3365: , l_last_standard_process_date
3366: FROM per_periods_of_placement pdp
3367: WHERE pdp.person_id = p_person_id
3368: AND pdp.actual_termination_date = p_actual_termination_date;
3369: --
3370: exception when NO_DATA_FOUND then

Line 3535: UPDATE per_periods_of_placement pdp

3531: */
3532: --
3533: -- END WWBUG fix for 1390173
3534: --
3535: UPDATE per_periods_of_placement pdp
3536: SET pdp.actual_termination_date = null
3537: , pdp.last_standard_process_date = null
3538: , pdp.final_process_date = null
3539: , pdp.termination_reason = null

Line 3588: UPDATE per_periods_of_placement pdp

3584: --
3585: --
3586: -- END WWBUG fix for 1390173
3587: --
3588: UPDATE per_periods_of_placement pdp
3589: SET pdp.actual_termination_date = null
3590: , pdp.last_standard_process_date = null
3591: , pdp.final_process_date = null
3592: , pdp.termination_reason = null

Line 3898: from PER_PERIODS_OF_PLACEMENT

3894: (least
3895: (nvl(ACTUAL_TERMINATION_DATE + 1, p_effective_date + 1),
3896: p_effective_date + 1)
3897: ,DATE_START)), 12), 0) total_months
3898: from PER_PERIODS_OF_PLACEMENT
3899: where PERSON_ID = p_person_id
3900: and business_group_id = p_business_group_id
3901: and DATE_START = p_date_start
3902: and DATE_START <= p_effective_date;