DBA Data[Home] [Help]

APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on PAY_RUN_RESULT_VALUES

Line 43: *** 16-Nov-06 abhargav 115.31 5603254 Modified cursor c_ps_element_details to remove join for table pay_input_values_f piv2 and pay_run_result_values prrv2.

39: *** 27-MAR-06 avenkatk 1.27 5119734 Modified cursor c_ps_element_details for reporting Allowances.
40: *** 20-Jun-06 ksingla 1.28 5333143 Add_months included to fetch FBT_RATE and MEDICARE_LEVY
41: *** 29-Oct-06 hnainani 1.29 5603254 Added Function get_element_payment_hours to fetch hours in c_element_details.
42: ***29 OCT 06 hnainani 1.30 5603524 Removed function get_element_payment_hours - used function defined in pay_au_Rec_det_archive instead
43: *** 16-Nov-06 abhargav 115.31 5603254 Modified cursor c_ps_element_details to remove join for table pay_input_values_f piv2 and pay_run_result_values prrv2.
44: *** 19-Dec-06 ksingla 115.32 5708255 Added code to get value of global FBT_THRESHOLD
45: *** 22-Dec-06 ksingla 115.33 5708255 Changed 1000 to g_fbt_threshold in cursor csr_assignment_only_paysum
46: *** 27-Dec-06 ksingla 115.34 5708255 Added to_number to all occurrences of g_fbt_threshold
47: *** 8-Jan-06 ksingla 115.35 Bug#5743196 Added nvl to cursor c_allowance_balance

Line 1565: ,pay_run_result_values prrv1

1561: ,pay_assignment_actions paa
1562: ,pay_payroll_actions ppa
1563: ,per_assignments_f paaf
1564: ,pay_run_results prr
1565: ,pay_run_result_values prrv1
1566: ,pay_element_classifications pec2
1567: ,pay_sub_classification_rules_f pscr
1568: where pet.element_type_id = piv1.element_type_id
1569: and pet.element_type_id = prr.element_type_id