DBA Data[Home] [Help]

APPS.PER_PAY_PROPOSALS_POPULATE dependencies on PER_TIME_PERIOD_TYPES

Line 474: , per_time_period_types tpt

470: select prl.payroll_name
471: , tpt.number_per_fiscal_year
472: from pay_all_payrolls_f prl
473: , per_all_assignments_f paf
474: , per_time_period_types tpt
475: where paf.assignment_id=p_assignment_id
476: and p_date between paf.effective_start_date
477: and paf.effective_end_date
478: and paf.payroll_id=prl.payroll_id