DBA Data[Home] [Help]

APPS.HR_AUBAL dependencies on PER_TIME_PERIODS

Line 1406: from per_time_periods ptp

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

Line 1670: from per_time_periods ptp

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

Line 1805: from per_time_periods ptp

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