DBA Data[Home] [Help]

APPS.PAY_SE_ABSENCE dependencies on PAY_RUN_RESULTS

Line 812: pay_run_results prr,

808: /* prrv2.result_value fourteenth_date,
809: prrv3.result_value end_date*/
810: /*FROM pay_assignment_actions paa,
811: pay_payroll_actions ppa,
812: pay_run_results prr,
813: pay_run_result_values prrv1,
814: pay_input_values_f pivf,
815: pay_element_types_f petf
816: /* pay_run_result_values prrv2,

Line 835: pay_run_results prr,

831: SELECT SUM(prrv2.RESULT_VALUE) /*fnd_date.canonical_to_date(prrv1.RESULT_VALUE),prrv2.RESULT_VALUE,
832: ADD_MONTHS('15-nov-2000',-12), '15-nov-2000' --*, prrv1.result_value*/
833: FROM pay_assignment_actions paa,
834: pay_payroll_actions ppa,
835: pay_run_results prr,
836: pay_run_result_values prrv1,
837: pay_run_result_values prrv2--,
838: -- pay_run_result_values prrv3
839: WHERE ppa.effective_date BETWEEN p_start_date --ADD_MONTHS('15-nov-2000',-12)

Line 877: pay_run_results prr,

873: IS
874: SELECT nvl(SUM(prrv1.RESULT_VALUE),0)
875: FROM pay_assignment_actions paa,
876: pay_payroll_actions ppa,
877: pay_run_results prr,
878: pay_run_result_values prrv1--,
879: --pay_run_result_values prrv2
880: WHERE ppa.effective_date BETWEEN csr_v_start_date --ADD_MONTHS('15-nov-2000',-12)
881: AND csr_v_end_date --'15-nov-2000'