APPS.PY_ROLLBACK_PKG dependencies on PER_TIME_PERIODS

Line 1681: v_time_period_id per_time_periods.time_period_id%TYPE;

1677: v_prj_flg_no_count number;
1678: v_prj_flg_x_count number;
1679: v_return_status varchar2(40);
1680: v_person_id per_all_people_f.person_id%TYPE;
1681: v_time_period_id per_time_periods.time_period_id%TYPE;
1682: --
1683: cursor chdact (p_asgact_id in number) is
1684: select paa_chd.assignment_action_id
1685: from pay_assignment_actions paa_chd

Line 1697: from per_time_periods ptp

1693: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date;
1694: --
1695: cursor get_time_period_id (p_payroll_id in pay_payrolls_f.payroll_id%TYPE, p_effective_date in date) is
1696: select time_period_id
1697: from per_time_periods ptp
1698: where ptp.payroll_id = p_payroll_id
1699: and p_effective_date between ptp.start_date and ptp.end_date;
1700: --
1701: begin