APPS.PAY_NZ_QES_PKG dependencies on PER_ALL_PEOPLE_F

Line 14: p_emp_cat_code in per_all_people_f.per_information7%type,

10: (p_organization_id in hr_organization_units.organization_id%type,
11: p_payroll_id in pay_all_payrolls_f.payroll_id%type,
12: p_time_period_id in per_time_periods.time_period_id%type,
13: p_location_id in per_all_assignments_f.location_id%type,
14: p_emp_cat_code in per_all_people_f.per_information7%type,
15: p_work_time_code in per_all_people_f.per_information8%type,
16: p_sex in per_all_people_f.sex%type,
17: p_survey_date in date)
18: return number is

Line 15: p_work_time_code in per_all_people_f.per_information8%type,

11: p_payroll_id in pay_all_payrolls_f.payroll_id%type,
12: p_time_period_id in per_time_periods.time_period_id%type,
13: p_location_id in per_all_assignments_f.location_id%type,
14: p_emp_cat_code in per_all_people_f.per_information7%type,
15: p_work_time_code in per_all_people_f.per_information8%type,
16: p_sex in per_all_people_f.sex%type,
17: p_survey_date in date)
18: return number is
19:

Line 16: p_sex in per_all_people_f.sex%type,

12: p_time_period_id in per_time_periods.time_period_id%type,
13: p_location_id in per_all_assignments_f.location_id%type,
14: p_emp_cat_code in per_all_people_f.per_information7%type,
15: p_work_time_code in per_all_people_f.per_information8%type,
16: p_sex in per_all_people_f.sex%type,
17: p_survey_date in date)
18: return number is
19:
20: v_emp_count number(20) := 0;

Line 27: c_emp_cat_code per_all_people_f.per_information7%type,

23: (c_organization_id hr_organization_units.organization_id%type,
24: c_payroll_id pay_all_payrolls_f.payroll_id%type,
25: c_time_period_id per_time_periods.time_period_id%type,
26: c_location_id per_all_assignments_f.location_id%type,
27: c_emp_cat_code per_all_people_f.per_information7%type,
28: c_work_time_code per_all_people_f.per_information8%type,
29: c_sex per_all_people_f.sex%type,
30: c_survey_date date)
31: is

Line 28: c_work_time_code per_all_people_f.per_information8%type,

24: c_payroll_id pay_all_payrolls_f.payroll_id%type,
25: c_time_period_id per_time_periods.time_period_id%type,
26: c_location_id per_all_assignments_f.location_id%type,
27: c_emp_cat_code per_all_people_f.per_information7%type,
28: c_work_time_code per_all_people_f.per_information8%type,
29: c_sex per_all_people_f.sex%type,
30: c_survey_date date)
31: is
32: select count(*)

Line 29: c_sex per_all_people_f.sex%type,

25: c_time_period_id per_time_periods.time_period_id%type,
26: c_location_id per_all_assignments_f.location_id%type,
27: c_emp_cat_code per_all_people_f.per_information7%type,
28: c_work_time_code per_all_people_f.per_information8%type,
29: c_sex per_all_people_f.sex%type,
30: c_survey_date date)
31: is
32: select count(*)
33: from hr_soft_coding_keyflex hsck,

Line 79: p_emp_cat_code in per_all_people_f.per_information7%type,

75: (p_organization_id in hr_organization_units.organization_id%type,
76: p_payroll_id in pay_all_payrolls_f.payroll_id%type,
77: p_time_period_id in per_time_periods.time_period_id%type,
78: p_location_id in per_all_assignments_f.location_id%type,
79: p_emp_cat_code in per_all_people_f.per_information7%type,
80: p_work_time_code in per_all_people_f.per_information8%type,
81: p_sex in per_all_people_f.sex%type,
82: p_week_hours in per_all_assignments_f.normal_hours%type,
83: p_week_frequency in per_all_assignments_f.frequency%type,

Line 80: p_work_time_code in per_all_people_f.per_information8%type,

76: p_payroll_id in pay_all_payrolls_f.payroll_id%type,
77: p_time_period_id in per_time_periods.time_period_id%type,
78: p_location_id in per_all_assignments_f.location_id%type,
79: p_emp_cat_code in per_all_people_f.per_information7%type,
80: p_work_time_code in per_all_people_f.per_information8%type,
81: p_sex in per_all_people_f.sex%type,
82: p_week_hours in per_all_assignments_f.normal_hours%type,
83: p_week_frequency in per_all_assignments_f.frequency%type,
84: p_survey_date in date)

Line 81: p_sex in per_all_people_f.sex%type,

77: p_time_period_id in per_time_periods.time_period_id%type,
78: p_location_id in per_all_assignments_f.location_id%type,
79: p_emp_cat_code in per_all_people_f.per_information7%type,
80: p_work_time_code in per_all_people_f.per_information8%type,
81: p_sex in per_all_people_f.sex%type,
82: p_week_hours in per_all_assignments_f.normal_hours%type,
83: p_week_frequency in per_all_assignments_f.frequency%type,
84: p_survey_date in date)
85: return number is

Line 101: c_sex per_all_people_f.sex%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,
105: ptp.regular_payment_date,

Line 201: p_sex in per_all_people_f.sex%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:
205: v_emp_balance number(20,5) := 0;

Line 214: c_sex per_all_people_f.sex%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,
218: ptp.regular_payment_date,