eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_QH_MAINTAIN_UPDATE dependencies on PER_PERIODS_OF_SERVICE

Line 29: ,p_hire_date IN OUT NOCOPY per_periods_of_service.date_start%TYPE -- Bug 3975241

25: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
26: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
27: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
28: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
29: ,p_hire_date IN OUT NOCOPY per_periods_of_service.date_start%TYPE -- Bug 3975241
30: --CWK
31: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
32: ,p_npw_number IN OUT NOCOPY per_all_people_f.npw_number%TYPE
33: ,p_placement_date_start IN OUT NOCOPY per_all_assignments_f.period_of_placement_date_start%TYPE -- Bug 4287925

Line 349: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE

345: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
346: ,p_current_employer IN per_applications.current_employer%TYPE
347: ,p_termination_reason IN per_applications.termination_reason%TYPE
348: ,p_app_object_version_number OUT NOCOPY per_applications.object_version_number%TYPE
349: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
350: ,p_pds_object_version_number IN OUT NOCOPY per_periods_of_service.object_version_number%TYPE
351: ,p_address_id OUT NOCOPY per_addresses.address_id%TYPE
352: ,p_adr_date_from IN per_addresses.date_from%TYPE
353: ,p_style IN per_addresses.style%TYPE

Line 350: ,p_pds_object_version_number IN OUT NOCOPY per_periods_of_service.object_version_number%TYPE

346: ,p_current_employer IN per_applications.current_employer%TYPE
347: ,p_termination_reason IN per_applications.termination_reason%TYPE
348: ,p_app_object_version_number OUT NOCOPY per_applications.object_version_number%TYPE
349: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
350: ,p_pds_object_version_number IN OUT NOCOPY per_periods_of_service.object_version_number%TYPE
351: ,p_address_id OUT NOCOPY per_addresses.address_id%TYPE
352: ,p_adr_date_from IN per_addresses.date_from%TYPE
353: ,p_style IN per_addresses.style%TYPE
354: ,p_address_line1 IN per_addresses.address_line1%TYPE

Line 969: FROM per_all_assignments_f asg, per_periods_of_service pds

965: -- get the pds id id and ovn
966: SELECT asg.period_of_service_id,
967: pds.object_version_number
968: INTO l_pos_id, l_pos_ovn
969: FROM per_all_assignments_f asg, per_periods_of_service pds
970: WHERE asg.assignment_id = l_assignment_id
971: and asg.period_of_service_id = pds.period_of_service_id;
972:
973: p_period_of_service_id := l_pos_id;

Line 3012: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE

3008: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
3009: ,p_current_employer IN per_applications.current_employer%TYPE
3010: ,p_termination_reason IN per_applications.termination_reason%TYPE
3011: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
3012: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
3013: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
3014: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
3015: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
3016: ,p_adr_date_from IN per_addresses.date_from%TYPE

Line 3013: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE

3009: ,p_current_employer IN per_applications.current_employer%TYPE
3010: ,p_termination_reason IN per_applications.termination_reason%TYPE
3011: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
3012: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
3013: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
3014: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
3015: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
3016: ,p_adr_date_from IN per_addresses.date_from%TYPE
3017: ,p_style IN per_addresses.style%TYPE

Line 3014: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE

3010: ,p_termination_reason IN per_applications.termination_reason%TYPE
3011: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
3012: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
3013: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
3014: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
3015: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
3016: ,p_adr_date_from IN per_addresses.date_from%TYPE
3017: ,p_style IN per_addresses.style%TYPE
3018: ,p_address_line1 IN per_addresses.address_line1%TYPE

Line 7024: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE

7020: ,p_asg_validation_end_date OUT NOCOPY DATE
7021: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE
7022: ,p_application_id per_applications.application_id%TYPE
7023: ,p_app_object_version_number per_applications.object_version_number%TYPE
7024: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
7025: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
7026: ,p_address_id per_addresses.address_id%TYPE
7027: ,p_addr_object_version_number per_addresses.object_version_number%TYPE
7028: ,p_phn_h_phone_id per_phones.phone_id%TYPE

Line 7025: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE

7021: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE
7022: ,p_application_id per_applications.application_id%TYPE
7023: ,p_app_object_version_number per_applications.object_version_number%TYPE
7024: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
7025: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
7026: ,p_address_id per_addresses.address_id%TYPE
7027: ,p_addr_object_version_number per_addresses.object_version_number%TYPE
7028: ,p_phn_h_phone_id per_phones.phone_id%TYPE
7029: ,p_phn_h_object_version_number per_phones.object_version_number%TYPE

Line 7070: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;

7066: l_rate_datetrack_update_mode VARCHAR2(30);
7067: l_period_of_placement_id per_periods_of_placement.period_of_placement_id%TYPE;
7068: l_rate_validation_start_date DATE;
7069: l_rate_validation_end_date DATE;
7070: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
7071: --
7072: CURSOR csr_pdp_rec
7073: (p_person_id NUMBER
7074: ,p_placement_date_start DATE) IS

Line 7084: FROM per_periods_of_service

7080: CURSOR csr_pds_rec
7081: (p_person_id NUMBER
7082: ,p_pds_hire_date DATE) IS
7083: SELECT period_of_service_id
7084: FROM per_periods_of_service
7085: WHERE person_id = p_person_id
7086: AND date_start = p_pds_hire_date;
7087: --
7088: BEGIN