eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NZ_QES_PKG dependencies on STANDARD

Line 93: v_standard_hours 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;
92: v_part_time_count number(20) := 0;
93: v_standard_hours number(20) := 0;
94:
95: cursor emp_balance
96: (c_organization_id hr_organization_units.organization_id%type,
97: c_payroll_id pay_all_payrolls_f.payroll_id%type,

Line 167: v_standard_hours := convert_hours(p_week_hours,

163: else
164: v_emp_balance := balance_rec.balance;
165: end if;
166:
167: v_standard_hours := convert_hours(p_week_hours,
168: balance_rec.payroll_frequency,
169: p_week_frequency);
170:
171: if v_emp_balance > v_standard_hours then

Line 171: if v_emp_balance > v_standard_hours then

167: v_standard_hours := convert_hours(p_week_hours,
168: balance_rec.payroll_frequency,
169: p_week_frequency);
170:
171: if v_emp_balance > v_standard_hours then
172: v_full_time_count := v_full_time_count + 1;
173: elsif v_emp_balance <> 0 then
174: v_part_time_count := v_part_time_count + 1;
175: end if;

Line 350: cursor standard_conditions

346: return number is
347:
348: v_hours_worked number(20,5) := 0;
349:
350: cursor standard_conditions
351: (c_assignment_id per_all_assignments_f.assignment_id%type) is
352:
353: select paa.normal_hours,
354: paa.frequency frequency_code, -- to pass to convert_hours

Line 363: v_standard_conditions_rec standard_conditions%rowtype;

359: and paa.assignment_id = c_assignment_id
360: and paa.frequency = hl.lookup_code
361: and hl.lookup_type = 'FREQUENCY';
362:
363: v_standard_conditions_rec standard_conditions%rowtype;
364: begin
365: open standard_conditions (p_assignment_id);
366: fetch standard_conditions into v_standard_conditions_rec;
367: close standard_conditions;

Line 365: open standard_conditions (p_assignment_id);

361: and hl.lookup_type = 'FREQUENCY';
362:
363: v_standard_conditions_rec standard_conditions%rowtype;
364: begin
365: open standard_conditions (p_assignment_id);
366: fetch standard_conditions into v_standard_conditions_rec;
367: close standard_conditions;
368:
369: if v_standard_conditions_rec.frequency_code <> 'W' then

Line 366: fetch standard_conditions into v_standard_conditions_rec;

362:
363: v_standard_conditions_rec standard_conditions%rowtype;
364: begin
365: open standard_conditions (p_assignment_id);
366: fetch standard_conditions into v_standard_conditions_rec;
367: close standard_conditions;
368:
369: if v_standard_conditions_rec.frequency_code <> 'W' then
370: v_hours_worked := 0;

Line 367: close standard_conditions;

363: v_standard_conditions_rec standard_conditions%rowtype;
364: begin
365: open standard_conditions (p_assignment_id);
366: fetch standard_conditions into v_standard_conditions_rec;
367: close standard_conditions;
368:
369: if v_standard_conditions_rec.frequency_code <> 'W' then
370: v_hours_worked := 0;
371: else

Line 369: if v_standard_conditions_rec.frequency_code <> 'W' then

365: open standard_conditions (p_assignment_id);
366: fetch standard_conditions into v_standard_conditions_rec;
367: close standard_conditions;
368:
369: if v_standard_conditions_rec.frequency_code <> 'W' then
370: v_hours_worked := 0;
371: else
372: if v_standard_conditions_rec.frequency = p_payroll_frequency then
373: v_hours_worked := v_standard_conditions_rec.normal_hours;

Line 372: if v_standard_conditions_rec.frequency = p_payroll_frequency then

368:
369: if v_standard_conditions_rec.frequency_code <> 'W' then
370: v_hours_worked := 0;
371: else
372: if v_standard_conditions_rec.frequency = p_payroll_frequency then
373: v_hours_worked := v_standard_conditions_rec.normal_hours;
374: else
375: v_hours_worked := convert_hours (v_standard_conditions_rec.normal_hours,
376: p_payroll_frequency,

Line 373: v_hours_worked := v_standard_conditions_rec.normal_hours;

369: if v_standard_conditions_rec.frequency_code <> 'W' then
370: v_hours_worked := 0;
371: else
372: if v_standard_conditions_rec.frequency = p_payroll_frequency then
373: v_hours_worked := v_standard_conditions_rec.normal_hours;
374: else
375: v_hours_worked := convert_hours (v_standard_conditions_rec.normal_hours,
376: p_payroll_frequency,
377: v_standard_conditions_rec.frequency_code);

Line 375: v_hours_worked := convert_hours (v_standard_conditions_rec.normal_hours,

371: else
372: if v_standard_conditions_rec.frequency = p_payroll_frequency then
373: v_hours_worked := v_standard_conditions_rec.normal_hours;
374: else
375: v_hours_worked := convert_hours (v_standard_conditions_rec.normal_hours,
376: p_payroll_frequency,
377: v_standard_conditions_rec.frequency_code);
378: end if;
379: end if;

Line 377: v_standard_conditions_rec.frequency_code);

373: v_hours_worked := v_standard_conditions_rec.normal_hours;
374: else
375: v_hours_worked := convert_hours (v_standard_conditions_rec.normal_hours,
376: p_payroll_frequency,
377: v_standard_conditions_rec.frequency_code);
378: end if;
379: end if;
380:
381: return v_hours_worked;