eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_P45_PKG dependencies on STANDARD

Line 39: uses last_standard_process_date in

35: The parameter ASSIGNMENT_ID is now
36: L_ASSIGNMENT_ID
37: 28-AUG-97 A.Mills 110.1 Altered date format for NLS compliance
38: 24-SEP-98 A.Parkes 110.2 659488 Changes to get_ff_data: c_ptp now
39: uses last_standard_process_date in
40: preference to session_date, and c_act now
41: searches for PAYE or Taxable Pay balances
42: 27-APR-98 115.0 Initial checkin using uppsa from
43: revision 110.1

Line 45: last_standard_process_date in preference to session_date, and c_act now searches for

41: searches for PAYE or Taxable Pay balances
42: 27-APR-98 115.0 Initial checkin using uppsa from
43: revision 110.1
44: 24-SEP-98 115.1 Changes to get_ff_data : c_ptpt now uses
45: last_standard_process_date in preference to session_date, and c_act now searches for
46: PAYE or Taxable Pay Balances
47: 08-APR-99 djeng 115.2 Flexi date/multi radix compliance
48: 08-APR-99 djeng 115.3 Flex date compliance
49: 13-JUL-99 S.Robinson 115.4 Corrected canonical_to_date references

Line 1856: -- and a Last Standard Process has been set, check that an asg

1852: --------------------------------------------------------------------------
1853: -- FUNCTION payment_made
1854: -- DESCRIPTION Check whether final payment has been made for an assignment
1855: -- after the end date so that the p45 can be issued. If not,
1856: -- and a Last Standard Process has been set, check that an asg
1857: -- action exists in the period immediately preceding LSP date.
1858: --------------------------------------------------------------------------
1859: --
1860: FUNCTION payment_made (p_assignment_id in number,

Line 1879: cursor csr_last_standard_process (c_period_of_service_id in number) is

1875: and aa.payroll_action_id = pa.payroll_action_id
1876: and pa.action_type in ('R','Q','V','I','B')
1877: and pa.date_earned >= c_effective_end_date);
1878: --
1879: cursor csr_last_standard_process (c_period_of_service_id in number) is
1880: select serv.last_standard_process_date
1881: from per_periods_of_service serv
1882: where serv.period_of_service_id = c_period_of_service_id;
1883: --

Line 1880: select serv.last_standard_process_date

1876: and pa.action_type in ('R','Q','V','I','B')
1877: and pa.date_earned >= c_effective_end_date);
1878: --
1879: cursor csr_last_standard_process (c_period_of_service_id in number) is
1880: select serv.last_standard_process_date
1881: from per_periods_of_service serv
1882: where serv.period_of_service_id = c_period_of_service_id;
1883: --
1884: cursor csr_lsp_payment(c_last_process_date in date,

Line 1922: -- User may have set Last Standard Process to before default

1918: close csr_payment;
1919: --
1920: IF l_payment_made = FALSE THEN
1921: --
1922: -- User may have set Last Standard Process to before default
1923: -- date or on termination. Check the date
1924: --
1925: open csr_last_standard_process (p_period_of_service_id);
1926: fetch csr_last_standard_process into l_lsp_date;

Line 1925: open csr_last_standard_process (p_period_of_service_id);

1921: --
1922: -- User may have set Last Standard Process to before default
1923: -- date or on termination. Check the date
1924: --
1925: open csr_last_standard_process (p_period_of_service_id);
1926: fetch csr_last_standard_process into l_lsp_date;
1927: close csr_last_standard_process;
1928: --
1929: IF l_lsp_date is null then

Line 1926: fetch csr_last_standard_process into l_lsp_date;

1922: -- User may have set Last Standard Process to before default
1923: -- date or on termination. Check the date
1924: --
1925: open csr_last_standard_process (p_period_of_service_id);
1926: fetch csr_last_standard_process into l_lsp_date;
1927: close csr_last_standard_process;
1928: --
1929: IF l_lsp_date is null then
1930: -- No Last Standard Process Date and no Payment made.

Line 1927: close csr_last_standard_process;

1923: -- date or on termination. Check the date
1924: --
1925: open csr_last_standard_process (p_period_of_service_id);
1926: fetch csr_last_standard_process into l_lsp_date;
1927: close csr_last_standard_process;
1928: --
1929: IF l_lsp_date is null then
1930: -- No Last Standard Process Date and no Payment made.
1931: l_payment_made := FALSE;

Line 1930: -- No Last Standard Process Date and no Payment made.

1926: fetch csr_last_standard_process into l_lsp_date;
1927: close csr_last_standard_process;
1928: --
1929: IF l_lsp_date is null then
1930: -- No Last Standard Process Date and no Payment made.
1931: l_payment_made := FALSE;
1932: ELSE
1933: -- LSP Populated, so check assignment actions for assignment
1934: -- during the time period whose RPD immediately precedes the LSP

Line 2843: serv.last_standard_process_date,

2839: cursor csr_basic_asg_info (p_assid NUMBER, p_term_date DATE) IS
2840: SELECT ass.assignment_number,
2841: ass.person_id,
2842: ass.effective_end_date asg_effective_end_date,
2843: serv.last_standard_process_date,
2844: nvl(serv.final_process_date, hr_general.start_of_time),
2845: ass.period_of_service_id,
2846: decode(serv.leaving_reason,'D','D') deceased_flag,
2847: org.name org_name,