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.PQP_GB_PSI_SERVICE_HISTORY dependencies on PER_ALL_ASSIGNMENTS_F

Line 2123: l_table_name(i) := 'PER_ALL_ASSIGNMENTS_F';

2119: debug_enter(l_proc_name);
2120: END IF;
2121:
2122: i := 1;
2123: l_table_name(i) := 'PER_ALL_ASSIGNMENTS_F';
2124: i := i + 1;
2125: l_table_name(i) := 'PAY_ELEMENT_ENTRIES_F';
2126: i := i + 1;
2127: l_table_name(i) := 'PAY_ELEMENT_ENTRY_VALUES_F';

Line 2788: FROM per_all_assignments_f

2784: IS
2785: SELECT person_id, effective_start_date, effective_end_date
2786: ,assignment_number, primary_flag, normal_hours
2787: ,assignment_status_type_id, employment_category
2788: FROM per_all_assignments_f
2789: WHERE assignment_id = p_assignment_id
2790: AND p_effective_date BETWEEN effective_start_date
2791: AND effective_end_date
2792: ORDER BY effective_start_date DESC;

Line 3204: FROM per_all_assignments_f asg1, per_all_assignments_f asg2

3200: ,asg1.effective_end_date curr_effective_end_date
3201: ,asg2.assignment_status_type_id prev_status_type_id
3202: ,asg2.effective_start_date prev_effective_start_date
3203: ,asg2.effective_end_date prev_effective_end_date
3204: FROM per_all_assignments_f asg1, per_all_assignments_f asg2
3205: WHERE asg1.assignment_id = p_assignment_id
3206: AND (
3207: (
3208: asg1.effective_start_date BETWEEN c_effective_start_date

Line 3227: FROM per_all_assignments_f

3223: -- for this employment category
3224: CURSOR csr_get_asg_start_date(c_employment_category VARCHAR2)
3225: IS
3226: SELECT MIN(effective_start_date)
3227: FROM per_all_assignments_f
3228: WHERE assignment_id = p_assignment_id
3229: AND employment_category = c_employment_category;
3230:
3231: -- Cursor to fetch absence details for this person

Line 3330: FROM per_all_assignments_f

3326: -- Cursor to check assignment details
3327: CURSOR csr_get_asg_details(c_effective_date DATE)
3328: IS
3329: SELECT effective_end_date
3330: FROM per_all_assignments_f
3331: WHERE assignment_id = p_assignment_id
3332: AND c_effective_date BETWEEN effective_start_date
3333: AND effective_end_date
3334: ORDER BY effective_start_date;

Line 4497: FROM per_all_assignments_f paf,

4493: -- For Bug 5970465
4494: CURSOR csr_get_term_date
4495: IS
4496: SELECT actual_termination_date
4497: FROM per_all_assignments_f paf,
4498: per_periods_of_service pos
4499: WHERE paf.assignment_id=p_assignment_id
4500: AND paf.period_of_service_id = pos.period_of_service_id;
4501:

Line 4746: FROM per_all_assignments_f paf,

4742: --For Bug 6972649 from here
4743: CURSOR csr_get_act_term_date
4744: IS
4745: SELECT actual_termination_date
4746: FROM per_all_assignments_f paf,
4747: per_periods_of_service pos
4748: WHERE paf.assignment_id=p_assignment_id
4749: AND paf.period_of_service_id = pos.period_of_service_id;
4750: --For Bug 6972649 till here

Line 5115: FROM per_all_assignments_f

5111: -- for this employment category
5112: CURSOR csr_get_asg_start_date(c_employment_category VARCHAR2)
5113: IS
5114: SELECT MIN(effective_start_date)
5115: FROM per_all_assignments_f
5116: WHERE assignment_id = p_assignment_id
5117: AND employment_category = c_employment_category;
5118:
5119: -- Cursor to check assignment details

Line 5127: FROM per_all_assignments_f paaf,

5123: -- For Bug 6836466
5124: CURSOR csr_get_asg_details
5125: IS
5126: SELECT effective_end_date
5127: FROM per_all_assignments_f paaf,
5128: per_periods_of_service pps,
5129: per_assignment_status_types past
5130: WHERE paaf.assignment_id = p_assignment_id
5131: AND paaf.assignment_status_type_id = past.assignment_status_type_id

Line 5144: FROM per_all_assignments_f

5140: --For bug 7013325: Start here
5141: CURSOR csr_get_hire_date
5142: IS
5143: SELECT MIN(effective_start_date)
5144: FROM per_all_assignments_f
5145: WHERE assignment_id = p_assignment_id;
5146: --For bug 7013325: End here
5147:
5148: --For Bug 5998108

Line 5788: FROM per_all_assignments_f

5784: -- for this employment category
5785: CURSOR csr_get_asg_start_date(c_employment_category VARCHAR2)
5786: IS
5787: SELECT MIN(effective_start_date)
5788: FROM per_all_assignments_f
5789: WHERE assignment_id = p_assignment_id
5790: AND employment_category = c_employment_category;
5791:
5792: -- Cursor to fetch termination details

Line 5797: FROM per_all_assignments_f paf,

5793: --115.21 5945283 CURSOR csr_get_ser_details modified
5794:
5795: CURSOR csr_get_ser_details IS --in 115.21 5945283
5796: SELECT leaving_reason, actual_termination_date,final_process_date
5797: FROM per_all_assignments_f paf,
5798: per_periods_of_service pos
5799: WHERE paf.assignment_id=p_assignment_id
5800: AND paf.period_of_service_id = pos.period_of_service_id;
5801: --date join not required as all rows will have same data.

Line 6337: ELSIF l_table_name = 'PER_ALL_ASSIGNMENTS_F'

6333:
6334: END IF; -- End if of leaving reason is not null check ...
6335: END IF; -- Check for assignment status is termination
6336: END IF; -- Check whether actual termination date is not null ...
6337: ELSIF l_table_name = 'PER_ALL_ASSIGNMENTS_F'
6338: THEN
6339: -- This is an assignment status change
6340:
6341: --For Bug 7034476:Start