APPS.PQP_INI_BAL dependencies on PQP_CAR_MILEAGE_FUNCTIONS

Line 1731: l_effective_date := TRUNC(pqp_car_mileage_functions.

1727: IF l_get_info.paye_Taxable = 'N' and l_get_info.Claim_End_Date >= to_date('04/06/2003','MM/DD/YYYY') THEN
1728:
1729: --Call balance functions
1730: l_count:=l_bal_info.count;
1731: l_effective_date := TRUNC(pqp_car_mileage_functions.
1732: pqp_get_date_paid(l_get_info.payroll_action_id));
1733: --Get the Processed Miles for the particular Entry
1734: l_proc_miles :=pqp_clm_bal.get_vehicletype_balance
1735: (p_assignment_id =>l_get_info.assignment_id

Line 1793: l_ret_val:= pqp_car_mileage_functions.pqp_get_attr_val

1789: ,p_element_entry_id =>l_get_info.element_entry_id
1790: ,p_assignment_action_id =>l_get_info.assignment_action_id
1791: );
1792: IF l_get_info.additional_passenger <> 0 THEN
1793: l_ret_val:= pqp_car_mileage_functions.pqp_get_attr_val
1794: (p_assignment_id =>l_get_info.assignment_id
1795: ,p_business_group_id =>l_get_info.business_group_id
1796: ,p_payroll_action_id =>l_get_info.payroll_action_id
1797: ,p_car_type =>l_get_info.usage_type

Line 1811: l_ret_val:=pqp_car_mileage_functions.pqp_get_addlpasg_rate

1807: l_eng_capacity:=NVL(l_get_info.engine_capacity,l_eng_capacity);
1808: l_calc_method:=NVL(l_get_info.calculation_method,l_calc_method);
1809: IF l_get_info.source_type <> 'R' and l_get_info.source_type <> 'V' THEN
1810: IF l_get_info.ownership = 'C' THEN
1811: l_ret_val:=pqp_car_mileage_functions.pqp_get_addlpasg_rate
1812: (p_business_group_id =>l_get_info.business_group_id
1813: ,p_payroll_action_id =>l_get_info.payroll_action_id
1814: ,p_vehicle_type =>l_get_info.usage_type
1815: ,p_claimed_mileage =>abs(l_proc_miles)

Line 1828: l_ret_val:=pqp_car_mileage_functions.pqp_get_passenger_rate

1824: ,p_tax_amt =>l_addl_tax_amt
1825: ,p_err_msg =>l_err_msg
1826: );
1827: ELSE
1828: l_ret_val:=pqp_car_mileage_functions.pqp_get_passenger_rate
1829: (p_business_group_id =>l_get_info.business_group_id
1830: ,p_payroll_action_id =>l_get_info.payroll_action_id
1831: ,p_vehicle_type =>l_get_info.usage_type
1832: ,p_claimed_mileage =>abs(l_proc_miles)

Line 1915: l_effective_date := TRUNC(pqp_car_mileage_functions.

1911: ELSIF l_get_info.element_entry_id <> l_old_element_entry_id
1912: AND l_get_info.Claim_End_Date >= to_date('04/06/2003','MM/DD/YYYY') THEN
1913: --If Entry is Paye Taxable , Amount to be paid will have to be calculated
1914: l_count:=l_bal_info.count;
1915: l_effective_date := TRUNC(pqp_car_mileage_functions.
1916: pqp_get_date_paid(l_get_info.payroll_action_id));
1917: /** Calculation of PAYE Taxable amount **/
1918:
1919: IF l_get_info.source_type <> 'R' and l_get_info.source_type <> 'V'THEN

Line 1920: l_ret_val:= pqp_car_mileage_functions.pqp_get_attr_val

1916: pqp_get_date_paid(l_get_info.payroll_action_id));
1917: /** Calculation of PAYE Taxable amount **/
1918:
1919: IF l_get_info.source_type <> 'R' and l_get_info.source_type <> 'V'THEN
1920: l_ret_val:= pqp_car_mileage_functions.pqp_get_attr_val
1921: (p_assignment_id =>l_get_info.assignment_id
1922: ,p_business_group_id =>l_get_info.business_group_id
1923: ,p_payroll_action_id =>l_get_info.payroll_action_id
1924: ,p_car_type =>l_get_info.usage_type

Line 1938: l_ret_val:= pqp_car_mileage_functions.pqp_get_range

1934: l_eng_capacity:=NVL(l_get_info.engine_capacity,l_eng_capacity);
1935: l_calc_method:=NVL(l_get_info.calculation_method,l_calc_method);
1936:
1937:
1938: l_ret_val:= pqp_car_mileage_functions.pqp_get_range
1939: (p_assignment_id => l_get_info.assignment_id
1940: ,p_business_group_id => l_get_info.business_group_id
1941: ,p_payroll_action_id =>l_get_info.payroll_action_id
1942: ,p_table_name =>l_rates_table

Line 1956: l_ret_val:= pqp_car_mileage_functions.pqp_get_range

1952: total_paye_taxable_cl_miles := priv_tot_paye_tax_cl_miles;
1953: priv_tot_paye_tax_cl_miles := priv_tot_paye_tax_cl_miles + l_get_info.Claimed_Mileage;
1954: END IF;
1955:
1956: l_ret_val:= pqp_car_mileage_functions.pqp_get_range
1957: (p_assignment_id => l_get_info.assignment_id
1958: ,p_business_group_id => l_get_info.business_group_id
1959: ,p_payroll_action_id =>l_get_info.payroll_action_id
1960: ,p_table_name =>l_rates_table

Line 1967: l_band_rate:= pqp_car_mileage_functions.pqp_get_table_value

1963: ,p_claim_date =>l_get_info.claim_end_date
1964: ,p_low_value =>l_mileage_band
1965: ,p_high_value =>h_mileage_band);
1966: -- Get the Lower Mileage Band Rate
1967: l_band_rate:= pqp_car_mileage_functions.pqp_get_table_value
1968: (p_bus_group_id => l_get_info.business_group_id
1969: ,p_payroll_action_id => l_get_info.payroll_action_id
1970: ,p_table_name => l_rates_table
1971: ,p_col_name => l_hi_eng_cap

Line 1977: h_band_rate:= pqp_car_mileage_functions.pqp_get_table_value

1973: ,p_effective_date => l_get_info.claim_end_date
1974: ,p_error_msg => l_err_msg);
1975:
1976: -- Get the Higher Mileage Band Rate
1977: h_band_rate:= pqp_car_mileage_functions.pqp_get_table_value
1978: (p_bus_group_id => l_get_info.business_group_id
1979: ,p_payroll_action_id => l_get_info.payroll_action_id
1980: ,p_table_name => l_rates_table
1981: ,p_col_name => l_hi_eng_cap

Line 2012: l_ret_val:=pqp_car_mileage_functions.pqp_get_addlpasg_rate

2008:
2009:
2010: IF l_get_info.additional_passenger <> 0 THEN
2011: IF l_get_info.source_type <> 'R' and l_get_info.source_type <> 'V'THEN
2012: l_ret_val:=pqp_car_mileage_functions.pqp_get_addlpasg_rate
2013: (p_business_group_id =>l_get_info.business_group_id
2014: ,p_payroll_action_id =>l_get_info.payroll_action_id
2015: ,p_vehicle_type =>l_get_info.usage_type
2016: ,p_claimed_mileage =>l_proc_miles

Line 2077: l_effective_date := TRUNC(pqp_car_mileage_functions.

2073: --END IF;
2074: END LOOP;
2075: CLOSE c_get_info;
2076: l_count:=l_count+1;
2077: l_effective_date := TRUNC(pqp_car_mileage_functions.
2078: pqp_get_date_paid(l_get_info.payroll_action_id));
2079:
2080: categorize_balances (p_bal_info => l_bal_info);
2081: --Insert into the pay_patch_status