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_ASSIGNMENT_ACTIONS

Line 33: (p_assignment_id in pay_assignment_actions.assignment_id%type,

29: -- that Assignment. The start of the Financial Year is obtained from the
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;

Line 35: return pay_assignment_actions.action_sequence%type is

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;
39:

Line 37: v_action_sequence pay_assignment_actions.action_sequence%type := null;

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;
39:
40: v_start_of_year_day constant varchar2(5) := '01-04';
41:

Line 46: (c_assignment_id in pay_assignment_actions.assignment_id%type,

42: /*Bug #3306269 - Added per_assignments_f with date_effective checks, and
43: added action_status check for ppa and pac */
44: /* Bug #4200412 - Added p_time_period_id */
45: cursor min_sequence
46: (c_assignment_id in pay_assignment_actions.assignment_id%type,
47: c_period_payment_date in per_time_periods.regular_payment_date%type) is
48:
49: select min(pac.action_sequence)
50: from per_assignments_f paf,

Line 53: pay_assignment_actions pac

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
57: AND ppa.time_period_id = p_time_period_id

Line 85: p_assignment_id in pay_assignment_actions.assignment_id%type)

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;
89:

Line 86: return pay_assignment_actions.action_sequence%type is

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;
89:
90: cursor max_sequence

Line 88: v_action_sequence pay_assignment_actions.action_sequence%type;

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;
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

Line 92: c_assignment_id in pay_assignment_actions.assignment_id%type) is

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,
96: pay_assignment_actions pac

Line 96: pay_assignment_actions pac

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;
100:

Line 115: p_assignment_id in pay_assignment_actions.assignment_id%type,

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:
119: v_input_value_name constant pay_input_values_f.name%type := 'Pay Value';

Line 127: c_assignment_id in pay_assignment_actions.assignment_id%type,

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

Line 132: pay_assignment_actions pac,

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,
136: pay_input_values_f piv

Line 175: p_assignment_id in pay_assignment_actions.assignment_id%type,

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:
179: v_input_value_name constant pay_input_values_f.name%type := 'Pay Value';

Line 188: c_assignment_id IN pay_assignment_actions.assignment_id%TYPE,

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
192: SELECT SUM(prrv.result_value)

Line 194: , pay_assignment_actions pac

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
198: , pay_input_values_f piv

Line 251: p_assignment_id in pay_assignment_actions.assignment_id%type,

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,
255: p_effective_start_date out nocopy pay_balance_feeds_f.effective_start_date%type)

Line 253: p_assignment_action_id out nocopy pay_assignment_actions.assignment_action_id%type,

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
257:

Line 265: c_assignment_id in pay_assignment_actions.assignment_id%type,

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,
269: pbf.balance_type_id,

Line 275: pay_assignment_actions pac,

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
279: and pac.assignment_id = c_assignment_id

Line 324: p_assignment_id in pay_assignment_actions.assignment_id%type,

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:
328: p_assignment_action_id pay_assignment_actions.assignment_action_id%type;

Line 328: p_assignment_action_id pay_assignment_actions.assignment_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;
330: p_effective_start_date pay_balance_feeds_f.effective_start_date%type;
331: v_value_ptd number := 0;
332:

Line 361: p_assignment_id in pay_assignment_actions.assignment_id%type,

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:
365: p_assignment_action_id pay_assignment_actions.assignment_action_id%type;

Line 365: p_assignment_action_id pay_assignment_actions.assignment_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;
367: p_effective_start_date pay_balance_feeds_f.effective_start_date%type;
368: v_value_ytd number := 0;
369: