DBA Data[Home] [Help]

APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on PAY_INPUT_VALUES_F

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 1559: ,pay_input_values_f piv1

1555: prr.run_result_id,
1556: paa.source_action_id
1557: ,nvl(pet.element_information2,0) balance_type_id
1558: from pay_element_types_f pet
1559: ,pay_input_values_f piv1
1560: ,pay_element_classifications pec
1561: ,pay_assignment_actions paa
1562: ,pay_payroll_actions ppa
1563: ,per_assignments_f paaf