APPS.HR_CONTINGENT_WORKER_API dependencies on PER_PERIODS_OF_PLACEMENT

Line 2146: , per_periods_of_placement pdp

2142: , per.npw_number
2143: , per.applicant_number
2144: from per_all_people_f per
2145: , per_business_groups bus
2146: , per_periods_of_placement pdp
2147: where pdp.person_id = p_person_id
2148: and pdp.date_start = p_date_start
2149: and bus.business_group_id = pdp.business_group_id
2150: and per.person_id = pdp.person_id

Line 2769: , per_periods_of_placement pdp

2765: , pdp.last_standard_process_date
2766: , pdp.person_id
2767: , pdp.object_version_number
2768: from per_business_groups bus
2769: , per_periods_of_placement pdp
2770: where pdp.person_id = p_person_id
2771: and pdp.date_start = p_date_start
2772: and bus.business_group_id = pdp.business_group_id;
2773: --

Line 3194: from per_periods_of_placement

3190:
3191: cursor csr_get_pdp_details is
3192: select actual_termination_date
3193: ,final_process_date
3194: from per_periods_of_placement
3195: where person_id = p_person_id
3196: and date_start = p_date_start;
3197:
3198: -- fix 1370960

Line 3695: from per_periods_of_placement

3691: AND ptu.effective_start_date > p_actual_termination_date;
3692:
3693: cursor c1 is
3694: select *
3695: from per_periods_of_placement
3696: where person_id = p_person_id
3697: and actual_termination_date = p_actual_termination_date;
3698: --
3699:

Line 3797: FROM per_periods_of_placement pdp

3793: SELECT pdp.final_process_date
3794: , pdp.last_standard_process_date
3795: INTO l_final_process_date
3796: , l_last_standard_process_date
3797: FROM per_periods_of_placement pdp
3798: WHERE pdp.person_id = p_person_id
3799: AND pdp.actual_termination_date = p_actual_termination_date;
3800: --
3801: exception when NO_DATA_FOUND then

Line 3992: UPDATE per_periods_of_placement pdp

3988: */
3989: --
3990: -- END WWBUG fix for 1390173
3991: --
3992: UPDATE per_periods_of_placement pdp
3993: SET pdp.actual_termination_date = null
3994: , pdp.last_standard_process_date = null
3995: , pdp.final_process_date = null
3996: , pdp.termination_reason = null

Line 4045: UPDATE per_periods_of_placement pdp

4041: --
4042: --
4043: -- END WWBUG fix for 1390173
4044: --
4045: UPDATE per_periods_of_placement pdp
4046: SET pdp.actual_termination_date = null
4047: , pdp.last_standard_process_date = null
4048: , pdp.final_process_date = null
4049: , pdp.termination_reason = null

Line 4355: from PER_PERIODS_OF_PLACEMENT

4351: (least
4352: (nvl(ACTUAL_TERMINATION_DATE + 1, p_effective_date + 1),
4353: p_effective_date + 1)
4354: ,DATE_START)), 12), 0) total_months
4355: from PER_PERIODS_OF_PLACEMENT
4356: where PERSON_ID = p_person_id
4357: and business_group_id = p_business_group_id
4358: and DATE_START = p_date_start
4359: and DATE_START <= p_effective_date;