APPS.PAY_NZ_REC_PKG dependencies on PAY_INPUT_VALUES_F

Line 119: v_input_value_name constant pay_input_values_f.name%type := 'Pay Value';

115: p_assignment_id in pay_assignment_actions.assignment_id%type,
116: p_element_type_id in pay_element_types_f.element_type_id%type)
117: return number is
118:
119: v_input_value_name constant pay_input_values_f.name%type := 'Pay Value';
120: v_uom constant pay_input_values_f.uom%type := 'M';
121:
122: -- It makes sense to only sum values that have Money as a Unit of Measure
123: v_ptd_results number := 0;

Line 120: v_uom constant pay_input_values_f.uom%type := 'M';

116: p_element_type_id in pay_element_types_f.element_type_id%type)
117: return number is
118:
119: v_input_value_name constant pay_input_values_f.name%type := 'Pay Value';
120: v_uom constant pay_input_values_f.uom%type := 'M';
121:
122: -- It makes sense to only sum values that have Money as a Unit of Measure
123: v_ptd_results number := 0;
124:

Line 136: pay_input_values_f piv

132: pay_assignment_actions pac,
133: pay_run_results prr,
134: pay_run_result_values prrv,
135: pay_element_types_f pet,
136: pay_input_values_f piv
137: where ppa.payroll_action_id = c_payroll_action_id
138: and pac.assignment_id = c_assignment_id
139: and pet.element_type_id = c_element_type_id
140: and piv.uom = v_uom

Line 179: v_input_value_name constant pay_input_values_f.name%type := 'Pay Value';

175: p_assignment_id in pay_assignment_actions.assignment_id%type,
176: p_element_type_id in pay_element_types_f.element_type_id%type)
177: return number is
178:
179: v_input_value_name constant pay_input_values_f.name%type := 'Pay Value';
180: v_uom constant pay_input_values_f.uom%type := 'M';
181:
182: -- It makes sense to only sum values that have Money as a Unit of Measure
183: v_ytd_results number := 0;

Line 180: v_uom constant pay_input_values_f.uom%type := 'M';

176: p_element_type_id in pay_element_types_f.element_type_id%type)
177: return number is
178:
179: v_input_value_name constant pay_input_values_f.name%type := 'Pay Value';
180: v_uom constant pay_input_values_f.uom%type := 'M';
181:
182: -- It makes sense to only sum values that have Money as a Unit of Measure
183: v_ytd_results number := 0;
184: v_time_period_id per_time_periods.time_period_id%type;

Line 198: , pay_input_values_f piv

194: , pay_assignment_actions pac
195: , pay_run_results prr
196: , pay_run_result_values prrv
197: , pay_element_types_f pet
198: , pay_input_values_f piv
199: WHERE pac.assignment_id = c_assignment_id
200: AND pet.element_type_id = c_element_type_id
201: AND piv.uom = v_uom
202: AND piv.name = v_input_value_name

Line 258: v_input_value_name constant pay_input_values_f.name%type := 'Pay Value';

254: p_balance_type_id out nocopy pay_balance_types.balance_type_id%type,
255: p_effective_start_date out nocopy pay_balance_feeds_f.effective_start_date%type)
256: return boolean is
257:
258: v_input_value_name constant pay_input_values_f.name%type := 'Pay Value';
259: v_uom constant pay_input_values_f.uom%type := 'M';
260:
261: v_single_feed boolean := FALSE;
262:

Line 259: v_uom constant pay_input_values_f.uom%type := 'M';

255: p_effective_start_date out nocopy pay_balance_feeds_f.effective_start_date%type)
256: return boolean is
257:
258: v_input_value_name constant pay_input_values_f.name%type := 'Pay Value';
259: v_uom constant pay_input_values_f.uom%type := 'M';
260:
261: v_single_feed boolean := FALSE;
262:
263: cursor single_balance_feed

Line 272: pay_input_values_f piv,

268: select pac.assignment_action_id,
269: pbf.balance_type_id,
270: pbf.effective_start_date
271: from pay_element_types_f pet,
272: pay_input_values_f piv,
273: pay_balance_feeds_f pbf,
274: pay_payroll_actions ppa,
275: pay_assignment_actions pac,
276: pay_run_results prr