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 730: l_person_id per_all_assignments_f.person_id%TYPE;

726: lb.expired_assignment_action_id
727: from pay_latest_balances lb
728: where lb.assignment_action_id = p_info.assact_id;
729: --
730: l_person_id per_all_assignments_f.person_id%TYPE;
731:
732: begin
733: -- Remove latest balances and associated context values.
734: -- Delete cascade not used because a) efficiency and

Line 753: from per_all_assignments_f

749: -- And Reversals now too!
750:
751: select person_id
752: into l_person_id
753: from per_all_assignments_f
754: where assignment_id = p_info.assignment_id
755: and p_info.action_date between
756: effective_start_date and effective_end_date;
757:

Line 1691: from per_all_assignments_f paaf

1687: order by paa_chd.action_sequence desc;
1688: --
1689: cursor get_person_id (p_assignment_id in per_all_people_f.person_id%TYPE, p_effective_date in date) is
1690: select PERSON_ID
1691: from per_all_assignments_f paaf
1692: where paaf.assignment_id = p_assignment_id
1693: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date;
1694: --
1695: cursor get_time_period_id (p_payroll_id in pay_payrolls_f.payroll_id%TYPE, p_effective_date in date) is

Line 2121: from per_all_assignments_f ASS,

2117: p_info.payroll_id,
2118: l_person_id,
2119: p_info.full_name,
2120: p_info.assignment_number
2121: from per_all_assignments_f ASS,
2122: per_all_people_f PEO,
2123: pay_assignment_actions ACT
2124: where ACT.assignment_action_id = p_info.assact_id
2125: and ASS.assignment_id = ACT.assignment_id

Line 2129: from per_all_assignments_f ASS2

2125: and ASS.assignment_id = ACT.assignment_id
2126: and PEO.person_id = ASS.person_id
2127: and ((p_info.action_type = 'X'
2128: and ASS.effective_start_date = (select max(ASS2.effective_start_date)
2129: from per_all_assignments_f ASS2
2130: where ASS2.assignment_id = ASS.assignment_id)
2131: and PEO.effective_start_date = (select max(PEO2.effective_start_date)
2132: from per_all_people_f PEO2
2133: where PEO2.person_id = PEO.person_id)

Line 2138: from per_all_assignments_f ASS2

2134: )
2135: or
2136: ((p_info.action_type = 'Z' or p_info.action_type = 'PRU')
2137: and ASS.effective_start_date = (select max(ASS2.effective_start_date)
2138: from per_all_assignments_f ASS2
2139: where ASS2.assignment_id = ASS.assignment_id
2140: and ASS2.effective_start_date <= p_info.action_date)
2141: and PEO.effective_start_date = (select max(PEO2.effective_start_date)
2142: from per_all_people_f PEO2

Line 2149: from per_all_assignments_f ASS2,

2145: )
2146: or
2147: (p_info.action_type = 'BEE'
2148: and ASS.effective_start_date = (select max(ASS2.effective_start_date)
2149: from per_all_assignments_f ASS2,
2150: pay_batch_lines pbl
2151: where ASS2.assignment_id = ASS.assignment_id
2152: and pbl.batch_id (+) = p_info.batch_id
2153: and pbl.assignment_id (+) = ASS.assignment_id

Line 2453: per_all_assignments_f ASS,

2449: (select null
2450: from pay_action_classifications CLASS,
2451: pay_payroll_actions PACT,
2452: pay_assignment_actions ACT,
2453: per_all_assignments_f ASS,
2454: per_periods_of_service POS
2455: where POS.person_id = l_person_id
2456: and ASS.period_of_service_id = POS.period_of_service_id
2457: and ACT.assignment_id = ASS.assignment_id

Line 2471: per_all_assignments_f ASS,

2467: (select null
2468: from pay_action_classifications CLASS,
2469: pay_payroll_actions PACT,
2470: pay_assignment_actions ACT,
2471: per_all_assignments_f ASS,
2472: per_periods_of_service POS
2473: where POS.person_id = l_person_id
2474: and ASS.period_of_service_id = POS.period_of_service_id
2475: and ACT.assignment_id = ASS.assignment_id

Line 2712: from per_all_assignments_f asg,

2708: */
2709: cursor c1 is
2710: select act.assignment_action_id, -- Bug 6834017 ,Removed ordered hint
2711: asg.period_of_service_id
2712: from per_all_assignments_f asg,
2713: pay_assignment_actions act
2714: where act.payroll_action_id = p_info.pact_id
2715: and asg.assignment_id = act.assignment_id
2716: and act.source_action_id is null

Line 2719: from per_all_assignments_f asg2

2715: and asg.assignment_id = act.assignment_id
2716: and act.source_action_id is null
2717: and ((p_info.action_type = 'X'
2718: and asg.effective_start_date = (select max(asg2.effective_start_date)
2719: from per_all_assignments_f asg2
2720: where asg2.assignment_id =
2721: asg.assignment_id)
2722: )
2723: or

Line 2726: from per_all_assignments_f asg2

2722: )
2723: or
2724: ((p_info.action_type = 'PRU' or p_info.action_type = 'Z')
2725: and asg.effective_start_date = (select max(asg2.effective_start_date)
2726: from per_all_assignments_f asg2
2727: where asg2.assignment_id =
2728: asg.assignment_id
2729: and asg2.effective_start_date <=
2730: p_info.action_date)

Line 2735: from per_all_assignments_f ASS2,

2731: )
2732: /* or
2733: (p_info.action_type = 'BEE'
2734: and asg.effective_start_date = (select max(ASS2.effective_start_date)
2735: from per_all_assignments_f ASS2,
2736: pay_batch_lines pbl
2737: where ASS2.assignment_id = asg.assignment_id
2738: and pbl.batch_id (+) = p_info.batch_id
2739: and pbl.assignment_id (+) = asg.assignment_id

Line 2755: from per_all_assignments_f asg,

2751: --
2752: cursor c1_bee is
2753: select act.assignment_action_id, -- Bug 6834017 ,Removed ordered hint
2754: asg.period_of_service_id
2755: from per_all_assignments_f asg,
2756: pay_assignment_actions act
2757: where act.payroll_action_id = p_info.pact_id
2758: and asg.assignment_id = act.assignment_id
2759: and act.source_action_id is null

Line 2762: from per_all_assignments_f ASS2,

2758: and asg.assignment_id = act.assignment_id
2759: and act.source_action_id is null
2760: and p_info.action_type = 'BEE'
2761: and asg.effective_start_date = (select max(ASS2.effective_start_date)
2762: from per_all_assignments_f ASS2,
2763: pay_batch_lines pbl
2764: where ASS2.assignment_id = asg.assignment_id
2765: and pbl.batch_id (+) = p_info.batch_id
2766: and pbl.assignment_id (+) = asg.assignment_id

Line 3075: per_all_assignments_f asg

3071: max(asg.person_id),
3072: 'U'
3073: from pay_payroll_actions pac,
3074: pay_assignment_actions act,
3075: per_all_assignments_f asg
3076: where pac.payroll_action_id = l_payroll_action_id
3077: and act.payroll_action_id = pac.payroll_action_id
3078: and asg.assignment_id = act.assignment_id
3079: group by pac.payroll_action_id;