DBA Data[Home] [Help]

APPS.PAY_SE_ABSENCE dependencies on PAY_PAYROLL_ACTIONS

Line 811: pay_payroll_actions ppa,

807: SELECT SUM(RESULT_VALUE)--prrv1.* ,paa.assignment_id
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

Line 834: pay_payroll_actions ppa,

830:
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

Line 876: pay_payroll_actions ppa,

872: csr_v_end_date DATE)
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)