APPS.PAY_KR_DIM_PKG dependencies on PER_TIME_PERIODS

Line 35: FROM per_time_periods ptp,

31: /* Get the date next to the end date of the given period,
32: having the payroll action id */
33: SELECT PTP.end_date+1
34: INTO l_next_to_end_date
35: FROM per_time_periods ptp,
36: pay_payroll_actions pact
37: WHERE pact.payroll_action_id = p_payroll_action_id
38: AND pact.payroll_id = ptp.payroll_id
39: AND p_given_date between ptp.start_date and ptp.end_date;

Line 681: per_time_periods ptp,

677: prt.run_type_name,
678: ppa.assignment_set_id,
679: ptp.start_date
680: from pay_run_types_f prt,
681: per_time_periods ptp,
682: pay_payroll_actions ppa
683: where ppa.payroll_id = p_payroll_id
684: and ppa.action_type = 'R'
685: and ppa.effective_date

Line 707: from per_time_periods

703: order by ppa.effective_date desc, ppa.action_sequence desc;
704: --
705: cursor csr_start_date is
706: select start_date
707: from per_time_periods
708: where payroll_id = p_payroll_id
709: and p_effective_date
710: between start_date and end_date;
711: begin

Line 792: from per_time_periods ptp,

788: --
789: cursor csr_bonus_period_start_date is
790: select
791: min(greatest(ptp.start_date, trunc(ppa1.effective_date, 'YYYY')))
792: from per_time_periods ptp,
793: pay_run_types_f prt2,
794: pay_payroll_actions ppa2,
795: pay_assignment_actions paa2,
796: pay_run_types_f prt1,