APPS.PSP_PAYTRN dependencies on PER_TIME_PERIODS

Line 30: -- from per_time_periods_f based on time period id

26: p_set_of_books_id IN NUMBER) -- Introduced for bug fix 3098050
27: IS
28:
29: -- Get Payroll start date , end date, payroll id
30: -- from per_time_periods_f based on time period id
31:
32: CURSOR get_payroll_id_csr is
33: SELECT start_date, end_date, payroll_id
34: FROM per_time_periods

Line 34: FROM per_time_periods

30: -- from per_time_periods_f based on time period id
31:
32: CURSOR get_payroll_id_csr is
33: SELECT start_date, end_date, payroll_id
34: FROM per_time_periods
35: WHERE time_period_id = p_time_period_id ;
36:
37: -- Declare variables for above cursor
38:

Line 278: pay_assignment_actions asga, pay_payroll_actions paya, per_time_periods ptp,

274: ptp.end_date tp_end_date,
275: ptp.time_period_id,
276: NVL(b.element_entry_id, (SELECT element_entry_id FROM pay_run_results prr where prr.run_result_id = b.source_id)) source_id
277: FROM PAY_COSTS a, PAY_RUN_RESULTS b, PSP_ELEMENT_TYPES c, PAY_ELEMENT_TYPES_F d,
278: pay_assignment_actions asga, pay_payroll_actions paya, per_time_periods ptp,
279: pay_input_values_f piv
280: WHERE a.assignment_action_id = l_assignment_action_id and
281: SUBSTR(piv.uom, 1, 1) IN ('M', g_uom) AND
282: not exists ( select null

Line 320: pay_assignment_actions asga, pay_payroll_actions paya, per_time_periods ptp,

316: ptp.end_date tp_end_date,
317: ptp.time_period_id,
318: NVL(b.element_entry_id, (SELECT element_entry_id FROM pay_run_results prr where prr.run_result_id = b.source_id)) source_id
319: FROM PAY_COSTS a, PAY_RUN_RESULTS b, PSP_ELEMENT_TYPES c, PAY_ELEMENT_TYPES_F d,
320: pay_assignment_actions asga, pay_payroll_actions paya, per_time_periods ptp,
321: pay_input_values_f piv
322: WHERE a.assignment_action_id = l_assignment_action_id and
323: SUBSTR(piv.uom, 1, 1) IN ('M', g_uom) AND
324: exists ( select null

Line 488: per_time_periods ptp

484: where ppc.run_id = l_run_id
485: and ppc.payroll_control_id = ppl.payroll_control_id
486: group by ppl.payroll_action_type, ppc.time_period_id, ppc.parent_payroll_control_id) kount,
487: fnd_lookup_values_vl fvl,
488: per_time_periods ptp
489: where kount.payroll_action_type = fvl.lookup_code
490: and fvl.lookup_type = 'ACTION_TYPE'
491: and sysdate between nvl(fvl.start_date_active,fnd_date.canonical_to_date('2000/01/31')) and nvl(fvl.end_date_active, fnd_date.canonical_to_date('4000/01/31'))
492: and kount.time_period_id = ptp.time_period_id

Line 2545: WHERE period_type = (select period_type from per_time_periods

2541:
2542: CURSOR get_no_per_fiscal_year_csr is
2543: SELECT number_per_fiscal_year
2544: FROM per_time_period_types
2545: WHERE period_type = (select period_type from per_time_periods
2546: where time_period_id = x_time_period_id);
2547:
2548: --
2549: l_no_fiscal_year number := 0;

Line 8923: l_tp_end_date per_time_periods.end_date%TYPE; -- BUG 6886237

8919: FROM psp_payroll_lines ppl
8920: WHERE ppl.payroll_line_id = x_payroll_line_id;
8921:
8922: g_payroll_line_rec get_payroll_line_csr%ROWTYPE;
8923: l_tp_end_date per_time_periods.end_date%TYPE; -- BUG 6886237
8924: BEGIN
8925:
8926: hr_utility.trace(' Entering CREATE_SLINE_TERM_EMP');
8927: OPEN get_payroll_line_csr;

Line 8934: FROM per_time_periods

8930:
8931: /*Bug 6886237*/
8932: SELECT end_date
8933: INTO l_tp_end_date
8934: FROM per_time_periods
8935: WHERE time_period_id = (select time_period_id from psp_payroll_controls
8936: where payroll_control_id = (select payroll_control_id from
8937: psp_payroll_lines
8938: where payroll_line_id = x_payroll_line_id));