APPS.PAY_NZ_QES_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 8: p_location_id in per_all_assignments_f.location_id%type,

4: function count_employees
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)

Line 19: p_location_id in per_all_assignments_f.location_id%type,

15: function count_employees_using_balance
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,

Line 23: p_week_hours in per_all_assignments_f.normal_hours%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;
27:

Line 24: p_week_frequency in per_all_assignments_f.frequency%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;
27:
28: function sum_balances

Line 32: p_location_id in per_all_assignments_f.location_id%type,

28: function sum_balances
29: (p_organization_id in hr_organization_units.organization_id%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;

Line 45: p_assignment_id in per_all_assignments_f.assignment_id%type)

41: return pay_balance_types.balance_type_id%type;
42:
43: function ordinary_time_payout
44: (p_regular_payment_date in per_time_periods.regular_payment_date%type,
45: p_assignment_id in per_all_assignments_f.assignment_id%type)
46: return number;
47:
48: function hours_worked
49: (p_assignment_id in per_all_assignments_f.assignment_id%type,

Line 49: (p_assignment_id in per_all_assignments_f.assignment_id%type,

45: p_assignment_id in per_all_assignments_f.assignment_id%type)
46: return number;
47:
48: function hours_worked
49: (p_assignment_id in per_all_assignments_f.assignment_id%type,
50: p_payroll_frequency in pay_all_payrolls_f.period_type%type)
51: return number;
52:
53: function convert_hours

Line 54: (p_assignment_hours in per_all_assignments_f.normal_hours%type,

50: p_payroll_frequency in pay_all_payrolls_f.period_type%type)
51: return number;
52:
53: function convert_hours
54: (p_assignment_hours in per_all_assignments_f.normal_hours%type,
55: p_payroll_frequency in pay_all_payrolls_f.period_type%type,
56: p_assignment_frequency in per_all_assignments_f.frequency%type)
57: return number;
58:

Line 56: p_assignment_frequency in per_all_assignments_f.frequency%type)

52:
53: function convert_hours
54: (p_assignment_hours in per_all_assignments_f.normal_hours%type,
55: p_payroll_frequency in pay_all_payrolls_f.period_type%type,
56: p_assignment_frequency in per_all_assignments_f.frequency%type)
57: return number;
58:
59: function no_periods_per_year
60: (p_period_type in per_time_period_types.period_type%type)