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_PAYROLL_ACTIONS

Line 7: (p_time_period_id in pay_payroll_actions.time_period_id%type)

3: ------------------------------------------------------------------------
4: -- Selects the Regular Payment Date for the Period Id that is passed in.
5: ------------------------------------------------------------------------
6: function period_payment_date
7: (p_time_period_id in pay_payroll_actions.time_period_id%type)
8: return per_time_periods.regular_payment_date%type is
9:
10: v_payment_date per_time_periods.regular_payment_date%type;
11:

Line 13: (c_time_period_id in pay_payroll_actions.time_period_id%type) is

9:
10: v_payment_date per_time_periods.regular_payment_date%type;
11:
12: cursor payment_date
13: (c_time_period_id in pay_payroll_actions.time_period_id%type) is
14:
15: select regular_payment_date
16: from per_time_periods
17: where time_period_id = c_time_period_id;

Line 34: p_time_period_id in pay_payroll_actions.time_period_id%type)

30: -- call to another package function.
31: ------------------------------------------------------------------------
32: function first_action_sequence
33: (p_assignment_id in pay_assignment_actions.assignment_id%type,
34: p_time_period_id in pay_payroll_actions.time_period_id%type)
35: return pay_assignment_actions.action_sequence%type is
36:
37: v_action_sequence pay_assignment_actions.action_sequence%type := null;
38: v_payment_date per_time_periods.regular_payment_date%type := null;

Line 52: pay_payroll_actions ppa,

48:
49: select min(pac.action_sequence)
50: from per_assignments_f paf,
51: per_time_periods ptp,
52: pay_payroll_actions ppa,
53: pay_assignment_actions pac
54: where paf.assignment_id = c_assignment_id
55: and pac.assignment_id = paf.assignment_id
56: and ptp.time_period_id = ppa.time_period_id

Line 84: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

80: ------------------------------------------------------------------------
81: -- Selects the current Action Sequence for that Assignment.
82: ------------------------------------------------------------------------
83: function last_action_sequence
84: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
85: p_assignment_id in pay_assignment_actions.assignment_id%type)
86: return pay_assignment_actions.action_sequence%type is
87:
88: v_action_sequence pay_assignment_actions.action_sequence%type;

Line 91: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

87:
88: v_action_sequence pay_assignment_actions.action_sequence%type;
89:
90: cursor max_sequence
91: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
92: c_assignment_id in pay_assignment_actions.assignment_id%type) is
93:
94: select pac.action_sequence
95: from pay_payroll_actions ppa,

Line 95: from pay_payroll_actions ppa,

91: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
92: c_assignment_id in pay_assignment_actions.assignment_id%type) is
93:
94: select pac.action_sequence
95: from pay_payroll_actions ppa,
96: pay_assignment_actions pac
97: where ppa.payroll_action_id = pac.payroll_action_id
98: and ppa.payroll_action_id = c_payroll_action_id
99: and pac.assignment_id = c_assignment_id;

Line 114: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

110: -- Sums the Result Values for the Period-To-Date. This will be called for
111: -- Elements that are the only feed for their Balance.
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:

Line 126: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

122: -- It makes sense to only sum values that have Money as a Unit of Measure
123: v_ptd_results number := 0;
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)

Line 131: from pay_payroll_actions ppa,

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,
133: pay_run_results prr,
134: pay_run_result_values prrv,
135: pay_element_types_f pet,

Line 174: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

170: -- Sums the Result Values for the Year-To-Date. This will be called for
171: -- Elements that are the only feed for their Balance.
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:

Line 187: (c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,

183: v_ytd_results number := 0;
184: v_time_period_id per_time_periods.time_period_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

Line 193: FROM pay_payroll_actions ppa

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
194: , pay_assignment_actions pac
195: , pay_run_results prr
196: , pay_run_result_values prrv
197: , pay_element_types_f pet

Line 215: pay_payroll_actions.payroll_action_id%type) is

211: AND pac.action_sequence >= first_action_sequence(pac.assignment_id, c_time_period_id)
212: AND pac.action_sequence <= last_action_sequence(c_payroll_action_id, pac.assignment_id);
213:
214: cursor get_time_period_id (c_payroll_action_id in
215: pay_payroll_actions.payroll_action_id%type) is
216: select time_period_id from pay_payroll_actions
217: where payroll_action_id = c_payroll_action_id;
218: begin
219: open get_time_period_id(p_payroll_action_id);

Line 216: select time_period_id from pay_payroll_actions

212: AND pac.action_sequence <= last_action_sequence(c_payroll_action_id, pac.assignment_id);
213:
214: cursor get_time_period_id (c_payroll_action_id in
215: pay_payroll_actions.payroll_action_id%type) is
216: select time_period_id from pay_payroll_actions
217: where payroll_action_id = c_payroll_action_id;
218: begin
219: open get_time_period_id(p_payroll_action_id);
220: fetch get_time_period_id into v_time_period_id;

Line 250: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

246: -- feed, so return the necessary parameters required to call
247: -- hr_nzbal.calc_asg_ytd. Otherwise no records will be returned.
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,

Line 264: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

260:
261: v_single_feed boolean := FALSE;
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,

Line 274: pay_payroll_actions ppa,

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
277: where ppa.payroll_action_id = c_payroll_action_id
278: and pet.element_type_id = c_element_type_id

Line 323: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

319: -- hr_nzbal package) is called. Otherwise, the Result PTD function in this
320: -- package is called.
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:

Line 360: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

356: -- hr_nzbal package) is called. Otherwise, the Result YTD function in this
357: -- package is called.
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: