APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PER_TIME_PERIOD_TYPES

Line 695: l_period_frequency per_time_period_types.number_per_fiscal_year%type;

691: l_report_start date;
692: l_report_end date;
693: l_report_date date;
694: l_difference number;
695: l_period_frequency per_time_period_types.number_per_fiscal_year%type;
696: l_ee_balance_type_id pay_balance_types.balance_type_id%type;
697: l_eea_balance_type_id pay_balance_types.balance_type_id%type;
698: l_input_value_id pay_input_values_f.input_value_id%type;
699: l_index number;

Line 846: from per_time_period_types ptpt,

842: begin
843:
844: select ptpt.number_per_fiscal_year
845: into l_period_frequency
846: from per_time_period_types ptpt,
847: pay_all_payrolls_f payr
848: where payr.payroll_id = l_assignment.payroll_id
849: and p_report_date between payr.effective_start_date and payr.effective_end_date
850: and ptpt.period_type = payr.period_type;

Line 4565: l_period_frequency per_time_period_types.number_per_fiscal_year%type;

4561: l_report_start date;
4562: l_report_end date;
4563: l_report_date date;
4564: l_difference number;
4565: l_period_frequency per_time_period_types.number_per_fiscal_year%type;
4566: l_ee_balance_type_id pay_balance_types.balance_type_id%type;
4567: l_eea_balance_type_id pay_balance_types.balance_type_id%type;
4568: l_input_value_id pay_input_values_f.input_value_id%type;
4569: l_index number;

Line 4743: from per_time_period_types ptpt,

4739: begin
4740:
4741: select ptpt.number_per_fiscal_year
4742: into l_period_frequency
4743: from per_time_period_types ptpt,
4744: pay_all_payrolls_f payr
4745: where payr.payroll_id = l_assignment.payroll_id
4746: and p_report_date between payr.effective_start_date and payr.effective_end_date
4747: and ptpt.period_type = payr.period_type;