APPS.PAY_NZ_SSCWT_RATE_ARCHIVE dependencies on PER_PEOPLE_F

Line 20: g_business_group_id per_people_f.business_group_id%TYPE;

16: g_package VARCHAR2(100);
17:
18: g_payroll_id pay_payrolls_f.payroll_id%TYPE;
19: g_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
20: g_business_group_id per_people_f.business_group_id%TYPE;
21: g_financial_year DATE;
22: g_processing_mode VARCHAR2(1);
23:
24: g_element_type_id pay_element_types_f.element_type_id%TYPE ;

Line 528: ' FROM per_people_f ppf' ||

524: -- sql string to SELECT a range of assignments eligible for archival.
525: --
526:
527: p_sql := ' SELECT distinct ppf.person_id' ||
528: ' FROM per_people_f ppf' ||
529: ',pay_payroll_actions ppa' ||
530: ' WHERE ppa.payroll_action_id = :payroll_action_id' ||
531: ' AND ppa.business_group_id = ppf.business_group_id' ||
532: ' ORDER BY ppf.person_id';

Line 592: FROM per_people_f person

588:
589: CURSOR csr_get_assignments
590: IS
591: SELECT DISTINCT assignment.assignment_id
592: FROM per_people_f person
593: ,per_assignments_f assignment
594: ,per_periods_of_service service
595: ,pay_element_types_f element
596: ,pay_element_links_f link

Line 942: l_employee_full_name per_people_f.full_name%TYPE;

938: l_sscwt_new_rate NUMBER;
939: l_sscwt_old_rate NUMBER;
940: l_periods NUMBER;
941: l_total_periods NUMBER;
942: l_employee_full_name per_people_f.full_name%TYPE;
943: l_assignment_number per_assignments_f.assignment_number%TYPE;
944: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
945: --
946: -- Cursor Declarations

Line 950: ,c_business_group_id per_people_f.business_group_id%TYPE)

946: -- Cursor Declarations
947: --
948: CURSOR csr_employees
949: (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE
950: ,c_business_group_id per_people_f.business_group_id%TYPE)
951: IS
952: SELECT person.full_name
953: ,assignment.assignment_number
954: ,assignment.assignment_id

Line 958: FROM per_people_f person,

954: ,assignment.assignment_id
955: ,periods_in_span(service.date_start, g_financial_year
956: , assignment.assignment_id) periods
957: ,period_types.number_per_fiscal_year total_periods
958: FROM per_people_f person,
959: per_assignments_f assignment,
960: per_periods_of_service service,
961: pay_payrolls_f payroll,
962: per_time_period_types period_types,