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 440: per_all_assignments_f paaf,

436: papf.effective_start_date, paaf.effective_end_date, papf.effective_end_date emp_end_date,
437: national_identifier, full_name, employee_number, normal_hours,
438: hourly_salaried_code, hsc.segment3 position_code, frequency
439: from per_all_people_f papf,
440: per_all_assignments_f paaf,
441: hr_soft_coding_keyflex hsc,
442: per_assignment_status_types past
443: where paaf.person_id = papf.person_id
444: and papf.person_id between p_start_person and p_end_person

Line 452: from per_all_assignments_f asg,hr_soft_coding_keyflex hsck

448: and hsc.segment2 = to_char (p_local_unit)
449: and paaf.assignment_status_type_id =
450: past.assignment_status_type_id
451: and paaf.assignment_id = (select min(assignment_id)
452: from per_all_assignments_f asg,hr_soft_coding_keyflex hsck
453: where person_id = papf.person_id
454: and hsck.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
455: and hsck.segment2 = to_char (p_local_unit))
456: --and past.PER_SYSTEM_STATUS = 'TERM_ASSIGN'

Line 512: p_assignment_id per_all_assignments_f.assignment_id%type

508: --
509: --
510: /* Cursor to get the Start Date of the Assignment */
511: cursor csr_start_date (
512: p_assignment_id per_all_assignments_f.assignment_id%type
513: ) is
514: select min (effective_start_date)
515: from per_all_assignments_f paaf, per_assignment_status_types past
516: where assignment_id = p_assignment_id

Line 515: from per_all_assignments_f paaf, per_assignment_status_types past

511: cursor csr_start_date (
512: p_assignment_id per_all_assignments_f.assignment_id%type
513: ) is
514: select min (effective_start_date)
515: from per_all_assignments_f paaf, per_assignment_status_types past
516: where assignment_id = p_assignment_id
517: and paaf.assignment_status_type_id =
518: past.assignment_status_type_id
519: and past.PER_SYSTEM_STATUS in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');

Line 677: from hr_soft_coding_keyflex hsc, per_all_assignments_f paaf

673: p_effective_date date,
674: p_job_id number
675: ) is
676: select segment3
677: from hr_soft_coding_keyflex hsc, per_all_assignments_f paaf
678: where paaf.job_id = p_job_id
679: and assignment_id = p_assignment_id
680: and p_effective_date between paaf.effective_start_date
681: and paaf.effective_end_date

Line 861: p_assignment_id per_all_assignments_f.assignment_id%type,

857: and screen_entry_value is not null;
858:
859: /* cursor to get the previous changed hour value */
860: cursor previous_hour_value (
861: p_assignment_id per_all_assignments_f.assignment_id%type,
862: p_effective_date date
863: ) is
864: select normal_hours , effective_start_date
865: from per_all_assignments_f

Line 865: from per_all_assignments_f

861: p_assignment_id per_all_assignments_f.assignment_id%type,
862: p_effective_date date
863: ) is
864: select normal_hours , effective_start_date
865: from per_all_assignments_f
866: where assignment_id = p_assignment_id
867: and p_effective_date - 1 between effective_start_date and effective_end_date;
868: -- and effective_start_date < p_effective_date
869: -- order by effective_start_date desc ;

Line 874: p_assignment_id per_all_assignments_f.assignment_id%type,

870:
871: /* Cursor to get all the assignment for the person except the given assignment*/
872: cursor csr_get_all_assignments
873: (p_person_id per_all_people_f.person_id%type,
874: p_assignment_id per_all_assignments_f.assignment_id%type,
875: p_local_unit hr_all_organization_units.organization_id%type)
876: is
877: select assignment_id
878: from per_all_assignments_f paaf ,hr_soft_coding_keyflex hsck

Line 878: from per_all_assignments_f paaf ,hr_soft_coding_keyflex hsck

874: p_assignment_id per_all_assignments_f.assignment_id%type,
875: p_local_unit hr_all_organization_units.organization_id%type)
876: is
877: select assignment_id
878: from per_all_assignments_f paaf ,hr_soft_coding_keyflex hsck
879: where person_id = p_person_id
880: and assignment_id <> p_assignment_id
881: and hsck.segment2 = to_char (p_local_unit)
882: and hsck.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id;

