DBA Data[Home] [Help]

APPS.PAY_SE_STAT_OFFICE_ARCHIVE dependencies on PAY_RUN_RESULTS

Line 494: pay_run_results prr,

490: fnd_date.canonical_to_date(prrv3.result_value) end_date,
491: prrv4.result_value part_day
492: FROM pay_assignment_actions paa,
493: pay_payroll_actions ppa,
494: pay_run_results prr,
495: pay_run_result_values prrv1,
496: pay_run_result_values prrv2,
497: pay_run_result_values prrv3,
498: pay_run_result_values prrv4

Line 527: pay_run_results prr,

523: p_source_id NUMBER) IS
524: SELECT max(to_number(prrv1.result_value)) full_day
525: FROM pay_assignment_actions paa,
526: pay_payroll_actions ppa,
527: pay_run_results prr,
528: pay_run_result_values prrv1
529: WHERE ppa.effective_date BETWEEN p_report_start_date
530: AND p_report_end_date
531: AND ppa.payroll_action_id = paa.payroll_action_id

Line 555: pay_run_results prr,

551: fnd_date.canonical_to_date(prrv3.result_value) end_date,
552: prrv4.result_value employer_days
553: FROM pay_assignment_actions paa,
554: pay_payroll_actions ppa,
555: pay_run_results prr,
556: pay_run_result_values prrv1,
557: pay_run_result_values prrv2,
558: pay_run_result_values prrv3,
559: pay_run_result_values prrv4