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

Line 24: assignment_id per_all_Assignments_f.assignment_id%type

20: proration_type varchar2(10),
21: change_mode pay_process_events.change_type%type,--'DATE_PROCESSED' etc
22: element_entry_id pay_element_entries_f.element_entry_id%type,
23: next_ee number ,
24: assignment_id per_all_Assignments_f.assignment_id%type
25: );
26:
27: TYPE l_detailed_output_table_type IS TABLE OF t_detailed_output_tab_rec
28: INDEX BY BINARY_INTEGER ;

Line 342: per_all_assignments_f paaf,

338: papf.effective_start_date, null effective_end_date,
339: national_identifier, full_name, employee_number, normal_hours,
340: hourly_salaried_code, hsc.segment3 position_code, frequency
341: from per_all_people_f papf,
342: per_all_assignments_f paaf,
343: hr_soft_coding_keyflex hsc,
344: per_assignment_status_types past
345: where papf.person_id between p_start_person and p_end_person
346: and paaf.person_id = papf.person_id

Line 355: from per_all_assignments_f asg,

351: and paaf.assignment_status_type_id =
352: past.assignment_status_type_id
353: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
354: and paaf.assignment_id = (select min (assignment_id)
355: from per_all_assignments_f asg,
356: hr_soft_coding_keyflex hsck
357: where person_id = papf.person_id
358: and hsck.soft_coding_keyflex_id =
359: asg.soft_coding_keyflex_id

Line 419: per_all_assignments_f paaf,

415: papf.effective_start_date, paaf.effective_end_date,
416: national_identifier, full_name, employee_number, normal_hours,
417: hourly_salaried_code, hsc.segment3 position_code, frequency
418: from per_all_people_f papf,
419: per_all_assignments_f paaf,
420: hr_soft_coding_keyflex hsc,
421: per_assignment_status_types past
422: where paaf.person_id = papf.person_id
423: and papf.person_id between p_start_person and p_end_person

Line 431: from per_all_assignments_f asg,

427: and hsc.segment2 = to_char (p_local_unit)
428: and paaf.assignment_status_type_id =
429: past.assignment_status_type_id
430: and paaf.assignment_id = (select min (assignment_id)
431: from per_all_assignments_f asg,
432: hr_soft_coding_keyflex hsck
433: where person_id = papf.person_id
434: and hsck.soft_coding_keyflex_id =
435: asg.soft_coding_keyflex_id

Line 501: p_assignment_id per_all_assignments_f.assignment_id%type

497: --
498: --
499: /* Cursor to get the Start Date of the Assignment */
500: cursor csr_start_date (
501: p_assignment_id per_all_assignments_f.assignment_id%type
502: ) is
503: select min (effective_start_date)
504: from per_all_assignments_f paaf, per_assignment_status_types past
505: where assignment_id = p_assignment_id

Line 504: from per_all_assignments_f paaf, per_assignment_status_types past

500: cursor csr_start_date (
501: p_assignment_id per_all_assignments_f.assignment_id%type
502: ) is
503: select min (effective_start_date)
504: from per_all_assignments_f paaf, per_assignment_status_types past
505: where assignment_id = p_assignment_id
506: and paaf.assignment_status_type_id =
507: past.assignment_status_type_id
508: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');

Line 689: from hr_soft_coding_keyflex hsc, per_all_assignments_f paaf

685: p_effective_date date,
686: p_job_id number
687: ) is
688: select segment3
689: from hr_soft_coding_keyflex hsc, per_all_assignments_f paaf
690: where paaf.job_id = p_job_id
691: and assignment_id = p_assignment_id
692: and p_effective_date between paaf.effective_start_date
693: and paaf.effective_end_date

Line 862: p_assignment_id per_all_assignments_f.assignment_id%type,

858:
859: /* Cursor to get all the assignment for the person except the given assignment*/
860: cursor csr_get_all_assignments
861: (p_person_id per_all_people_f.person_id%type,
862: p_assignment_id per_all_assignments_f.assignment_id%type,
863: p_local_unit hr_all_organization_units.organization_id%type)
864: is
865: select assignment_id
866: from per_all_assignments_f paaf ,hr_soft_coding_keyflex hsck

Line 866: from per_all_assignments_f paaf ,hr_soft_coding_keyflex hsck

862: p_assignment_id per_all_assignments_f.assignment_id%type,
863: p_local_unit hr_all_organization_units.organization_id%type)
864: is
865: select assignment_id
866: from per_all_assignments_f paaf ,hr_soft_coding_keyflex hsck
867: where person_id = p_person_id
868: and assignment_id <> p_assignment_id
869: and hsck.segment2 = to_char (p_local_unit)
870: and hsck.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id;

Line 875: p_assignment_id per_all_assignments_f.assignment_id%type,

871:
872:
873: Cursor csr_get_assignment_details
874: (p_effective_date date,
875: p_assignment_id per_all_assignments_f.assignment_id%type,
876: p_local_unit hr_all_organization_units.organization_id%type)
877: is
878: select normal_hours,
879: hourly_salaried_code, hsc.segment3 position_code, frequency

Line 880: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc

876: p_local_unit hr_all_organization_units.organization_id%type)
877: is
878: select normal_hours,
879: hourly_salaried_code, hsc.segment3 position_code, frequency
880: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc
881: where paaf.assignment_id = p_assignment_id
882: and hsc.segment2 = to_char (p_local_unit)
883: and hsc.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
884: and p_effective_date between paaf.effective_start_date and paaf.effective_End_date;

Line 889: p_assignment_id per_all_assignments_f.assignment_id%type,

885:
886: rl_assignment_details csr_get_assignment_details%rowtype;
887:
888: cursor previous_hour_value (
889: p_assignment_id per_all_assignments_f.assignment_id%type,
890: p_effective_date date
891: ) is
892: select normal_hours , effective_start_date
893: from per_all_assignments_f

Line 893: from per_all_assignments_f

889: p_assignment_id per_all_assignments_f.assignment_id%type,
890: p_effective_date date
891: ) is
892: select normal_hours , effective_start_date
893: from per_all_assignments_f
894: where assignment_id = p_assignment_id
895: and effective_start_date < p_effective_date
896: order by effective_start_date desc ;
897:

Line 918: l_frequency per_all_assignments_f.frequency%type;

914: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
915: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
916: l_total_hours number := 0;
917: l_total_hours_all number := 0;
918: l_frequency per_all_assignments_f.frequency%type;
919: l_hour_effective_end_date date;
920: l_hour_value varchar2 (100);
921: l_hour_value1 varchar2 (100);
922: l_job_value varchar2 (100);

Line 1123: open csr_get_table_id ('PER_ALL_ASSIGNMENTS_F');

1119: fetch csr_get_table_id into l_table2;
1120: close csr_get_table_id;
1121: --
1122: --
1123: open csr_get_table_id ('PER_ALL_ASSIGNMENTS_F');
1124: fetch csr_get_table_id into l_table3;
1125: close csr_get_table_id;
1126: --
1127: --

Line 2692: p_assignment_id in per_all_assignments_f.assignment_id%type,

2688: hr_utility.raise_error;
2689: end writetoclob;
2690:
2691: function get_assignment_all_hours (
2692: p_assignment_id in per_all_assignments_f.assignment_id%type,
2693: p_person_id in per_all_people_f.person_id%type,
2694: p_effective_date in date,
2695: p_primary_hour_value number,
2696: p_local_unit number

Line 2700: p_assignment_id per_all_assignments_f.assignment_id%type,

2696: p_local_unit number
2697: )
2698: return number is
2699: cursor csr_hour_frequency (
2700: p_assignment_id per_all_assignments_f.assignment_id%type,
2701: p_effective_date date
2702: ) is
2703: select frequency
2704: from per_all_assignments_f

Line 2704: from per_all_assignments_f

2700: p_assignment_id per_all_assignments_f.assignment_id%type,
2701: p_effective_date date
2702: ) is
2703: select frequency
2704: from per_all_assignments_f
2705: where assignment_id = p_assignment_id
2706: and p_effective_date between effective_start_date
2707: and effective_end_date;
2708:

Line 2711: p_assignment_id per_all_assignments_f.assignment_id%type,

2707: and effective_end_date;
2708:
2709: cursor csr_all_assignments_hours (
2710: p_person_id per_all_people_f.person_id%type,
2711: p_assignment_id per_all_assignments_f.assignment_id%type,
2712: p_effective_date date,
2713: p_local_unit number
2714: ) is
2715: select normal_hours, frequency

Line 2716: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc

2712: p_effective_date date,
2713: p_local_unit number
2714: ) is
2715: select normal_hours, frequency
2716: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc
2717: where paaf.person_id = p_person_id
2718: and paaf.assignment_id <> p_assignment_id
2719: and paaf.normal_hours is not null
2720: and hsc.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id

Line 2726: l_frequency per_all_assignments_f.frequency%type;

2722: and hourly_salaried_code = 'S'
2723: and p_effective_date between paaf.effective_start_date
2724: and paaf.effective_end_date;
2725:
2726: l_frequency per_all_assignments_f.frequency%type;
2727: l_total_hours number := 0;
2728: l_total_hours_all number := 0;
2729: begin
2730: open csr_hour_frequency (p_assignment_id, p_effective_date);