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