DBA Data[Home] [Help]

APPS.PAY_NZ_QES_PKG dependencies on PER_TIME_PERIODS

Line 7: p_time_period_id in per_time_periods.time_period_id%type,

3:
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,

Line 18: p_time_period_id in per_time_periods.time_period_id%type,

14:
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,

Line 31: p_time_period_id in per_time_periods.time_period_id%type,

27:
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)

Line 44: (p_regular_payment_date in per_time_periods.regular_payment_date%type,

40: p_balance_dimension in pay_balance_dimensions.database_item_suffix%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