APPS.PAY_NZ_QES_PKG dependencies on PAY_DEFINED_BALANCES

Line 4: g_ordinary_time_hours_id pay_defined_balances.defined_balance_id%type;

1: package body pay_nz_qes_pkg as
2: /* $Header: pynzqes.pkb 120.0 2005/05/29 02:12:27 appldev noship $ */
3: ------------------------------------------------------------------------
4: g_ordinary_time_hours_id pay_defined_balances.defined_balance_id%type;
5: g_ordinary_time_payout_id pay_defined_balances.defined_balance_id%type;
6: ------------------------------------------------------------------------
7: -- Counts the number of people per group.
8: ------------------------------------------------------------------------

Line 5: g_ordinary_time_payout_id pay_defined_balances.defined_balance_id%type;

1: package body pay_nz_qes_pkg as
2: /* $Header: pynzqes.pkb 120.0 2005/05/29 02:12:27 appldev noship $ */
3: ------------------------------------------------------------------------
4: g_ordinary_time_hours_id pay_defined_balances.defined_balance_id%type;
5: g_ordinary_time_payout_id pay_defined_balances.defined_balance_id%type;
6: ------------------------------------------------------------------------
7: -- Counts the number of people per group.
8: ------------------------------------------------------------------------
9: function count_employees

Line 87: v_defined_balance_id pay_defined_balances.defined_balance_id%type;

83: p_week_frequency in per_all_assignments_f.frequency%type,
84: p_survey_date in date)
85: return number is
86:
87: v_defined_balance_id pay_defined_balances.defined_balance_id%type;
88: v_emp_count number(20) := 0;
89: v_emp_balance number(20,5) := 0;
90: v_total_balance number(20,5) := 0;
91: v_full_time_count number(20) := 0;

Line 100: c_defined_balance_id pay_defined_balances.defined_balance_id%type,

96: (c_organization_id hr_organization_units.organization_id%type,
97: c_payroll_id pay_all_payrolls_f.payroll_id%type,
98: c_time_period_id per_time_periods.time_period_id%type,
99: c_location_id per_all_assignments_f.location_id%type,
100: c_defined_balance_id pay_defined_balances.defined_balance_id%type,
101: c_sex per_all_people_f.sex%type,
102: c_survey_date date) is
103:
104: select paa.assignment_id,

Line 200: p_defined_balance_id in pay_defined_balances.defined_balance_id%type,

196: (p_organization_id in hr_organization_units.organization_id%type,
197: p_payroll_id in pay_all_payrolls_f.payroll_id%type,
198: p_time_period_id in per_time_periods.time_period_id%type,
199: p_location_id in per_all_assignments_f.location_id%type,
200: p_defined_balance_id in pay_defined_balances.defined_balance_id%type,
201: p_sex in per_all_people_f.sex%type,
202: p_survey_date in date)
203: return number is
204:

Line 213: c_defined_balance_id pay_defined_balances.defined_balance_id%type,

209: (c_organization_id hr_organization_units.organization_id%type,
210: c_payroll_id pay_all_payrolls_f.payroll_id%type,
211: c_time_period_id per_time_periods.time_period_id%type,
212: c_location_id per_all_assignments_f.location_id%type,
213: c_defined_balance_id pay_defined_balances.defined_balance_id%type,
214: c_sex per_all_people_f.sex%type,
215: c_survey_date date) is
216:
217: select paa.assignment_id,

Line 301: pay_defined_balances pdb,

297: (c_balance_name pay_balance_types.balance_name%type,
298: c_balance_dimension pay_balance_dimensions.database_item_suffix%type) is
299: select pdb.defined_balance_id
300: from pay_balance_dimensions pbd,
301: pay_defined_balances pdb,
302: pay_balance_types pbt
303: where pbt.balance_type_id = pdb.balance_type_id
304: and pbd.balance_dimension_id = pdb.balance_dimension_id
305: and pbt.balance_name = c_balance_name