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

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

Line 351: from per_all_assignments_f asg,

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

Line 376: per_all_assignments_f paaf,

372: papf.effective_start_date, paaf.effective_end_date,
373: national_identifier, full_name, employee_number, normal_hours,
374: hourly_salaried_code, hsc.segment3 position_code, frequency
375: from per_all_people_f papf,
376: per_all_assignments_f paaf,
377: hr_soft_coding_keyflex hsc,
378: per_assignment_status_types past
379: where paaf.person_id = papf.person_id
380: and papf.person_id between p_start_person and p_end_person

Line 388: from per_all_assignments_f asg,

384: and hsc.segment2 = to_char (p_local_unit)
385: and paaf.assignment_status_type_id =
386: past.assignment_status_type_id
387: and paaf.assignment_id = (select min (assignment_id)
388: from per_all_assignments_f asg,
389: hr_soft_coding_keyflex hsck
390: where person_id = papf.person_id
391: and hsck.soft_coding_keyflex_id =
392: asg.soft_coding_keyflex_id

Line 418: p_assignment_id per_all_assignments_f.assignment_id%type

414: --
415: --
416: /* Cursor to get the Start Date of the Assignment */
417: cursor csr_start_date (
418: p_assignment_id per_all_assignments_f.assignment_id%type
419: ) is
420: select min (effective_start_date)
421: from per_all_assignments_f paaf, per_assignment_status_types past
422: where assignment_id = p_assignment_id

Line 421: from per_all_assignments_f paaf, per_assignment_status_types past

417: cursor csr_start_date (
418: p_assignment_id per_all_assignments_f.assignment_id%type
419: ) is
420: select min (effective_start_date)
421: from per_all_assignments_f paaf, per_assignment_status_types past
422: where assignment_id = p_assignment_id
423: and paaf.assignment_status_type_id =
424: past.assignment_status_type_id
425: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');

Line 513: from hr_soft_coding_keyflex hsc, per_all_assignments_f paaf

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

Line 686: p_assignment_id per_all_assignments_f.assignment_id%type,

682:
683: /* Cursor to get all the assignment for the person except the given assignment*/
684: cursor csr_get_all_assignments
685: (p_person_id per_all_people_f.person_id%type,
686: p_assignment_id per_all_assignments_f.assignment_id%type,
687: p_local_unit hr_all_organization_units.organization_id%type)
688: is
689: select assignment_id
690: from per_all_assignments_f paaf ,hr_soft_coding_keyflex hsck

Line 690: from per_all_assignments_f paaf ,hr_soft_coding_keyflex hsck

686: p_assignment_id per_all_assignments_f.assignment_id%type,
687: p_local_unit hr_all_organization_units.organization_id%type)
688: is
689: select assignment_id
690: from per_all_assignments_f paaf ,hr_soft_coding_keyflex hsck
691: where person_id = p_person_id
692: and assignment_id <> p_assignment_id
693: and hsck.segment2 = to_char (p_local_unit)
694: and hsck.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id;

Line 699: p_assignment_id per_all_assignments_f.assignment_id%type,

695:
696:
697: Cursor csr_get_assignment_details
698: (p_effective_date date,
699: p_assignment_id per_all_assignments_f.assignment_id%type,
700: p_local_unit hr_all_organization_units.organization_id%type)
701: is
702: select normal_hours,
703: hourly_salaried_code, hsc.segment3 position_code, frequency

Line 704: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc

700: p_local_unit hr_all_organization_units.organization_id%type)
701: is
702: select normal_hours,
703: hourly_salaried_code, hsc.segment3 position_code, frequency
704: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc
705: where paaf.assignment_id = p_assignment_id
706: and hsc.segment2 = to_char (p_local_unit)
707: and hsc.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
708: and p_effective_date between paaf.effective_start_date and paaf.effective_End_date;

Line 713: p_assignment_id per_all_assignments_f.assignment_id%type,

709:
710: rl_assignment_details csr_get_assignment_details%rowtype;
711:
712: cursor previous_hour_value (
713: p_assignment_id per_all_assignments_f.assignment_id%type,
714: p_effective_date date
715: ) is
716: select normal_hours , effective_start_date
717: from per_all_assignments_f

Line 717: from per_all_assignments_f

713: p_assignment_id per_all_assignments_f.assignment_id%type,
714: p_effective_date date
715: ) is
716: select normal_hours , effective_start_date
717: from per_all_assignments_f
718: where assignment_id = p_assignment_id
719: and effective_start_date < p_effective_date
720: order by effective_start_date desc ;
721:

Line 742: l_frequency per_all_assignments_f.frequency%type;

738: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
739: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
740: l_total_hours number := 0;
741: l_total_hours_all number := 0;
742: l_frequency per_all_assignments_f.frequency%type;
743: l_hour_effective_end_date date;
744: l_hour_value varchar2 (100);
745: l_hour_value1 varchar2 (100);
746: l_job_value varchar2 (100);

Line 946: open csr_get_table_id ('PER_ALL_ASSIGNMENTS_F');

942: fetch csr_get_table_id into l_table2;
943: close csr_get_table_id;
944: --
945: --
946: open csr_get_table_id ('PER_ALL_ASSIGNMENTS_F');
947: fetch csr_get_table_id into l_table3;
948: close csr_get_table_id;
949: --
950: --

Line 2514: p_assignment_id in per_all_assignments_f.assignment_id%type,

2510: hr_utility.raise_error;
2511: end writetoclob;
2512:
2513: function get_assignment_all_hours (
2514: p_assignment_id in per_all_assignments_f.assignment_id%type,
2515: p_person_id in per_all_people_f.person_id%type,
2516: p_effective_date in date,
2517: p_primary_hour_value number,
2518: p_local_unit number

Line 2522: p_assignment_id per_all_assignments_f.assignment_id%type,

2518: p_local_unit number
2519: )
2520: return number is
2521: cursor csr_hour_frequency (
2522: p_assignment_id per_all_assignments_f.assignment_id%type,
2523: p_effective_date date
2524: ) is
2525: select frequency
2526: from per_all_assignments_f

Line 2526: from per_all_assignments_f

2522: p_assignment_id per_all_assignments_f.assignment_id%type,
2523: p_effective_date date
2524: ) is
2525: select frequency
2526: from per_all_assignments_f
2527: where assignment_id = p_assignment_id
2528: and p_effective_date between effective_start_date
2529: and effective_end_date;
2530:

Line 2533: p_assignment_id per_all_assignments_f.assignment_id%type,

2529: and effective_end_date;
2530:
2531: cursor csr_all_assignments_hours (
2532: p_person_id per_all_people_f.person_id%type,
2533: p_assignment_id per_all_assignments_f.assignment_id%type,
2534: p_effective_date date,
2535: p_local_unit number
2536: ) is
2537: select normal_hours, frequency

Line 2538: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc

2534: p_effective_date date,
2535: p_local_unit number
2536: ) is
2537: select normal_hours, frequency
2538: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc
2539: where paaf.person_id = p_person_id
2540: and paaf.assignment_id <> p_assignment_id
2541: and paaf.normal_hours is not null
2542: and hsc.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id

Line 2548: l_frequency per_all_assignments_f.frequency%type;

2544: and hourly_salaried_code = 'S'
2545: and p_effective_date between paaf.effective_start_date
2546: and paaf.effective_end_date;
2547:
2548: l_frequency per_all_assignments_f.frequency%type;
2549: l_total_hours number := 0;
2550: l_total_hours_all number := 0;
2551: begin
2552: open csr_hour_frequency (p_assignment_id, p_effective_date);