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_NO_EERR_CONTINUOUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 31: assignment_id per_all_Assignments_f.assignment_id%type

27: proration_type varchar2(10),
28: change_mode pay_process_events.change_type%type,--'DATE_PROCESSED' etc
29: element_entry_id pay_element_entries_f.element_entry_id%type,
30: next_ee number ,
31: assignment_id per_all_Assignments_f.assignment_id%type
32: );
33:
34: TYPE l_detailed_output_table_type IS TABLE OF t_detailed_output_tab_rec
35: INDEX BY BINARY_INTEGER ;

Line 367: per_all_assignments_f paaf,

363: papf.effective_start_date, null effective_end_date, null emp_end_date,
364: national_identifier, full_name, employee_number, normal_hours,
365: hourly_salaried_code, hsc.segment3 position_code, frequency
366: from per_all_people_f papf,
367: per_all_assignments_f paaf,
368: hr_soft_coding_keyflex hsc,
369: per_assignment_status_types past
370: where papf.person_id between p_start_person and p_end_person
371: and paaf.person_id = papf.person_id

Line 380: from per_all_assignments_f asg,hr_soft_coding_keyflex hsck

376: and paaf.assignment_status_type_id =
377: past.assignment_status_type_id
378: and past.PER_SYSTEM_STATUS in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
379: and paaf.assignment_id = (select min(assignment_id)
380: from per_all_assignments_f asg,hr_soft_coding_keyflex hsck
381: where person_id = papf.person_id
382: and hsck.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
383: and hsck.segment2 = to_char (p_local_unit))
384: and p_end_date between paaf.effective_start_date

Line 402: per_all_assignments_f paaf,

398: papf.effective_start_date, paaf.effective_end_date, papf.effective_end_date emp_end_date,
399: national_identifier, full_name, employee_number, normal_hours,
400: hourly_salaried_code, hsc.segment3 position_code, frequency
401: from per_all_people_f papf,
402: per_all_assignments_f paaf,
403: hr_soft_coding_keyflex hsc,
404: per_assignment_status_types past
405: where paaf.person_id = papf.person_id
406: and papf.person_id between p_start_person and p_end_person

Line 414: from per_all_assignments_f asg,hr_soft_coding_keyflex hsck

410: and hsc.segment2 = to_char (p_local_unit)
411: and paaf.assignment_status_type_id =
412: past.assignment_status_type_id
413: and paaf.assignment_id = (select min(assignment_id)
414: from per_all_assignments_f asg,hr_soft_coding_keyflex hsck
415: where person_id = papf.person_id
416: and hsck.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
417: and hsck.segment2 = to_char (p_local_unit))
418: --and past.PER_SYSTEM_STATUS = 'TERM_ASSIGN'

Line 435: p_assignment_id per_all_assignments_f.assignment_id%type

431: --
432: --
433: /* Cursor to get the Start Date of the Assignment */
434: cursor csr_start_date (
435: p_assignment_id per_all_assignments_f.assignment_id%type
436: ) is
437: select min (effective_start_date)
438: from per_all_assignments_f paaf, per_assignment_status_types past
439: where assignment_id = p_assignment_id

Line 438: from per_all_assignments_f paaf, per_assignment_status_types past

434: cursor csr_start_date (
435: p_assignment_id per_all_assignments_f.assignment_id%type
436: ) is
437: select min (effective_start_date)
438: from per_all_assignments_f paaf, per_assignment_status_types past
439: where assignment_id = p_assignment_id
440: and paaf.assignment_status_type_id =
441: past.assignment_status_type_id
442: and past.PER_SYSTEM_STATUS in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');

Line 511: from hr_soft_coding_keyflex hsc, per_all_assignments_f paaf

507: p_effective_date date,
508: p_job_id number
509: ) is
510: select segment3
511: from hr_soft_coding_keyflex hsc, per_all_assignments_f paaf
512: where paaf.job_id = p_job_id
513: and assignment_id = p_assignment_id
514: and p_effective_date between paaf.effective_start_date
515: and paaf.effective_end_date

Line 695: p_assignment_id per_all_assignments_f.assignment_id%type,

691: and screen_entry_value is not null;
692:
693: /* cursor to get the previous changed hour value */
694: cursor previous_hour_value (
695: p_assignment_id per_all_assignments_f.assignment_id%type,
696: p_effective_date date
697: ) is
698: select normal_hours , effective_start_date
699: from per_all_assignments_f

Line 699: from per_all_assignments_f

695: p_assignment_id per_all_assignments_f.assignment_id%type,
696: p_effective_date date
697: ) is
698: select normal_hours , effective_start_date
699: from per_all_assignments_f
700: where assignment_id = p_assignment_id
701: and p_effective_date - 1 between effective_start_date and effective_end_date;
702: -- and effective_start_date < p_effective_date
703: -- order by effective_start_date desc ;

