DBA Data[Home] [Help]

APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 894: pay_all_payrolls_f payr

890:
891: select ptpt.number_per_fiscal_year
892: into l_period_frequency
893: from per_time_period_types ptpt,
894: pay_all_payrolls_f payr
895: where payr.payroll_id = l_assignment.payroll_id
896: and p_report_date between payr.effective_start_date and payr.effective_end_date
897: and ptpt.period_type = payr.period_type;
898:

Line 4869: pay_all_payrolls_f payr

4865:
4866: select ptpt.number_per_fiscal_year
4867: into l_period_frequency
4868: from per_time_period_types ptpt,
4869: pay_all_payrolls_f payr
4870: where payr.payroll_id = l_assignment.payroll_id
4871: and p_report_date between payr.effective_start_date and payr.effective_end_date
4872: and ptpt.period_type = payr.period_type;
4873:

Line 6274: pay_all_payrolls_f payr

6270:
6271: select ptpt.number_per_fiscal_year
6272: into l_period_frequency
6273: from per_time_period_types ptpt,
6274: pay_all_payrolls_f payr
6275: where payr.payroll_id = l_assignment.payroll_id
6276: and p_report_date between payr.effective_start_date and payr.effective_end_date
6277: and ptpt.period_type = payr.period_type;
6278: