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 2141: l_table_name(i) := 'PER_ALL_ASSIGNMENTS_F';

2137: debug_enter(l_proc_name);
2138: END IF;
2139:
2140: i := 1;
2141: l_table_name(i) := 'PER_ALL_ASSIGNMENTS_F';
2142: i := i + 1;
2143: l_table_name(i) := 'PAY_ELEMENT_ENTRIES_F';
2144: i := i + 1;
2145: l_table_name(i) := 'PAY_ELEMENT_ENTRY_VALUES_F';

Line 2806: FROM per_all_assignments_f

2802: IS
2803: SELECT person_id, effective_start_date, effective_end_date
2804: ,assignment_number, primary_flag, normal_hours
2805: ,assignment_status_type_id, employment_category
2806: FROM per_all_assignments_f
2807: WHERE assignment_id = p_assignment_id
2808: AND p_effective_date BETWEEN effective_start_date
2809: AND effective_end_date
2810: ORDER BY effective_start_date DESC;

Line 3222: FROM per_all_assignments_f asg1, per_all_assignments_f asg2

3218: ,asg1.effective_end_date curr_effective_end_date
3219: ,asg2.assignment_status_type_id prev_status_type_id
3220: ,asg2.effective_start_date prev_effective_start_date
3221: ,asg2.effective_end_date prev_effective_end_date
3222: FROM per_all_assignments_f asg1, per_all_assignments_f asg2
3223: WHERE asg1.assignment_id = p_assignment_id
3224: AND (
3225: (
3226: asg1.effective_start_date BETWEEN c_effective_start_date

Line 3245: FROM per_all_assignments_f

3241: -- for this employment category
3242: CURSOR csr_get_asg_start_date(c_employment_category VARCHAR2)
3243: IS
3244: SELECT MIN(effective_start_date)
3245: FROM per_all_assignments_f
3246: WHERE assignment_id = p_assignment_id
3247: AND employment_category = c_employment_category;
3248:
3249: -- Cursor to fetch absence details for this person

Line 3348: FROM per_all_assignments_f

3344: -- Cursor to check assignment details
3345: CURSOR csr_get_asg_details(c_effective_date DATE)
3346: IS
3347: SELECT effective_end_date
3348: FROM per_all_assignments_f
3349: WHERE assignment_id = p_assignment_id
3350: AND c_effective_date BETWEEN effective_start_date
3351: AND effective_end_date
3352: ORDER BY effective_start_date;

Line 3371: FROM per_all_assignments_f asg,

3367: --For bug 7705147: Cursor to get Actual Termination Date
3368: CURSOR csr_get_atd
3369: IS
3370: SELECT pos.actual_termination_date
3371: FROM per_all_assignments_f asg,
3372: per_periods_of_service pos
3373: WHERE asg.assignment_id = p_assignment_id
3374: AND g_effective_date between asg.effective_start_date AND asg.effective_end_date
3375: AND asg.period_of_service_id = pos.period_of_service_id;

Line 4551: FROM per_all_assignments_f paf,

4547: -- For Bug 5970465
4548: CURSOR csr_get_term_date
4549: IS
4550: SELECT actual_termination_date
4551: FROM per_all_assignments_f paf,
4552: per_periods_of_service pos
4553: WHERE paf.assignment_id=p_assignment_id
4554: AND paf.period_of_service_id = pos.period_of_service_id;
4555:

Line 4800: FROM per_all_assignments_f paf,

4796: --For Bug 6972649 from here
4797: CURSOR csr_get_act_term_date
4798: IS
4799: SELECT actual_termination_date
4800: FROM per_all_assignments_f paf,
4801: per_periods_of_service pos
4802: WHERE paf.assignment_id=p_assignment_id
4803: AND paf.period_of_service_id = pos.period_of_service_id;
4804: --For Bug 6972649 till here

Line 5169: FROM per_all_assignments_f

5165: -- for this employment category
5166: CURSOR csr_get_asg_start_date(c_employment_category VARCHAR2)
5167: IS
5168: SELECT MIN(effective_start_date)
5169: FROM per_all_assignments_f
5170: WHERE assignment_id = p_assignment_id
5171: AND employment_category = c_employment_category;
5172:
5173: -- Cursor to check assignment details

Line 5181: FROM per_all_assignments_f paaf,

5177: -- For Bug 6836466
5178: CURSOR csr_get_asg_details
5179: IS
5180: SELECT effective_end_date
5181: FROM per_all_assignments_f paaf,
5182: per_periods_of_service pps,
5183: per_assignment_status_types past
5184: WHERE paaf.assignment_id = p_assignment_id
5185: AND paaf.assignment_status_type_id = past.assignment_status_type_id

Line 5198: FROM per_all_assignments_f

5194: --For bug 7013325: Start here
5195: CURSOR csr_get_hire_date
5196: IS
5197: SELECT MIN(effective_start_date)
5198: FROM per_all_assignments_f
5199: WHERE assignment_id = p_assignment_id;
5200: --For bug 7013325: End here
5201:
5202: --For Bug 5998108

Line 5850: FROM per_all_assignments_f

5846: -- for this employment category
5847: CURSOR csr_get_asg_start_date(c_employment_category VARCHAR2)
5848: IS
5849: SELECT MIN(effective_start_date)
5850: FROM per_all_assignments_f
5851: WHERE assignment_id = p_assignment_id
5852: AND employment_category = c_employment_category;
5853:
5854: -- Cursor to fetch termination details

Line 5859: FROM per_all_assignments_f paf,

5855: --115.21 5945283 CURSOR csr_get_ser_details modified
5856:
5857: CURSOR csr_get_ser_details IS --in 115.21 5945283
5858: SELECT leaving_reason, actual_termination_date,final_process_date
5859: FROM per_all_assignments_f paf,
5860: per_periods_of_service pos
5861: WHERE paf.assignment_id=p_assignment_id
5862: AND paf.period_of_service_id = pos.period_of_service_id;
5863: --date join not required as all rows will have same data.

Line 6399: ELSIF l_table_name = 'PER_ALL_ASSIGNMENTS_F'

6395:
6396: END IF; -- End if of leaving reason is not null check ...
6397: END IF; -- Check for assignment status is termination
6398: END IF; -- Check whether actual termination date is not null ...
6399: ELSIF l_table_name = 'PER_ALL_ASSIGNMENTS_F'
6400: THEN
6401: -- This is an assignment status change
6402:
6403: --For Bug 7034476:Start