APPS.PAY_NZ_QES_PKG dependencies on PER_TIME_PERIOD_TYPES

Line 395: v_number_per_year per_time_period_types.number_per_fiscal_year%type := 52;

391: p_assignment_frequency in per_all_assignments_f.frequency%type)
392: return number is
393:
394: v_converted_hours number(20,5) := 0;
395: v_number_per_year per_time_period_types.number_per_fiscal_year%type := 52;
396: v_periods_per_year per_time_period_types.number_per_fiscal_year%type := 1;
397:
398: begin
399: v_periods_per_year := no_periods_per_year (p_payroll_frequency);

Line 396: v_periods_per_year per_time_period_types.number_per_fiscal_year%type := 1;

392: return number is
393:
394: v_converted_hours number(20,5) := 0;
395: v_number_per_year per_time_period_types.number_per_fiscal_year%type := 52;
396: v_periods_per_year per_time_period_types.number_per_fiscal_year%type := 1;
397:
398: begin
399: v_periods_per_year := no_periods_per_year (p_payroll_frequency);
400: v_converted_hours := p_assignment_hours /

Line 412: (p_period_type in per_time_period_types.period_type%type)

408: -- Types needs to be queried to determine the number of Periods per
409: -- fiscal year.
410: ------------------------------------------------------------------------
411: function no_periods_per_year
412: (p_period_type in per_time_period_types.period_type%type)
413: return number is
414:
415: v_number_per_year per_time_period_types.number_per_fiscal_year%type := 0;
416:

Line 415: v_number_per_year per_time_period_types.number_per_fiscal_year%type := 0;

411: function no_periods_per_year
412: (p_period_type in per_time_period_types.period_type%type)
413: return number is
414:
415: v_number_per_year per_time_period_types.number_per_fiscal_year%type := 0;
416:
417: cursor no_of_periods
418: (c_period_type per_time_period_types.period_type%type) is
419:

Line 418: (c_period_type per_time_period_types.period_type%type) is

414:
415: v_number_per_year per_time_period_types.number_per_fiscal_year%type := 0;
416:
417: cursor no_of_periods
418: (c_period_type per_time_period_types.period_type%type) is
419:
420: select number_per_fiscal_year
421: from per_time_period_types
422: where period_type = c_period_type;

Line 421: from per_time_period_types

417: cursor no_of_periods
418: (c_period_type per_time_period_types.period_type%type) is
419:
420: select number_per_fiscal_year
421: from per_time_period_types
422: where period_type = c_period_type;
423:
424: begin
425: open no_of_periods (p_period_type);