APPS.PQP_RATES_HISTORY_CALC dependencies on PER_TIME_PERIOD_TYPES

Line 695: ,per_time_period_types types

691: IS
692: SELECT types.number_per_fiscal_year annualization_factor
693: FROM per_all_assignments_f assign
694: ,per_time_periods period
695: ,per_time_period_types types
696: WHERE assign.assignment_id = p_assignment_id
697: AND period.payroll_id = assign.payroll_id
698: AND p_effective_date BETWEEN period.start_date
699: AND period.end_date

Line 709: FROM per_time_period_types

705: CURSOR csr_number_per_fiscal_year
706: (p_period_type IN VARCHAR2
707: ) IS
708: SELECT number_per_fiscal_year
709: FROM per_time_period_types
710: WHERE period_type = p_period_type;
711:
712: l_proc_step NUMBER(20,10):=0;
713: l_proc_name VARCHAR2(61):=

Line 717: l_current_pay_frequency per_time_period_types.number_per_fiscal_year%TYPE;

713: l_proc_name VARCHAR2(61):=
714: g_package_name||'get_annualization_factor';
715:
716: l_dim_annualization_factor NUMBER;
717: l_current_pay_frequency per_time_period_types.number_per_fiscal_year%TYPE;
718: l_biweekly_pay_frequency per_time_period_types.number_per_fiscal_year%TYPE:=26;
719: l_weekly_pay_frequency per_time_period_types.number_per_fiscal_year%TYPE:=52;
720: l_monthly_pay_frequency per_time_period_types.number_per_fiscal_year%TYPE:=12;
721: l_base_frequency per_time_period_types.number_per_fiscal_year%TYPE:=12;

Line 718: l_biweekly_pay_frequency per_time_period_types.number_per_fiscal_year%TYPE:=26;

714: g_package_name||'get_annualization_factor';
715:
716: l_dim_annualization_factor NUMBER;
717: l_current_pay_frequency per_time_period_types.number_per_fiscal_year%TYPE;
718: l_biweekly_pay_frequency per_time_period_types.number_per_fiscal_year%TYPE:=26;
719: l_weekly_pay_frequency per_time_period_types.number_per_fiscal_year%TYPE:=52;
720: l_monthly_pay_frequency per_time_period_types.number_per_fiscal_year%TYPE:=12;
721: l_base_frequency per_time_period_types.number_per_fiscal_year%TYPE:=12;
722: l_pay_frequency_factor NUMBER:= 1;

Line 719: l_weekly_pay_frequency per_time_period_types.number_per_fiscal_year%TYPE:=52;

715:
716: l_dim_annualization_factor NUMBER;
717: l_current_pay_frequency per_time_period_types.number_per_fiscal_year%TYPE;
718: l_biweekly_pay_frequency per_time_period_types.number_per_fiscal_year%TYPE:=26;
719: l_weekly_pay_frequency per_time_period_types.number_per_fiscal_year%TYPE:=52;
720: l_monthly_pay_frequency per_time_period_types.number_per_fiscal_year%TYPE:=12;
721: l_base_frequency per_time_period_types.number_per_fiscal_year%TYPE:=12;
722: l_pay_frequency_factor NUMBER:= 1;
723: l_contract_factor NUMBER;

Line 720: l_monthly_pay_frequency per_time_period_types.number_per_fiscal_year%TYPE:=12;

716: l_dim_annualization_factor NUMBER;
717: l_current_pay_frequency per_time_period_types.number_per_fiscal_year%TYPE;
718: l_biweekly_pay_frequency per_time_period_types.number_per_fiscal_year%TYPE:=26;
719: l_weekly_pay_frequency per_time_period_types.number_per_fiscal_year%TYPE:=52;
720: l_monthly_pay_frequency per_time_period_types.number_per_fiscal_year%TYPE:=12;
721: l_base_frequency per_time_period_types.number_per_fiscal_year%TYPE:=12;
722: l_pay_frequency_factor NUMBER:= 1;
723: l_contract_factor NUMBER;
724: l_column_name pay_user_columns.user_column_name%TYPE;

Line 721: l_base_frequency per_time_period_types.number_per_fiscal_year%TYPE:=12;

717: l_current_pay_frequency per_time_period_types.number_per_fiscal_year%TYPE;
718: l_biweekly_pay_frequency per_time_period_types.number_per_fiscal_year%TYPE:=26;
719: l_weekly_pay_frequency per_time_period_types.number_per_fiscal_year%TYPE:=52;
720: l_monthly_pay_frequency per_time_period_types.number_per_fiscal_year%TYPE:=12;
721: l_base_frequency per_time_period_types.number_per_fiscal_year%TYPE:=12;
722: l_pay_frequency_factor NUMBER:= 1;
723: l_contract_factor NUMBER;
724: l_column_name pay_user_columns.user_column_name%TYPE;
725: