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

Line 2347: FROM per_all_assignments_f paf

2343: ) IS
2344:
2345: CURSOR c_get_report_term_rehire (cp_asg_id IN NUMBER) IS
2346: SELECT segment10
2347: FROM per_all_assignments_f paf
2348: ,hr_soft_coding_keyflex hck
2349: WHERE paf.assignment_id = cp_asg_id
2350: AND paf.soft_coding_keyflex_id = hck.soft_coding_keyflex_id;
2351:

Line 2356: FROM per_all_assignments_f paf

2352: CURSOR c_get_asg_scl (cp_asg_id IN NUMBER
2353: ,cp_effective_date IN DATE) IS
2354: SELECT segment1
2355: ,assignment_number
2356: FROM per_all_assignments_f paf
2357: ,hr_soft_coding_keyflex hck
2358: WHERE paf.assignment_id = cp_asg_id
2359: AND cp_effective_date BETWEEN paf.effective_start_date
2360: AND paf.effective_end_date

Line 2367: FROM per_all_assignments_f

2363: CURSOR c_get_asg_loc (cp_asg_id IN NUMBER
2364: ,cp_effective_date IN DATE) IS
2365: SELECT location_id
2366: ,assignment_number
2367: FROM per_all_assignments_f
2368: WHERE assignment_id = cp_asg_id
2369: AND cp_effective_date BETWEEN effective_start_date
2370: AND effective_end_date;
2371:

Line 2409: per_all_assignments_f paf

2405: ,cp_effective_date IN DATE ) IS
2406: SELECT pds_information1
2407: ,actual_termination_date
2408: FROM per_periods_of_service ppos,
2409: per_all_assignments_f paf
2410: WHERE paf.assignment_id = cp_assignment_id
2411: AND paf.person_id = ppos.person_id
2412: AND cp_effective_date BETWEEN paf.effective_start_date
2413: AND paf.effective_end_date

Line 2609: hr_utility_trace ('column_name = PER_ALL_ASSIGNMENTS_F.'||

2605: ELSE
2606:
2607: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2608: ln_step := 4;
2609: hr_utility_trace ('column_name = PER_ALL_ASSIGNMENTS_F.'||
2610: p_asg_events(i).column_name);
2611: IF p_asg_events(i).column_name = 'LOCATION_ID' THEN
2612:
2613: hr_utility.set_location(gv_package || lv_procedure_name, 50);

Line 2871: FROM per_all_assignments_f

2867: hire_sep(ln_count).trn_type := 'SEPARATION';
2868:
2869: SELECT COUNT(*)
2870: INTO ln_asg_count
2871: FROM per_all_assignments_f
2872: WHERE assignment_id = p_assignment_id
2873: AND effective_start_date = p_asg_events(i).effective_date;
2874:
2875: IF ln_asg_count > 0 THEN

Line 3270: FROM per_all_assignments_f paf

3266: ,paf.location_id
3267: ,paf.soft_coding_keyflex_id
3268: ,paf.effective_start_date
3269: ,paf.effective_end_date
3270: FROM per_all_assignments_f paf
3271: WHERE paf.assignment_id = cp_assignment_id
3272: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
3273: paf.location_id
3274: ,paf.business_group_id

Line 3406: /*IF lv_table_name = 'PER_ALL_ASSIGNMENTS_F' THEN

3402: IF int_pkg_events.COUNT > 0 THEN
3403:
3404: FOR i IN 1..int_pkg_events.COUNT
3405: LOOP
3406: /*IF lv_table_name = 'PER_ALL_ASSIGNMENTS_F' THEN
3407: IF int_pkg_events(i).column_name = 'LOCATION_ID' THEN
3408: int_pkg_events(i).effective_date :=
3409: int_pkg_events(i).effective_date - 1;
3410: END IF;

Line 3439: IF lv_table_name = 'PER_ALL_ASSIGNMENTS_F' THEN

3435: hr_utility_trace('-----------------------------------------------');
3436: hr_utility_trace('lv_table_name :' ||lv_table_name );
3437:
3438:
3439: IF lv_table_name = 'PER_ALL_ASSIGNMENTS_F' THEN
3440:
3441: asg_count := asg_count + 1;
3442: asg_events(asg_count) := int_pkg_events(i);
3443:

Line 3570: FROM per_all_assignments_f paf

3566: , cp_end_date IN DATE*/ ) IS
3567: SELECT paf.location_id
3568: ,paf.soft_coding_keyflex_id
3569: ,substr(paf.employment_category,3,1) worker_type
3570: FROM per_all_assignments_f paf
3571: WHERE paf.assignment_id = cp_assignment_id
3572: AND cp_effective_date BETWEEN paf.effective_start_date
3573: AND paf.effective_end_date;
3574: /*AND paf.effective_start_date =

Line 3576: FROM per_all_assignments_f paf_in

3572: AND cp_effective_date BETWEEN paf.effective_start_date
3573: AND paf.effective_end_date;
3574: /*AND paf.effective_start_date =
3575: ( SELECT max(paf_in.effective_start_date)
3576: FROM per_all_assignments_f paf_in
3577: WHERE paf_in.assignment_id = paf.assignment_id
3578: AND trunc(cp_end_date) >= paf_in.effective_start_date
3579: AND trunc(cp_start_date) <= paf_in.effective_end_date);*/
3580:

Line 3615: ,per_all_assignments_f paf

3611: ,cp_effective_date DATE ) IS
3612: SELECT pee.element_entry_id
3613: ,pee.element_type_id
3614: FROM pay_element_entries_f pee
3615: ,per_all_assignments_f paf
3616: WHERE paf.person_id = cp_person_id
3617: AND cp_effective_date BETWEEN paf.effective_start_date
3618: AND paf.effective_end_date
3619: AND pee.assignment_id = paf.assignment_id + 0