Line 886: p_assignment_id per_all_assignments_f.assignment_id%type,

882: and hsck.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id;
883:
884: /*Cursor csr_get_assignment_details
885: (p_effective_date date,
886: p_assignment_id per_all_assignments_f.assignment_id%type,
887: p_local_unit hr_all_organization_units.organization_id%type)
888: is
889: select normal_hours,
890: hourly_salaried_code, hsc.segment3 position_code, frequency

Line 891: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc

887: p_local_unit hr_all_organization_units.organization_id%type)
888: is
889: select normal_hours,
890: hourly_salaried_code, hsc.segment3 position_code, frequency
891: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc
892: where paaf.assignment_id = p_assignment_id
893: and hsc.segment2 = to_char (p_local_unit)
894: and hsc.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
895: and p_effective_date between paaf.effective_start_date and paaf.effective_End_date;*/

Line 899: p_assignment_id per_all_assignments_f.assignment_id%type)

895: and p_effective_date between paaf.effective_start_date and paaf.effective_End_date;*/
896:
897: Cursor csr_get_assignment_details
898: (p_effective_date date,
899: p_assignment_id per_all_assignments_f.assignment_id%type)
900: is
901: select normal_hours,
902: hourly_salaried_code, hsc.segment3 position_code, frequency
903: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc

Line 903: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc

899: p_assignment_id per_all_assignments_f.assignment_id%type)
900: is
901: select normal_hours,
902: hourly_salaried_code, hsc.segment3 position_code, frequency
903: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc
904: where paaf.assignment_id = p_assignment_id
905: --and hsc.segment2 = to_char (p_local_unit)
906: and hsc.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
907: and p_effective_date between paaf.effective_start_date and paaf.effective_End_date;

Line 912: p_assignment_id per_all_assignments_f.assignment_id%type,

908:
909: rl_assignment_details csr_get_assignment_details%rowtype;
910:
911: cursor curr_hours_frequency (
912: p_assignment_id per_all_assignments_f.assignment_id%type,
913: p_effective_date date ) is
914: select normal_hours, frequency
915: from per_all_assignments_f
916: where assignment_id = p_assignment_id

Line 915: from per_all_assignments_f

911: cursor curr_hours_frequency (
912: p_assignment_id per_all_assignments_f.assignment_id%type,
913: p_effective_date date ) is
914: select normal_hours, frequency
915: from per_all_assignments_f
916: where assignment_id = p_assignment_id
917: and p_effective_date between effective_start_date and effective_end_date;
918:
919: cursor curr_lu_org_number (

Line 920: p_assignment_id per_all_assignments_f.assignment_id%type,

916: where assignment_id = p_assignment_id
917: and p_effective_date between effective_start_date and effective_end_date;
918:
919: cursor curr_lu_org_number (
920: p_assignment_id per_all_assignments_f.assignment_id%type,
921: p_effective_date date ) is
922: select org_information1
923: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc,hr_organization_information hoi
924: where paaf.assignment_id = p_assignment_id

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

919: cursor curr_lu_org_number (
920: p_assignment_id per_all_assignments_f.assignment_id%type,
921: p_effective_date date ) is
922: select org_information1
923: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc,hr_organization_information hoi
924: where paaf.assignment_id = p_assignment_id
925: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date
926: and hsc.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
927: and hoi.org_information_context = 'NO_LOCAL_UNIT_DETAILS'

Line 931: p_assignment_id per_all_assignments_f.assignment_id%type,

927: and hoi.org_information_context = 'NO_LOCAL_UNIT_DETAILS'
928: and hoi.organization_id = hsc.segment2;
929:
930: cursor curr_position_code (
931: p_assignment_id per_all_assignments_f.assignment_id%type,
932: p_effective_date date ) is
933: select segment3
934: from hr_soft_coding_keyflex hsc, per_all_assignments_f paaf
935: where paaf.assignment_id = p_assignment_id

Line 934: from hr_soft_coding_keyflex hsc, per_all_assignments_f paaf

930: cursor curr_position_code (
931: p_assignment_id per_all_assignments_f.assignment_id%type,
932: p_effective_date date ) is
933: select segment3
934: from hr_soft_coding_keyflex hsc, per_all_assignments_f paaf
935: where paaf.assignment_id = p_assignment_id
936: and p_effective_date between paaf.effective_start_date
937: and paaf.effective_end_date
938: and paaf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id;

Line 981: l_frequency per_all_assignments_f.frequency%type;

977: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
978: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
979: l_total_hours number := 0;
980: l_total_hours_all number := 0;
981: l_frequency per_all_assignments_f.frequency%type;
982: l_hour_effective_end_date date;
983: l_hour_value varchar2 (100);
984: l_hour_value1 varchar2 (100);
985: l_job_value varchar2 (100);

Line 1042: l_curr_frequency per_all_assignments_f.frequency%type;

1038: l_local_unit_org_no hr_organization_information.org_information1%type; /* 5519990 */
1039: l_national_identifier per_all_people_f.national_identifier%type; /* 5526181 */
1040: l_old_date date;
1041: l_curr_hours number;
1042: l_curr_frequency per_all_assignments_f.frequency%type;
1043: l_eff_end_date_need char (1);
1044: l_curr_position varchar2 (100);
1045: /* Work schedule variables 5525977 */
1046: l_days_or_hours Varchar2(10) := 'D';

Line 1184: open csr_get_table_id ('PER_ALL_ASSIGNMENTS_F');

1180: open csr_get_table_id ('PAY_ELEMENT_ENTRY_VALUES_F');
1181: fetch csr_get_table_id into l_table2;
1182: close csr_get_table_id;
1183: --
1184: open csr_get_table_id ('PER_ALL_ASSIGNMENTS_F');
1185: fetch csr_get_table_id into l_table3;
1186: close csr_get_table_id;
1187: --
1188: open csr_event_group_details (

Line 3025: p_assignment_id in per_all_assignments_f.assignment_id%type,

3021: return p_total_hours;
3022: end;
3023:
3024: function get_assignment_all_hours (
3025: p_assignment_id in per_all_assignments_f.assignment_id%type,
3026: p_person_id in per_all_people_f.person_id%type,
3027: p_effective_date in date,
3028: p_primary_hour_value number,
3029: p_local_unit number

Line 3033: p_assignment_id per_all_assignments_f.assignment_id%type,

3029: p_local_unit number
3030: )
3031: return number is
3032: cursor csr_hour_frequency (
3033: p_assignment_id per_all_assignments_f.assignment_id%type,
3034: p_effective_date date
3035: ) is
3036: select frequency
3037: from per_all_assignments_f

Line 3037: from per_all_assignments_f

3033: p_assignment_id per_all_assignments_f.assignment_id%type,
3034: p_effective_date date
3035: ) is
3036: select frequency
3037: from per_all_assignments_f
3038: where assignment_id = p_assignment_id
3039: and p_effective_date between effective_start_date
3040: and effective_end_date;
3041:

Line 3044: p_assignment_id per_all_assignments_f.assignment_id%type,

3040: and effective_end_date;
3041:
3042: cursor csr_all_assignments_hours (
3043: p_person_id per_all_people_f.person_id%type,
3044: p_assignment_id per_all_assignments_f.assignment_id%type,
3045: p_effective_date date,
3046: p_local_unit number
3047: ) is
3048: select normal_hours, frequency

Line 3049: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc

3045: p_effective_date date,
3046: p_local_unit number
3047: ) is
3048: select normal_hours, frequency
3049: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc
3050: where paaf.person_id = p_person_id
3051: and paaf.assignment_id <> p_assignment_id
3052: and paaf.normal_hours is not null
3053: and hsc.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id

Line 3058: l_frequency per_all_assignments_f.frequency%type;

3054: and hsc.segment2 = to_char (p_local_unit)
3055: and hourly_salaried_code = 'S'
3056: and p_effective_date between paaf.effective_start_date
3057: and paaf.effective_end_date;
3058: l_frequency per_all_assignments_f.frequency%type;
3059: l_total_hours number := 0;
3060: l_total_hours_all number := 0;
3061: begin
3062: open csr_hour_frequency (p_assignment_id, p_effective_date);