DBA Data[Home] [Help]

APPS.PAY_SE_WAGES_SALARIES dependencies on PAY_RUN_RESULT_VALUES

Line 1067: pay_run_result_values prrv1,

1063: SELECT SUM(RESULT_VALUE) total --prrv1.* ,paa.assignment_id
1064: FROM pay_assignment_actions paa,
1065: pay_payroll_actions ppa,
1066: pay_run_results prr,
1067: pay_run_result_values prrv1,
1068: pay_input_values_f pivf,
1069: pay_element_types_f petf
1070: /* pay_run_result_values prrv2,
1071: pay_run_result_values prrv3*/

Line 1070: /* pay_run_result_values prrv2,

1066: pay_run_results prr,
1067: pay_run_result_values prrv1,
1068: pay_input_values_f pivf,
1069: pay_element_types_f petf
1070: /* pay_run_result_values prrv2,
1071: pay_run_result_values prrv3*/
1072: WHERE ppa.effective_date BETWEEN csr_v_start_date --'01-feb-2000' --p_group_start_date --'01-jun-1999' --p_report_start_date
1073: AND csr_v_end_date --'28-feb-2000'
1074: /* AND p_group_end_date /*'01-jun-2000' */--p_report_end_date

Line 1071: pay_run_result_values prrv3*/

1067: pay_run_result_values prrv1,
1068: pay_input_values_f pivf,
1069: pay_element_types_f petf
1070: /* pay_run_result_values prrv2,
1071: pay_run_result_values prrv3*/
1072: WHERE ppa.effective_date BETWEEN csr_v_start_date --'01-feb-2000' --p_group_start_date --'01-jun-1999' --p_report_start_date
1073: AND csr_v_end_date --'28-feb-2000'
1074: /* AND p_group_end_date /*'01-jun-2000' */--p_report_end_date
1075: AND ppa.payroll_action_id = paa.payroll_action_id