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.PY_ROLLBACK_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 27: assignment_id per_all_assignments_f.assignment_id%type,

23: batch_id pay_payroll_actions.batch_id%type,
24: --
25: -- Assignment Action Level Details.
26: assact_id pay_assignment_actions.assignment_action_id%type,
27: assignment_id per_all_assignments_f.assignment_id%type,
28: full_name per_all_people_f.full_name%type,
29: assignment_number per_all_assignments_f.assignment_number%type,
30: payroll_id pay_all_payrolls_f.payroll_id%type,
31: --

Line 29: assignment_number per_all_assignments_f.assignment_number%type,

25: -- Assignment Action Level Details.
26: assact_id pay_assignment_actions.assignment_action_id%type,
27: assignment_id per_all_assignments_f.assignment_id%type,
28: full_name per_all_people_f.full_name%type,
29: assignment_number per_all_assignments_f.assignment_number%type,
30: payroll_id pay_all_payrolls_f.payroll_id%type,
31: --
32: -- Other information.
33: legislation_code varchar2(2),

Line 725: l_person_id per_all_assignments_f.person_id%TYPE;

721: lb.expired_assignment_action_id
722: from pay_latest_balances lb
723: where lb.assignment_action_id = p_info.assact_id;
724: --
725: l_person_id per_all_assignments_f.person_id%TYPE;
726:
727: begin
728: -- Remove latest balances and associated context values.
729: -- Delete cascade not used because a) efficiency and

Line 748: from per_all_assignments_f

744: -- And Reversals now too!
745:
746: select person_id
747: into l_person_id
748: from per_all_assignments_f
749: where assignment_id = p_info.assignment_id
750: and p_info.action_date between
751: effective_start_date and effective_end_date;
752:

Line 2042: from per_all_assignments_f ASS,

2038: p_info.payroll_id,
2039: l_person_id,
2040: p_info.full_name,
2041: p_info.assignment_number
2042: from per_all_assignments_f ASS,
2043: per_all_people_f PEO,
2044: pay_assignment_actions ACT
2045: where ACT.assignment_action_id = p_info.assact_id
2046: and ASS.assignment_id = ACT.assignment_id

Line 2050: from per_all_assignments_f ASS2

2046: and ASS.assignment_id = ACT.assignment_id
2047: and PEO.person_id = ASS.person_id
2048: and ((p_info.action_type = 'X'
2049: and ASS.effective_start_date = (select max(ASS2.effective_start_date)
2050: from per_all_assignments_f ASS2
2051: where ASS2.assignment_id = ASS.assignment_id)
2052: and PEO.effective_start_date = (select max(PEO2.effective_start_date)
2053: from per_all_people_f PEO2
2054: where PEO2.person_id = PEO.person_id)

Line 2059: from per_all_assignments_f ASS2

2055: )
2056: or
2057: ((p_info.action_type = 'Z' or p_info.action_type = 'PRU')
2058: and ASS.effective_start_date = (select max(ASS2.effective_start_date)
2059: from per_all_assignments_f ASS2
2060: where ASS2.assignment_id = ASS.assignment_id
2061: and ASS2.effective_start_date <= p_info.action_date)
2062: and PEO.effective_start_date = (select max(PEO2.effective_start_date)
2063: from per_all_people_f PEO2

Line 2070: from per_all_assignments_f ASS2,

2066: )
2067: or
2068: (p_info.action_type = 'BEE'
2069: and ASS.effective_start_date = (select max(ASS2.effective_start_date)
2070: from per_all_assignments_f ASS2,
2071: pay_batch_lines pbl
2072: where ASS2.assignment_id = ASS.assignment_id
2073: and pbl.batch_id (+) = p_info.batch_id
2074: and pbl.assignment_id (+) = ASS.assignment_id

Line 2366: per_all_assignments_f ASS,

2362: (select null
2363: from pay_action_classifications CLASS,
2364: pay_payroll_actions PACT,
2365: pay_assignment_actions ACT,
2366: per_all_assignments_f ASS,
2367: per_periods_of_service POS
2368: where POS.person_id = l_person_id
2369: and ASS.period_of_service_id = POS.period_of_service_id
2370: and ACT.assignment_id = ASS.assignment_id

Line 2384: per_all_assignments_f ASS,

2380: (select null
2381: from pay_action_classifications CLASS,
2382: pay_payroll_actions PACT,
2383: pay_assignment_actions ACT,
2384: per_all_assignments_f ASS,
2385: per_periods_of_service POS
2386: where POS.person_id = l_person_id
2387: and ASS.period_of_service_id = POS.period_of_service_id
2388: and ACT.assignment_id = ASS.assignment_id

Line 2624: from per_all_assignments_f asg,

2620: */
2621: cursor c1 is
2622: select /*+ ORDERED*/ act.assignment_action_id,
2623: asg.period_of_service_id
2624: from per_all_assignments_f asg,
2625: pay_assignment_actions act
2626: where act.payroll_action_id = p_info.pact_id
2627: and asg.assignment_id = act.assignment_id
2628: and act.source_action_id is null

Line 2631: from per_all_assignments_f asg2

2627: and asg.assignment_id = act.assignment_id
2628: and act.source_action_id is null
2629: and ((p_info.action_type = 'X'
2630: and asg.effective_start_date = (select max(asg2.effective_start_date)
2631: from per_all_assignments_f asg2
2632: where asg2.assignment_id =
2633: asg.assignment_id)
2634: )
2635: or

Line 2638: from per_all_assignments_f asg2

2634: )
2635: or
2636: ((p_info.action_type = 'PRU' or p_info.action_type = 'Z')
2637: and asg.effective_start_date = (select max(asg2.effective_start_date)
2638: from per_all_assignments_f asg2
2639: where asg2.assignment_id =
2640: asg.assignment_id
2641: and asg2.effective_start_date <=
2642: p_info.action_date)

Line 2647: from per_all_assignments_f ASS2,

2643: )
2644: or
2645: (p_info.action_type = 'BEE'
2646: and asg.effective_start_date = (select max(ASS2.effective_start_date)
2647: from per_all_assignments_f ASS2,
2648: pay_batch_lines pbl
2649: where ASS2.assignment_id = asg.assignment_id
2650: and pbl.batch_id (+) = p_info.batch_id
2651: and pbl.assignment_id (+) = asg.assignment_id

Line 2954: per_all_assignments_f asg

2950: max(asg.person_id),
2951: 'U'
2952: from pay_payroll_actions pac,
2953: pay_assignment_actions act,
2954: per_all_assignments_f asg
2955: where pac.payroll_action_id = l_payroll_action_id
2956: and act.payroll_action_id = pac.payroll_action_id
2957: and asg.assignment_id = act.assignment_id
2958: group by pac.payroll_action_id;