APPS.PAY_NO_SAL_STATISTICS_ARCHIVE dependencies on PER_TIME_PERIODS

Line 565: per_time_periods ptp,

561: SELECT sum(prrv.result_value) result
562: FROM
563: pay_assignment_actions paa,
564: pay_payroll_actions ppa,
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

Line 619: from per_time_periods

615: p_report_date DATE)
616: IS
617: SELECT end_date,
618: start_date
619: from per_time_periods
620: where payroll_id = p_payroll_id
621: and p_report_date BETWEEN start_date and end_date;
622:
623: CURSOR csr_previous_period

Line 628: from per_time_periods

624: (p_payroll_id NUMBER,
625: p_report_date DATE)
626: IS
627: SELECT max(end_date) prev_end_date
628: from per_time_periods
629: where payroll_id = p_payroll_id
630: and end_date < p_report_date;
631:
632: --