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 2471: FROM per_all_assignments_f paf

2467: ) IS
2468:
2469: CURSOR c_get_report_term_rehire (cp_asg_id IN NUMBER) IS
2470: SELECT segment10
2471: FROM per_all_assignments_f paf
2472: ,hr_soft_coding_keyflex hck
2473: WHERE paf.assignment_id = cp_asg_id
2474: AND paf.soft_coding_keyflex_id = hck.soft_coding_keyflex_id;
2475:

Line 2480: FROM per_all_assignments_f paf

2476: CURSOR c_get_asg_scl (cp_asg_id IN NUMBER
2477: ,cp_effective_date IN DATE) IS
2478: SELECT segment1
2479: ,assignment_number
2480: FROM per_all_assignments_f paf
2481: ,hr_soft_coding_keyflex hck
2482: WHERE paf.assignment_id = cp_asg_id
2483: AND cp_effective_date BETWEEN paf.effective_start_date
2484: AND paf.effective_end_date

Line 2491: FROM per_all_assignments_f

2487: CURSOR c_get_asg_loc (cp_asg_id IN NUMBER
2488: ,cp_effective_date IN DATE) IS
2489: SELECT location_id
2490: ,assignment_number
2491: FROM per_all_assignments_f
2492: WHERE assignment_id = cp_asg_id
2493: AND cp_effective_date BETWEEN effective_start_date
2494: AND effective_end_date;
2495:

Line 2533: per_all_assignments_f paf

2529: ,cp_effective_date IN DATE ) IS
2530: SELECT pds_information1
2531: ,actual_termination_date
2532: FROM per_periods_of_service ppos,
2533: per_all_assignments_f paf
2534: WHERE paf.assignment_id = cp_assignment_id
2535: AND paf.person_id = ppos.person_id
2536: AND cp_effective_date BETWEEN paf.effective_start_date
2537: AND paf.effective_end_date

Line 2600: FROM per_all_assignments_f paf

2596: /*bug 6933682*/
2597: CURSOR c_salary_type ( cp_assignment_id IN NUMBER
2598: ,cp_effective_date IN DATE) IS
2599: SELECT hck.segment6
2600: FROM per_all_assignments_f paf
2601: ,hr_soft_coding_keyflex hck
2602: WHERE paf.assignment_id = cp_assignment_id
2603: AND paf.soft_coding_keyflex_id = hck.soft_coding_keyflex_id
2604: AND cp_effective_date BETWEEN paf.effective_start_date

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

2751: ELSE
2752:
2753: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2754: ln_step := 4;
2755: hr_utility_trace ('column_name = PER_ALL_ASSIGNMENTS_F.'||
2756: p_asg_events(i).column_name);
2757: IF p_asg_events(i).column_name = 'LOCATION_ID' THEN
2758:
2759: hr_utility.set_location(gv_package || lv_procedure_name, 50);

Line 3017: FROM per_all_assignments_f

3013: hire_sep(ln_count).trn_type := 'SEPARATION';
3014:
3015: SELECT COUNT(*)
3016: INTO ln_asg_count
3017: FROM per_all_assignments_f
3018: WHERE assignment_id = p_assignment_id
3019: AND effective_start_date = p_asg_events(i).effective_date;
3020:
3021: IF ln_asg_count > 0 THEN

Line 3472: FROM per_all_assignments_f paf

3468: ,paf.location_id
3469: ,paf.soft_coding_keyflex_id
3470: ,paf.effective_start_date
3471: ,paf.effective_end_date
3472: FROM per_all_assignments_f paf
3473: WHERE paf.assignment_id = cp_assignment_id
3474: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
3475: paf.location_id
3476: ,paf.business_group_id

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

3607: IF int_pkg_events.COUNT > 0 THEN
3608:
3609: FOR i IN 1..int_pkg_events.COUNT
3610: LOOP
3611: /*IF lv_table_name = 'PER_ALL_ASSIGNMENTS_F' THEN
3612: IF int_pkg_events(i).column_name = 'LOCATION_ID' THEN
3613: int_pkg_events(i).effective_date :=
3614: int_pkg_events(i).effective_date - 1;
3615: END IF;

Line 3644: IF lv_table_name = 'PER_ALL_ASSIGNMENTS_F' THEN

3640: hr_utility_trace('-----------------------------------------------');
3641: hr_utility_trace('lv_table_name :' ||lv_table_name );
3642:
3643:
3644: IF lv_table_name = 'PER_ALL_ASSIGNMENTS_F' THEN
3645:
3646: asg_count := asg_count + 1;
3647: asg_events(asg_count) := int_pkg_events(i);
3648:

Line 3783: FROM per_all_assignments_f paf

3779: , cp_end_date IN DATE*/ ) IS
3780: SELECT paf.location_id
3781: ,paf.soft_coding_keyflex_id
3782: ,substr(paf.employment_category,3,1) worker_type
3783: FROM per_all_assignments_f paf
3784: WHERE paf.assignment_id = cp_assignment_id
3785: AND cp_effective_date BETWEEN paf.effective_start_date
3786: AND paf.effective_end_date;
3787: /*AND paf.effective_start_date =

Line 3789: FROM per_all_assignments_f paf_in

3785: AND cp_effective_date BETWEEN paf.effective_start_date
3786: AND paf.effective_end_date;
3787: /*AND paf.effective_start_date =
3788: ( SELECT max(paf_in.effective_start_date)
3789: FROM per_all_assignments_f paf_in
3790: WHERE paf_in.assignment_id = paf.assignment_id
3791: AND trunc(cp_end_date) >= paf_in.effective_start_date
3792: AND trunc(cp_start_date) <= paf_in.effective_end_date);*/
3793:

Line 3828: ,per_all_assignments_f paf

3824: ,cp_effective_date DATE ) IS
3825: SELECT pee.element_entry_id
3826: ,pee.element_type_id
3827: FROM pay_element_entries_f pee
3828: ,per_all_assignments_f paf
3829: WHERE paf.person_id = cp_person_id
3830: AND cp_effective_date BETWEEN paf.effective_start_date
3831: AND paf.effective_end_date
3832: AND pee.assignment_id = paf.assignment_id + 0