APPS.PAY_NZ_QES_PKG dependencies on PER_ALL_PEOPLE_F

Line 9: p_emp_cat_code in per_all_people_f.per_information7%type,

5: (p_organization_id in hr_organization_units.organization_id%type,
6: p_payroll_id in pay_all_payrolls_f.payroll_id%type,
7: p_time_period_id in per_time_periods.time_period_id%type,
8: p_location_id in per_all_assignments_f.location_id%type,
9: p_emp_cat_code in per_all_people_f.per_information7%type,
10: p_work_time_code in per_all_people_f.per_information8%type,
11: p_sex in per_all_people_f.sex%type,
12: p_survey_date in date)
13: return number;

Line 10: p_work_time_code in per_all_people_f.per_information8%type,

6: p_payroll_id in pay_all_payrolls_f.payroll_id%type,
7: p_time_period_id in per_time_periods.time_period_id%type,
8: p_location_id in per_all_assignments_f.location_id%type,
9: p_emp_cat_code in per_all_people_f.per_information7%type,
10: p_work_time_code in per_all_people_f.per_information8%type,
11: p_sex in per_all_people_f.sex%type,
12: p_survey_date in date)
13: return number;
14:

Line 11: p_sex in per_all_people_f.sex%type,

7: p_time_period_id in per_time_periods.time_period_id%type,
8: p_location_id in per_all_assignments_f.location_id%type,
9: p_emp_cat_code in per_all_people_f.per_information7%type,
10: p_work_time_code in per_all_people_f.per_information8%type,
11: p_sex in per_all_people_f.sex%type,
12: p_survey_date in date)
13: return number;
14:
15: function count_employees_using_balance

Line 20: p_emp_cat_code in per_all_people_f.per_information7%type,

16: (p_organization_id in hr_organization_units.organization_id%type,
17: p_payroll_id in pay_all_payrolls_f.payroll_id%type,
18: p_time_period_id in per_time_periods.time_period_id%type,
19: p_location_id in per_all_assignments_f.location_id%type,
20: p_emp_cat_code in per_all_people_f.per_information7%type,
21: p_work_time_code in per_all_people_f.per_information8%type,
22: p_sex in per_all_people_f.sex%type,
23: p_week_hours in per_all_assignments_f.normal_hours%type,
24: p_week_frequency in per_all_assignments_f.frequency%type,

Line 21: p_work_time_code in per_all_people_f.per_information8%type,

17: p_payroll_id in pay_all_payrolls_f.payroll_id%type,
18: p_time_period_id in per_time_periods.time_period_id%type,
19: p_location_id in per_all_assignments_f.location_id%type,
20: p_emp_cat_code in per_all_people_f.per_information7%type,
21: p_work_time_code in per_all_people_f.per_information8%type,
22: p_sex in per_all_people_f.sex%type,
23: p_week_hours in per_all_assignments_f.normal_hours%type,
24: p_week_frequency in per_all_assignments_f.frequency%type,
25: p_survey_date in date)

Line 22: p_sex in per_all_people_f.sex%type,

18: p_time_period_id in per_time_periods.time_period_id%type,
19: p_location_id in per_all_assignments_f.location_id%type,
20: p_emp_cat_code in per_all_people_f.per_information7%type,
21: p_work_time_code in per_all_people_f.per_information8%type,
22: p_sex in per_all_people_f.sex%type,
23: p_week_hours in per_all_assignments_f.normal_hours%type,
24: p_week_frequency in per_all_assignments_f.frequency%type,
25: p_survey_date in date)
26: return number;

Line 34: p_sex in per_all_people_f.sex%type,

30: p_payroll_id in pay_all_payrolls_f.payroll_id%type,
31: p_time_period_id in per_time_periods.time_period_id%type,
32: p_location_id in per_all_assignments_f.location_id%type,
33: p_defined_balance_id in pay_defined_balances.defined_balance_id%type,
34: p_sex in per_all_people_f.sex%type,
35: p_survey_date in date)
36: return number;
37:
38: function id_for_defined_balance