Line 708: p_assignment_id per_all_assignments_f.assignment_id%type,

704:
705: /* Cursor to get all the assignment for the person except the given assignment*/
706: cursor csr_get_all_assignments
707: (p_person_id per_all_people_f.person_id%type,
708: p_assignment_id per_all_assignments_f.assignment_id%type,
709: p_local_unit hr_all_organization_units.organization_id%type)
710: is
711: select assignment_id
712: from per_all_assignments_f paaf ,hr_soft_coding_keyflex hsck

Line 712: from per_all_assignments_f paaf ,hr_soft_coding_keyflex hsck

708: p_assignment_id per_all_assignments_f.assignment_id%type,
709: p_local_unit hr_all_organization_units.organization_id%type)
710: is
711: select assignment_id
712: from per_all_assignments_f paaf ,hr_soft_coding_keyflex hsck
713: where person_id = p_person_id
714: and assignment_id <> p_assignment_id
715: and hsck.segment2 = to_char (p_local_unit)
716: and hsck.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id;

Line 720: p_assignment_id per_all_assignments_f.assignment_id%type,

716: and hsck.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id;
717:
718: /*Cursor csr_get_assignment_details
719: (p_effective_date date,
720: p_assignment_id per_all_assignments_f.assignment_id%type,
721: p_local_unit hr_all_organization_units.organization_id%type)
722: is
723: select normal_hours,
724: hourly_salaried_code, hsc.segment3 position_code, frequency

Line 725: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc

721: p_local_unit hr_all_organization_units.organization_id%type)
722: is
723: select normal_hours,
724: hourly_salaried_code, hsc.segment3 position_code, frequency
725: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc
726: where paaf.assignment_id = p_assignment_id
727: and hsc.segment2 = to_char (p_local_unit)
728: and hsc.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
729: and p_effective_date between paaf.effective_start_date and paaf.effective_End_date;*/

Line 733: p_assignment_id per_all_assignments_f.assignment_id%type)

729: and p_effective_date between paaf.effective_start_date and paaf.effective_End_date;*/
730:
731: Cursor csr_get_assignment_details
732: (p_effective_date date,
733: p_assignment_id per_all_assignments_f.assignment_id%type)
734: is
735: select normal_hours,
736: hourly_salaried_code, hsc.segment3 position_code, frequency
737: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc

Line 737: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc

733: p_assignment_id per_all_assignments_f.assignment_id%type)
734: is
735: select normal_hours,
736: hourly_salaried_code, hsc.segment3 position_code, frequency
737: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc
738: where paaf.assignment_id = p_assignment_id
739: --and hsc.segment2 = to_char (p_local_unit)
740: and hsc.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
741: and p_effective_date between paaf.effective_start_date and paaf.effective_End_date;

Line 746: p_assignment_id per_all_assignments_f.assignment_id%type,

742:
743: rl_assignment_details csr_get_assignment_details%rowtype;
744:
745: cursor curr_hours_frequency (
746: p_assignment_id per_all_assignments_f.assignment_id%type,
747: p_effective_date date ) is
748: select normal_hours, frequency
749: from per_all_assignments_f
750: where assignment_id = p_assignment_id

Line 749: from per_all_assignments_f

