APPS.PAY_FR_PTO_PKG dependencies on PER_TIME_PERIODS

Line 2193: ,per_time_periods PTP

2189: ,pay_assignment_actions ASSACT
2190: ,pay_assignment_actions BAL_ASSACT
2191: ,pay_payroll_actions PACT
2192: ,pay_payroll_actions BACT
2193: ,per_time_periods PTP
2194: where BAL_ASSACT.assignment_action_id = l_latest_aa /*B1 */
2195: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
2196: and FEED.balance_type_id = l_balance_type_id /*U1*/
2197: + decode(TARGET.input_value_id, null, 0, 0)

Line 2213: ,per_time_periods PTP1

2209: /* Year To Date */
2210: and PACT.effective_date > (
2211: select nvl(min(PTP1.end_date),l_fr_plan_info.accrual_year_start)
2212: from PAY_ACCRUAL_PLANS PAP1
2213: ,per_time_periods PTP1
2214: where PAP1.ACCRUAL_PLAN_ID = l_fr_plan_info.accrual_plan_id
2215: and pap1.information1 is not null
2216: AND PTP1.payroll_id = BACT.payroll_id
2217: and l_fr_plan_info.accrual_year_start -1

Line 2236: from per_time_periods ptp

2232: --
2233: CURSOR c_payroll_period(p_payroll_id number, p_effective_date date) is
2234: select ptp.start_date
2235: ,ptp.end_date
2236: from per_time_periods ptp
2237: where ptp.payroll_id = p_payroll_id
2238: and p_effective_date between ptp.start_date and ptp.end_date;
2239: --
2240: -- Cursor to return payroll_id