APPS.PAY_ZA_EOY_VAL dependencies on PER_TIME_PERIODS

Line 253: from per_time_periods

249: begin
250:
251: select to_char(min(start_date),'dd-mon-yyyy'),to_char(max(end_date),'dd-mon-yyyy')
252: into p_tax_start_date,p_tax_end_date
253: from per_time_periods
254: where payroll_id = p_payroll_id
255: and prd_information1 = p_tax_year;
256:
257: exception

Line 661: , per_time_periods PPTP

657: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(TARGET.RESULT_VALUE,0)))))
658: from pay_balance_feeds_f FEED
659: , pay_run_result_values TARGET
660: , pay_run_results RR
661: , per_time_periods PPTP
662: , per_time_periods BPTP
663: , pay_payroll_actions PACT
664: , pay_assignment_actions ASSACT
665: , pay_payroll_actions BACT

Line 662: , per_time_periods BPTP

658: from pay_balance_feeds_f FEED
659: , pay_run_result_values TARGET
660: , pay_run_results RR
661: , per_time_periods PPTP
662: , per_time_periods BPTP
663: , pay_payroll_actions PACT
664: , pay_assignment_actions ASSACT
665: , pay_payroll_actions BACT
666: , pay_assignment_actions BAL_ASSACT