APPS.PAY_CA_YEPP_MISS_ASSIGN_PKG dependencies on PER_ALL_PEOPLE_F

Line 342: per_all_people_f ppf

338: SELECT DISTINCT asg.assignment_id ass_id
339: FROM per_all_assignments_f asg,
340: pay_assignment_actions paa,
341: pay_payroll_actions ppa,
342: per_all_people_f ppf
343: WHERE ppa.effective_date BETWEEN cp_effective_date
344: AND add_months(cp_effective_date, 12) - 1
345: AND ppa.action_type in ('R','Q','V','B','I')
346: AND ppa.payroll_action_id = paa.payroll_action_id

Line 514: FROM per_all_people_f

510: WHERE assignment_id = c_assign_id;
511:
512: CURSOR c_employee_details(c_person_id number) IS
513: SELECT full_name,national_identifier
514: FROM per_all_people_f
515: WHERE person_id = c_person_id;
516:
517: CURSOR c_assignment_set_id IS
518: SELECT hr_assignment_sets_s.nextval

Line 547: lv_person_id per_all_people_f.person_id%type;

543: /* Local variables */
544:
545: lv_assn_id per_all_assignments_f.assignment_id%type;
546: lv_result_value number;
547: lv_person_id per_all_people_f.person_id%type;
548: lv_gre_name hr_all_organization_units_tl.name%type;
549: lv_pre_name hr_all_organization_units_tl.name%type;
550: lv_emp_name per_all_people_f.full_name%type;
551: lv_emp_no per_all_people_f.employee_number%type;

Line 550: lv_emp_name per_all_people_f.full_name%type;

546: lv_result_value number;
547: lv_person_id per_all_people_f.person_id%type;
548: lv_gre_name hr_all_organization_units_tl.name%type;
549: lv_pre_name hr_all_organization_units_tl.name%type;
550: lv_emp_name per_all_people_f.full_name%type;
551: lv_emp_no per_all_people_f.employee_number%type;
552: lv_emp_sin per_all_people_f.national_identifier%type;
553: lv_data_row varchar2(4000);
554: row_id varchar2(100);

Line 551: lv_emp_no per_all_people_f.employee_number%type;

547: lv_person_id per_all_people_f.person_id%type;
548: lv_gre_name hr_all_organization_units_tl.name%type;
549: lv_pre_name hr_all_organization_units_tl.name%type;
550: lv_emp_name per_all_people_f.full_name%type;
551: lv_emp_no per_all_people_f.employee_number%type;
552: lv_emp_sin per_all_people_f.national_identifier%type;
553: lv_data_row varchar2(4000);
554: row_id varchar2(100);
555: lv_miss_assignments number;

Line 552: lv_emp_sin per_all_people_f.national_identifier%type;

548: lv_gre_name hr_all_organization_units_tl.name%type;
549: lv_pre_name hr_all_organization_units_tl.name%type;
550: lv_emp_name per_all_people_f.full_name%type;
551: lv_emp_no per_all_people_f.employee_number%type;
552: lv_emp_sin per_all_people_f.national_identifier%type;
553: lv_data_row varchar2(4000);
554: row_id varchar2(100);
555: lv_miss_assignments number;
556: lv_effective_date date;