DBA Data[Home] [Help]

APPS.HR_AUBAL dependencies on PER_TIME_PERIODS

Line 1409: from per_time_periods ptp

1405: -- has the processing time period expired
1406: --
1407: cursor expired_time_period (c_assignment_action_id number) is
1408: select ptp.end_date
1409: from per_time_periods ptp
1410: , pay_payroll_actions ppa
1411: , pay_assignment_actions paa
1412: where paa.assignment_action_id = c_assignment_action_id
1413: and paa.payroll_action_id = ppa.payroll_action_id

Line 1673: from per_time_periods ptp

1669: l_end_date date;
1670: --
1671: cursor expired_time_period ( c_assignment_action_id in number ) is
1672: select ptp.end_date
1673: from per_time_periods ptp
1674: , pay_payroll_actions ppa
1675: , pay_assignment_actions paa
1676: where paa.assignment_action_id = c_assignment_action_id
1677: and paa.payroll_action_id = ppa.payroll_action_id

Line 1808: from per_time_periods ptp

1804: l_end_date date;
1805: --
1806: cursor expired_time_period( c_assignment_action_id in number ) is
1807: select ptp.end_date
1808: from per_time_periods ptp
1809: , pay_payroll_actions ppa
1810: , pay_assignment_actions paa
1811: where paa.assignment_action_id = c_assignment_action_id
1812: and paa.payroll_action_id = ppa.payroll_action_id