DBA Data[Home] [Help]

APPS.PQP_US_FF_FUNCTIONS dependencies on PQP_CAR_MILEAGE_FUNCTIONS

Line 17: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid

13: l_string varchar2(1000);
14: --+
15: l_effective_date date;
16: BEGIN
17: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
18: (p_payroll_action_id));
19:
20: IF upper(p_column_name) IN ('CURRENT_RESIDENCY_STATUS',
21: 'DATE_8233_SIGNED') THEN

Line 76: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid

72: FROM pay_state_rules
73: WHERE substr(jurisdiction_code,1,2) = substr(p_ele_iv_jur_code,1,2);
74: --+
75: BEGIN
76: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
77: (p_payroll_action_id));
78: IF p_ele_iv_jur_code = 'NOT ENTERED' THEN
79: l_state_code := p_override_loc_state;
80: ELSE

Line 109: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid

105: l_col_val number;
106: l_string varchar2(1000);
107: --+
108: BEGIN
109: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
110: (p_payroll_action_id));
111: l_string := 'SELECT 1
112: FROM pqp_analyzed_alien_data pad,
113: pqp_analyzed_alien_details pdd

Line 190: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid

186: WHERE state_code = p_state_code;
187: --+
188: BEGIN
189: IF p_payroll_action_id IS NOT NULL THEN
190: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
191: (p_payroll_action_id));
192: ELSE
193: l_effective_date :=p_effective_date;
194: END IF;

Line 434: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid

430: AND l_effective_date BETWEEN pas.effective_start_date
431: AND pas.effective_end_date);
432: --+
433: BEGIN
434: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
435: (p_payroll_action_id));
436: --+
437: FOR c_rec in c_prev_contrib LOOP
438: l_result := c_rec.pei_information6;