DBA Data[Home] [Help]

APPS.PAY_NO_SAL_STATISTICS_ARCHIVE dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 569: pay_element_type_extra_info pxi

565: per_time_periods ptp,
566: pay_run_results prr,
567: pay_run_result_values prrv,
568: pay_element_types_f pet,
569: pay_element_type_extra_info pxi
570: WHERE
571: paa.assignment_id =p_assignment_id
572: and paa.payroll_action_id = ppa.payroll_action_id
573: and ptp.time_period_id = ppa.time_period_id

Line 598: pay_element_type_extra_info pxi

594: pay_payroll_actions ppa,
595: pay_run_results prr,
596: pay_run_result_values prrv,
597: pay_element_types_f pet,
598: pay_element_type_extra_info pxi
599: WHERE
600: paa.assignment_id =p_assignment_id
601: and paa.payroll_action_id = ppa.payroll_action_id
602: and ppa.effective_date between trunc(p_report_date,'Y') and p_report_date