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 1978: -- and a Last Standard Process has been set, check that an asg

1974: --------------------------------------------------------------------------
1975: -- FUNCTION payment_made
1976: -- DESCRIPTION Check whether final payment has been made for an assignment
1977: -- after the end date so that the p45 can be issued. If not,
1978: -- and a Last Standard Process has been set, check that an asg
1979: -- action exists in the period immediately preceding LSP date.
1980: --------------------------------------------------------------------------
1981: --
1982: FUNCTION payment_made (p_assignment_id in number,

Line 2001: cursor csr_last_standard_process (c_period_of_service_id in number) is

1997: and aa.payroll_action_id = pa.payroll_action_id
1998: and pa.action_type in ('R','Q','V','I','B')
1999: and pa.date_earned >= c_effective_end_date);
2000: --
2001: cursor csr_last_standard_process (c_period_of_service_id in number) is
2002: select serv.last_standard_process_date
2003: from per_periods_of_service serv
2004: where serv.period_of_service_id = c_period_of_service_id;
2005: --

Line 2002: select serv.last_standard_process_date

1998: and pa.action_type in ('R','Q','V','I','B')
1999: and pa.date_earned >= c_effective_end_date);
2000: --
2001: cursor csr_last_standard_process (c_period_of_service_id in number) is
2002: select serv.last_standard_process_date
2003: from per_periods_of_service serv
2004: where serv.period_of_service_id = c_period_of_service_id;
2005: --
2006: cursor csr_lsp_payment(c_last_process_date in date,

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

2040: close csr_payment;
2041: --
2042: IF l_payment_made = FALSE THEN
2043: --
2044: -- User may have set Last Standard Process to before default
2045: -- date or on termination. Check the date
2046: --
2047: open csr_last_standard_process (p_period_of_service_id);
2048: fetch csr_last_standard_process into l_lsp_date;

Line 2047: open csr_last_standard_process (p_period_of_service_id);

2043: --
2044: -- User may have set Last Standard Process to before default
2045: -- date or on termination. Check the date
2046: --
2047: open csr_last_standard_process (p_period_of_service_id);
2048: fetch csr_last_standard_process into l_lsp_date;
2049: close csr_last_standard_process;
2050: --
2051: IF l_lsp_date is null then

Line 2048: fetch csr_last_standard_process into l_lsp_date;

2044: -- User may have set Last Standard Process to before default
2045: -- date or on termination. Check the date
2046: --
2047: open csr_last_standard_process (p_period_of_service_id);
2048: fetch csr_last_standard_process into l_lsp_date;
2049: close csr_last_standard_process;
2050: --
2051: IF l_lsp_date is null then
2052: -- No Last Standard Process Date and no Payment made.

Line 2049: close csr_last_standard_process;

2045: -- date or on termination. Check the date
2046: --
2047: open csr_last_standard_process (p_period_of_service_id);
2048: fetch csr_last_standard_process into l_lsp_date;
2049: close csr_last_standard_process;
2050: --
2051: IF l_lsp_date is null then
2052: -- No Last Standard Process Date and no Payment made.
2053: l_payment_made := FALSE;

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

2048: fetch csr_last_standard_process into l_lsp_date;
2049: close csr_last_standard_process;
2050: --
2051: IF l_lsp_date is null then
2052: -- No Last Standard Process Date and no Payment made.
2053: l_payment_made := FALSE;
2054: ELSE
2055: -- LSP Populated, so check assignment actions for assignment
2056: -- during the time period whose RPD immediately precedes the LSP

Line 3209: serv.last_standard_process_date,

3205: cursor csr_basic_asg_info (p_assid NUMBER, p_term_date DATE) IS
3206: SELECT ass.assignment_number,
3207: ass.person_id,
3208: ass.effective_end_date asg_effective_end_date,
3209: serv.last_standard_process_date,
3210: nvl(serv.final_process_date, hr_general.end_of_time), -- For bug 9071978
3211: ass.period_of_service_id,
3212: decode(serv.leaving_reason,'D','D') deceased_flag,
3213: org.name org_name,