745: cursor curr_hours_frequency (
746: p_assignment_id per_all_assignments_f.assignment_id%type,
747: p_effective_date date ) is
748: select normal_hours, frequency
749: from per_all_assignments_f
750: where assignment_id = p_assignment_id
751: and p_effective_date between effective_start_date and effective_end_date;
752:
753: cursor curr_lu_org_number (

Line 754: p_assignment_id per_all_assignments_f.assignment_id%type,

750: where assignment_id = p_assignment_id
751: and p_effective_date between effective_start_date and effective_end_date;
752:
753: cursor curr_lu_org_number (
754: p_assignment_id per_all_assignments_f.assignment_id%type,
755: p_effective_date date ) is
756: select org_information1
757: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc,hr_organization_information hoi
758: where paaf.assignment_id = p_assignment_id

Line 757: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc,hr_organization_information hoi

753: cursor curr_lu_org_number (
754: p_assignment_id per_all_assignments_f.assignment_id%type,
755: p_effective_date date ) is
756: select org_information1
757: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc,hr_organization_information hoi
758: where paaf.assignment_id = p_assignment_id
759: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date
760: and hsc.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
761: and hoi.org_information_context = 'NO_LOCAL_UNIT_DETAILS'

Line 765: p_assignment_id per_all_assignments_f.assignment_id%type,

761: and hoi.org_information_context = 'NO_LOCAL_UNIT_DETAILS'
762: and hoi.organization_id = hsc.segment2;
763:
764: cursor curr_position_code (
765: p_assignment_id per_all_assignments_f.assignment_id%type,
766: p_effective_date date ) is
767: select segment3
768: from hr_soft_coding_keyflex hsc, per_all_assignments_f paaf
769: where paaf.assignment_id = p_assignment_id

Line 768: from hr_soft_coding_keyflex hsc, per_all_assignments_f paaf

764: cursor curr_position_code (
765: p_assignment_id per_all_assignments_f.assignment_id%type,
766: p_effective_date date ) is
767: select segment3
768: from hr_soft_coding_keyflex hsc, per_all_assignments_f paaf
769: where paaf.assignment_id = p_assignment_id
770: and p_effective_date between paaf.effective_start_date
771: and paaf.effective_end_date
772: and paaf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id;

Line 815: l_frequency per_all_assignments_f.frequency%type;

811: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
812: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
813: l_total_hours number := 0;
814: l_total_hours_all number := 0;
815: l_frequency per_all_assignments_f.frequency%type;
816: l_hour_effective_end_date date;
817: l_hour_value varchar2 (100);
818: l_hour_value1 varchar2 (100);
819: l_job_value varchar2 (100);

Line 876: l_curr_frequency per_all_assignments_f.frequency%type;

872: l_local_unit_org_no hr_organization_information.org_information1%type; /* 5519990 */
873: l_national_identifier per_all_people_f.national_identifier%type; /* 5526181 */
874: l_old_date date;
875: l_curr_hours number;
876: l_curr_frequency per_all_assignments_f.frequency%type;
877: l_eff_end_date_need char (1);
878: l_curr_position varchar2 (100);
879: /* Work schedule variables 5525977 */
880: l_days_or_hours Varchar2(10) := 'D';

Line 1018: open csr_get_table_id ('PER_ALL_ASSIGNMENTS_F');

1014: open csr_get_table_id ('PAY_ELEMENT_ENTRY_VALUES_F');
1015: fetch csr_get_table_id into l_table2;
1016: close csr_get_table_id;
1017: --
1018: open csr_get_table_id ('PER_ALL_ASSIGNMENTS_F');
1019: fetch csr_get_table_id into l_table3;
1020: close csr_get_table_id;
1021: --
1022: open csr_event_group_details (

Line 2838: p_assignment_id in per_all_assignments_f.assignment_id%type,

2834: return p_total_hours;
2835: end;
2836:
2837: function get_assignment_all_hours (
2838: p_assignment_id in per_all_assignments_f.assignment_id%type,
2839: p_person_id in per_all_people_f.person_id%type,
2840: p_effective_date in date,
2841: p_primary_hour_value number,
2842: p_local_unit number

Line 2846: p_assignment_id per_all_assignments_f.assignment_id%type,

2842: p_local_unit number
2843: )
2844: return number is
2845: cursor csr_hour_frequency (
2846: p_assignment_id per_all_assignments_f.assignment_id%type,
2847: p_effective_date date
2848: ) is
2849: select frequency
2850: from per_all_assignments_f

Line 2850: from per_all_assignments_f

2846: p_assignment_id per_all_assignments_f.assignment_id%type,
2847: p_effective_date date
2848: ) is
2849: select frequency
2850: from per_all_assignments_f
2851: where assignment_id = p_assignment_id
2852: and p_effective_date between effective_start_date
2853: and effective_end_date;
2854:

Line 2857: p_assignment_id per_all_assignments_f.assignment_id%type,

2853: and effective_end_date;
2854:
2855: cursor csr_all_assignments_hours (
2856: p_person_id per_all_people_f.person_id%type,
2857: p_assignment_id per_all_assignments_f.assignment_id%type,
2858: p_effective_date date,
2859: p_local_unit number
2860: ) is
2861: select normal_hours, frequency

Line 2862: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc

2858: p_effective_date date,
2859: p_local_unit number
2860: ) is
2861: select normal_hours, frequency
2862: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc
2863: where paaf.person_id = p_person_id
2864: and paaf.assignment_id <> p_assignment_id
2865: and paaf.normal_hours is not null
2866: and hsc.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id

Line 2871: l_frequency per_all_assignments_f.frequency%type;

2867: and hsc.segment2 = to_char (p_local_unit)
2868: and hourly_salaried_code = 'S'
2869: and p_effective_date between paaf.effective_start_date
2870: and paaf.effective_end_date;
2871: l_frequency per_all_assignments_f.frequency%type;
2872: l_total_hours number := 0;
2873: l_total_hours_all number := 0;
2874: begin
2875: open csr_hour_frequency (p_assignment_id, p_effective_date);