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 957: l_employee_full_name per_people_f.full_name%TYPE;

953: l_sscwt_new_rate NUMBER;
954: l_sscwt_old_rate NUMBER;
955: l_periods NUMBER;
956: l_total_periods NUMBER;
957: l_employee_full_name per_people_f.full_name%TYPE;
958: l_assignment_number per_assignments_f.assignment_number%TYPE;
959: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
960: --
961: -- Cursor Declarations

Line 965: ,c_business_group_id per_people_f.business_group_id%TYPE)

961: -- Cursor Declarations
962: --
963: CURSOR csr_employees
964: (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE
965: ,c_business_group_id per_people_f.business_group_id%TYPE)
966: IS
967: SELECT person.full_name
968: ,assignment.assignment_number
969: ,assignment.assignment_id

Line 973: FROM per_people_f person,

969: ,assignment.assignment_id
970: ,periods_in_span(service.date_start, g_financial_year
971: , assignment.assignment_id) periods
972: ,period_types.number_per_fiscal_year total_periods
973: FROM per_people_f person,
974: per_assignments_f assignment,
975: per_periods_of_service service,
976: pay_payrolls_f payroll,
977: per_time_period_types period_types,