eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NZ_REC_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 116: p_element_type_id in pay_element_types_f.element_type_id%type)

112: ------------------------------------------------------------------------
113: function result_ptd
114: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
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';

Line 128: c_element_type_id in pay_element_types_f.element_type_id%type) is

124:
125: cursor sum_results
126: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
127: c_assignment_id in pay_assignment_actions.assignment_id%type,
128: c_element_type_id in pay_element_types_f.element_type_id%type) is
129:
130: select sum(prrv.result_value)
131: from pay_payroll_actions ppa,
132: pay_assignment_actions pac,

Line 135: pay_element_types_f pet,

131: from pay_payroll_actions ppa,
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

Line 176: p_element_type_id in pay_element_types_f.element_type_id%type)

172: ------------------------------------------------------------------------
173: function result_ytd
174: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
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';

Line 189: c_element_type_id IN pay_element_types_f.element_type_id%TYPE,

185:
186: CURSOR sum_results
187: (c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
188: c_assignment_id IN pay_assignment_actions.assignment_id%TYPE,
189: c_element_type_id IN pay_element_types_f.element_type_id%TYPE,
190: c_time_period_id IN per_time_periods.time_period_id%TYPE)
191: IS
192: SELECT SUM(prrv.result_value)
193: FROM pay_payroll_actions ppa

Line 197: , pay_element_types_f pet

193: FROM pay_payroll_actions ppa
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

Line 252: p_element_type_id in pay_element_types_f.element_type_id%type,

248: ------------------------------------------------------------------------
249: function single_feed_balance
250: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
251: p_assignment_id in pay_assignment_actions.assignment_id%type,
252: p_element_type_id in pay_element_types_f.element_type_id%type,
253: p_assignment_action_id out nocopy pay_assignment_actions.assignment_action_id%type,
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

Line 266: c_element_type_id in pay_element_types_f.element_type_id%type) is

262:
263: cursor single_balance_feed
264: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
265: c_assignment_id in pay_assignment_actions.assignment_id%type,
266: c_element_type_id in pay_element_types_f.element_type_id%type) is
267:
268: select pac.assignment_action_id,
269: pbf.balance_type_id,
270: pbf.effective_start_date

Line 271: from pay_element_types_f pet,

267:
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,

Line 325: p_element_type_id in pay_element_types_f.element_type_id%type)

321: ------------------------------------------------------------------------
322: function value_ptd
323: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
324: p_assignment_id in pay_assignment_actions.assignment_id%type,
325: p_element_type_id in pay_element_types_f.element_type_id%type)
326: return number is
327:
328: p_assignment_action_id pay_assignment_actions.assignment_action_id%type;
329: p_balance_type_id pay_balance_types.balance_type_id%type;

Line 362: p_element_type_id in pay_element_types_f.element_type_id%type)

358: ------------------------------------------------------------------------
359: function value_ytd
360: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
361: p_assignment_id in pay_assignment_actions.assignment_id%type,
362: p_element_type_id in pay_element_types_f.element_type_id%type)
363: return number is
364:
365: p_assignment_action_id pay_assignment_actions.assignment_action_id%type;
366: p_balance_type_id pay_balance_types.balance_type_id%type;