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 PER_TIME_PERIODS

Line 8: return per_time_periods.regular_payment_date%type is

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:
12: cursor payment_date

Line 10: v_payment_date per_time_periods.regular_payment_date%type;

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:
12: cursor payment_date
13: (c_time_period_id in pay_payroll_actions.time_period_id%type) is
14:

Line 16: from per_time_periods

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;
18:
19: begin
20: open payment_date (p_time_period_id);

Line 38: v_payment_date per_time_periods.regular_payment_date%type := null;

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:
42: /*Bug #3306269 - Added per_assignments_f with date_effective checks, and

Line 47: c_period_payment_date in per_time_periods.regular_payment_date%type) is

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,
51: per_time_periods ptp,

Line 51: per_time_periods ptp,

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

Line 184: v_time_period_id per_time_periods.time_period_id%type;

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

Line 190: c_time_period_id IN per_time_periods.time_period_id%TYPE)

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