APPS.PAY_NO_EERR_CONTINUOUS dependencies on PER_ALL_PEOPLE_F

Line 366: from per_all_people_f papf,

362: select papf.person_id person_id, paaf.assignment_id,
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

Line 439: from per_all_people_f papf,

435: select papf.person_id person_id, paaf.assignment_id,
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

Line 526: p_person_id per_all_people_f.person_id%type

522: --
523: /* Cursor to get the Absence Start Date and End Date when employee is on
524: absence for more than 14 days */
525: cursor csr_absence_start_days (
526: p_person_id per_all_people_f.person_id%type
527: ) is
528: select paa.date_start, paa.date_end
529: from per_absence_attendances paa, per_absence_attendance_types paat
530: where paat.absence_attendance_type_id =

Line 584: p_person_id per_all_people_f.person_id%type

580: --145091849 End 3
581:
582:
583: cursor csr_absence_end_days (
584: p_person_id per_all_people_f.person_id%type
585: ,p_prev_last_date date
586: ) is
587: select paa.date_start, paa.date_end
588: from per_absence_attendances paa, per_absence_attendance_types paat

Line 873: (p_person_id per_all_people_f.person_id%type,

869: -- order by effective_start_date desc ;
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

Line 972: l_person_id per_all_people_f.person_id%type;

968: l_legal_employer_id hr_organization_units.organization_id%type;
969: l_effective_date date;
970: l_emp_start_date date;
971: l_emp_end_date date;
972: l_person_id per_all_people_f.person_id%type;
973: l_event_group_id pay_event_groups.event_group_id%type;
974: l_detailed_output l_detailed_output_table_type; -- pay_interpreter_pkg.t_detailed_output_table_type;
975: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
976: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;

Line 1039: l_national_identifier per_all_people_f.national_identifier%type; /* 5526181 */

1035: l_prev_hour_value_primary number;
1036: l_prev_hour_eff_date date;
1037: l_lu_change_flag char (1); /* 5519990 */
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);

Line 3026: p_person_id in per_all_people_f.person_id%type,

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
3030: )

Line 3043: p_person_id per_all_people_f.person_id%type,

3039: and p_effective_date between effective_start_date
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

Line 3599: l_return_value per_all_people_f.national_identifier%type;

3595: function check_national_identifier (
3596: p_national_identifier varchar2
3597: )
3598: return varchar2 is
3599: l_return_value per_all_people_f.national_identifier%type;
3600: l_check_value number;
3601: d1 number;
3602: d2 number;
3603: m1 number;