DBA Data[Home] [Help]

APPS.PAY_SE_WAGES_SALARIES dependencies on PAY_RUN_RESULT_VALUES

Line 1068: pay_run_result_values prrv1,

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

Line 1071: /* pay_run_result_values prrv2,

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

Line 1072: pay_run_result_values prrv3*/

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