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 975: FROM per_all_assignments_f asg, per_periods_of_service pds

971: -- get the pds id id and ovn
972: SELECT asg.period_of_service_id,
973: pds.object_version_number
974: INTO l_pos_id, l_pos_ovn
975: FROM per_all_assignments_f asg, per_periods_of_service pds
976: WHERE asg.assignment_id = l_assignment_id
977: and asg.period_of_service_id = pds.period_of_service_id;
978:
979: p_period_of_service_id := l_pos_id;

Line 3046: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE

3042: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
3043: ,p_current_employer IN per_applications.current_employer%TYPE
3044: ,p_termination_reason IN per_applications.termination_reason%TYPE
3045: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
3046: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
3047: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
3048: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
3049: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
3050: ,p_adr_date_from IN per_addresses.date_from%TYPE

Line 3047: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE

3043: ,p_current_employer IN per_applications.current_employer%TYPE
3044: ,p_termination_reason IN per_applications.termination_reason%TYPE
3045: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
3046: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
3047: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
3048: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
3049: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
3050: ,p_adr_date_from IN per_addresses.date_from%TYPE
3051: ,p_style IN per_addresses.style%TYPE

Line 3048: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE

3044: ,p_termination_reason IN per_applications.termination_reason%TYPE
3045: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
3046: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
3047: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
3048: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
3049: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
3050: ,p_adr_date_from IN per_addresses.date_from%TYPE
3051: ,p_style IN per_addresses.style%TYPE
3052: ,p_address_line1 IN per_addresses.address_line1%TYPE

Line 7064: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE

7060: ,p_asg_validation_end_date OUT NOCOPY DATE
7061: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE
7062: ,p_application_id per_applications.application_id%TYPE
7063: ,p_app_object_version_number per_applications.object_version_number%TYPE
7064: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
7065: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
7066: ,p_address_id per_addresses.address_id%TYPE
7067: ,p_addr_object_version_number per_addresses.object_version_number%TYPE
7068: ,p_phn_h_phone_id per_phones.phone_id%TYPE

Line 7065: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE

7061: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE
7062: ,p_application_id per_applications.application_id%TYPE
7063: ,p_app_object_version_number per_applications.object_version_number%TYPE
7064: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
7065: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
7066: ,p_address_id per_addresses.address_id%TYPE
7067: ,p_addr_object_version_number per_addresses.object_version_number%TYPE
7068: ,p_phn_h_phone_id per_phones.phone_id%TYPE
7069: ,p_phn_h_object_version_number per_phones.object_version_number%TYPE

Line 7110: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;

7106: l_rate_datetrack_update_mode VARCHAR2(30);
7107: l_period_of_placement_id per_periods_of_placement.period_of_placement_id%TYPE;
7108: l_rate_validation_start_date DATE;
7109: l_rate_validation_end_date DATE;
7110: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
7111: --
7112: CURSOR csr_pdp_rec
7113: (p_person_id NUMBER
7114: ,p_placement_date_start DATE) IS

Line 7124: FROM per_periods_of_service

7120: CURSOR csr_pds_rec
7121: (p_person_id NUMBER
7122: ,p_pds_hire_date DATE) IS
7123: SELECT period_of_service_id
7124: FROM per_periods_of_service
7125: WHERE person_id = p_person_id
7126: AND date_start = p_pds_hire_date;
7127: --
7128: BEGIN