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 276: pay_assignment_actions asga, pay_payroll_actions paya, per_time_periods ptp,

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

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

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

Line 486: per_time_periods ptp

482: where ppc.run_id = l_run_id
483: and ppc.payroll_control_id = ppl.payroll_control_id
484: group by ppl.payroll_action_type, ppc.time_period_id, ppc.parent_payroll_control_id) kount,
485: fnd_lookup_values_vl fvl,
486: per_time_periods ptp
487: where kount.payroll_action_type = fvl.lookup_code
488: and fvl.lookup_type = 'ACTION_TYPE'
489: 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'))
490: and kount.time_period_id = ptp.time_period_id

Line 2471: WHERE period_type = (select period_type from per_time_periods

2467:
2468: CURSOR get_no_per_fiscal_year_csr is
2469: SELECT number_per_fiscal_year
2470: FROM per_time_period_types
2471: WHERE period_type = (select period_type from per_time_periods
2472: where time_period_id = x_time_period_id);
2473:
2474: --
2475: l_no_fiscal_year number := 0;

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

8845: FROM psp_payroll_lines ppl
8846: WHERE ppl.payroll_line_id = x_payroll_line_id;
8847:
8848: g_payroll_line_rec get_payroll_line_csr%ROWTYPE;
8849: l_tp_end_date per_time_periods.end_date%TYPE; -- BUG 6886237
8850: BEGIN
8851:
8852: hr_utility.trace(' Entering CREATE_SLINE_TERM_EMP');
8853: OPEN get_payroll_line_csr;

Line 8860: FROM per_time_periods

8856:
8857: /*Bug 6886237*/
8858: SELECT end_date
8859: INTO l_tp_end_date
8860: FROM per_time_periods
8861: WHERE time_period_id = (select time_period_id from psp_payroll_controls
8862: where payroll_control_id = (select payroll_control_id from
8863: psp_payroll_lines
8864: where payroll_line_id = x_payroll_line_id));