APPS.PAY_NL_TAXOFFICE_ARCHIVE dependencies on PER_TIME_PERIODS

Line 2455: per_time_periods ptp

2451: pay_element_types_f pet,
2452: pay_input_values_f piv,
2453: pay_run_results prr,
2454: pay_run_result_values prrv,
2455: per_time_periods ptp
2456: where
2457: pet.element_name='Standard Tax Deduction' and
2458: pet.element_type_id=piv.element_type_id and
2459: piv.name='Tax Reduction Flag' and

Line 2473: select /*+ORDERED INDEX(ptp PER_TIME_PERIODS_PK) */ decode(prrv.result_value,'NL_NONE','0','1') code,ppa.date_earned,paa.assignment_action_id,ptp.start_date --,prrv.result_value

2469: order by date_earned,paa.assignment_action_id; */
2470:
2471: /* 14934380*/
2472:
2473: select /*+ORDERED INDEX(ptp PER_TIME_PERIODS_PK) */ decode(prrv.result_value,'NL_NONE','0','1') code,ppa.date_earned,paa.assignment_action_id,ptp.start_date --,prrv.result_value
2474: from
2475: pay_payrolls_f ppf,
2476: pay_assignment_actions paa,
2477: pay_payroll_actions ppa,

Line 2482: per_time_periods ptp

2478: pay_element_types_f pet,
2479: pay_input_values_f piv,
2480: pay_run_results prr,
2481: pay_run_result_values prrv,
2482: per_time_periods ptp
2483: where
2484: pet.element_name='Standard Tax Deduction' and
2485: pet.element_type_id=piv.element_type_id and
2486: piv.name='Tax Reduction Flag' and