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_AU_PAYMENT_SUMMARY dependencies on PER_PERIODS_OF_SERVICE

Line 694: INDEX(pps per_periods_of_service_n3)

690: select /*+ INDEX(p per_people_f_pk)
691: INDEX(a per_assignments_f_fk1)
692: INDEX(a per_assignments_f_N12)
693: INDEX(pa pay_payroll_actions_pk)
694: INDEX(pps per_periods_of_service_n3)
695: */ distinct a.assignment_id
696: from per_people_f p /*Bug3043049*/
697: ,per_assignments_f a /*Bug3043049*/
698: ,pay_payroll_actions pa

Line 699: ,per_periods_of_service pps

695: */ distinct a.assignment_id
696: from per_people_f p /*Bug3043049*/
697: ,per_assignments_f a /*Bug3043049*/
698: ,pay_payroll_actions pa
699: ,per_periods_of_service pps
700: where pa.payroll_action_id = c_payroll_action_id
701: and p.person_id between c_start_person_id and c_end_person_id
702: and p.person_id = a.person_id
703: and decode(pps.actual_termination_date,null,'Y',decode(sign(pps.actual_termination_date - (v_fin_year_end)),1,'Y','N')) LIKE v_employee_type --Bug#3744930

Line 781: ,per_periods_of_service pps

777: select distinct a.assignment_id
778: from per_people_f p /*Bug3043049*/
779: ,per_assignments_f a /*Bug3043049*/
780: ,pay_payroll_actions pa
781: ,per_periods_of_service pps
782: where pa.payroll_action_id = c_payroll_action_id
783: and p.person_id between c_start_person_id and c_end_person_id
784: and p.person_id = a.person_id
785: and decode(pps.actual_termination_date,null,'Y',decode(sign(pps.actual_termination_date - (v_fin_year_end)),1,'Y','N')) LIKE v_employee_type ----Bug#3744930

Line 870: INDEX(pps per_periods_of_service_PK)

866: SELECT /*+ INDEX(pap per_people_f_pk)
867: INDEX(rppa pay_payroll_actions_pk)
868: INDEX(ppr PAY_POPULATION_RANGES_N4)
869: INDEX(paa per_assignments_f_N12)
870: INDEX(pps per_periods_of_service_PK)
871: */ a.assignment_id
872: FROM per_people_f p /*Bug3043049*/
873: ,per_assignments_f a /*Bug3043049*/
874: ,pay_payroll_actions pa

Line 875: ,per_periods_of_service pps

871: */ a.assignment_id
872: FROM per_people_f p /*Bug3043049*/
873: ,per_assignments_f a /*Bug3043049*/
874: ,pay_payroll_actions pa
875: ,per_periods_of_service pps
876: ,pay_population_ranges ppr
877: WHERE pa.payroll_action_id = c_payroll_action_id
878: AND pa.payroll_action_id = ppr.payroll_action_id
879: AND ppr.chunk_number = c_chunk

Line 1746: ,per_periods_of_service pps

1742: ppa.date_earned date_earned,
1743: pee.assignment_id assignment_id,
1744: pac.tax_unit_id /* Added for bug #5846278 */
1745: FROM per_all_assignments_f paa
1746: ,per_periods_of_service pps
1747: ,pay_assignment_actions pac
1748: ,pay_payroll_actions ppa
1749: ,pay_element_entries_f pee
1750: ,pay_run_results prr

Line 2076: --, per_periods_of_service pps

2072: , per_all_assignments_f paa
2073: , pay_balance_types pbt
2074: , pay_defined_balances pdb
2075: --, pay_balance_dimensions pbd
2076: --, per_periods_of_service pps
2077: , pay_payroll_actions ppa
2078: , pay_assignment_actions pac
2079: , pay_run_results prr
2080: where pac.assignment_id = c_assignment_id

Line 2670: , per_periods_of_service pps

2666: , pay_element_types_f pet
2667: , pay_element_entries_f pee
2668: , pay_element_links_f pel
2669: , per_all_people_f pap
2670: , per_periods_of_service pps
2671: , per_all_assignments_f paa
2672: where pet.element_type_id = piv.element_type_id
2673: and pbf.input_value_id = piv.input_value_id
2674: and pbf.balance_type_id = pbt.balance_type_id

Line 2851: l_etp_employee_start_date per_periods_of_service.date_start%type;

2847: l_etp_postcode hr_locations.postal_code%type;
2848: l_etp_country fnd_territories_tl.territory_short_name%type;
2849: l_etp_employee_number per_all_people_f.employee_number%type;
2850: l_etp_date_of_birth per_all_people_f.date_of_birth%type;
2851: l_etp_employee_start_date per_periods_of_service.date_start%type;
2852: l_etp_death_benefit per_periods_of_service.leaving_reason%type;
2853: l_asgmnt_loc hr_locations.location_code%type;
2854: l_emp_no per_all_people_f.employee_number%type;
2855: l_payroll pay_all_payrolls_f.payroll_name%type;

Line 2852: l_etp_death_benefit per_periods_of_service.leaving_reason%type;

2848: l_etp_country fnd_territories_tl.territory_short_name%type;
2849: l_etp_employee_number per_all_people_f.employee_number%type;
2850: l_etp_date_of_birth per_all_people_f.date_of_birth%type;
2851: l_etp_employee_start_date per_periods_of_service.date_start%type;
2852: l_etp_death_benefit per_periods_of_service.leaving_reason%type;
2853: l_asgmnt_loc hr_locations.location_code%type;
2854: l_emp_no per_all_people_f.employee_number%type;
2855: l_payroll pay_all_payrolls_f.payroll_name%type;
2856: l_emp_type per_all_people_f.current_employee_flag%type;

Line 2901: per_periods_of_service pps,

2897: per_all_assignments_f paa,
2898: per_all_people_f pap,
2899: per_addresses pad,
2900: fnd_territories_tl fta,
2901: per_periods_of_service pps,
2902: pay_payroll_actions ppa,
2903: pay_assignment_actions pac,
2904: hr_locations_all hlc /* Bug No : 2263587 */
2905: where hou.business_group_id = c_business_group_id

Line 3156: ,p_actual_termination_date in per_periods_of_service.actual_termination_date%TYPE

3152: ,p_registered_employer in pay_assignment_actions.TAX_UNIT_ID%TYPE --2610141
3153: ,p_legislation_code in pay_defined_balances.legislation_code%TYPE
3154: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
3155: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
3156: ,p_actual_termination_date in per_periods_of_service.actual_termination_date%TYPE
3157: ,p_date_start in per_periods_of_service.date_start%TYPE
3158: ,p_year_start in pay_payroll_actions.effective_date%type
3159: ,p_year_end in pay_payroll_Actions.effective_date%type
3160: ,p_transitional_flag in varchar2 /*Bug 6192381 Added New Parameters p_transitional_flag and p_part_prev_etp_flag */

Line 3157: ,p_date_start in per_periods_of_service.date_start%TYPE

3153: ,p_legislation_code in pay_defined_balances.legislation_code%TYPE
3154: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
3155: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
3156: ,p_actual_termination_date in per_periods_of_service.actual_termination_date%TYPE
3157: ,p_date_start in per_periods_of_service.date_start%TYPE
3158: ,p_year_start in pay_payroll_actions.effective_date%type
3159: ,p_year_end in pay_payroll_Actions.effective_date%type
3160: ,p_transitional_flag in varchar2 /*Bug 6192381 Added New Parameters p_transitional_flag and p_part_prev_etp_flag */
3161: ,p_part_prev_etp_flag in varchar2) is

Line 3768: l_actual_termination_date per_periods_of_service.actual_termination_date%type;

3764: l_emp_type per_all_people_f.current_employee_flag%type;
3765: l_address_date_from date;
3766: l_date_earned pay_payroll_actions.date_earned%type;
3767: l_effective_date date; -- Bug3263659
3768: l_actual_termination_date per_periods_of_service.actual_termination_date%type;
3769: l_final_process_date date; -- Bug3263659
3770: l_fpd_archive VARCHAR2(20); -- Bug3098353
3771: l_le_start_date VARCHAR2(20);
3772: l_le_end_date VARCHAR2(20); -- Bug 2610141

Line 3873: per_periods_of_service pps,

3869: per_all_assignments_f paaf, /* Bug : 2610141 */
3870: per_all_people_f pap,
3871: per_addresses pad,
3872: fnd_territories_tl fta,
3873: per_periods_of_service pps,
3874: pay_payroll_actions ppa,
3875: pay_assignment_actions pac,
3876: pay_payroll_actions ppa1, /* Bug# 2448441 */
3877: pay_assignment_actions pac1 /* Bug# 2448441 */

Line 4573: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;

4569: l_year_start pay_payroll_Actions.effective_date%type;
4570: l_year_end pay_payroll_actions.effective_date%type;
4571: l_employee_type per_all_people_f.current_Employee_Flag%type;
4572: l_current_employee_flag per_all_people_f.current_employee_flag%type :='Y';
4573: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
4574: l_date_start per_periods_of_service.date_start%TYPE;
4575: l_asg_start pay_payroll_actions.effective_date%type;
4576: l_asg_end pay_payroll_actions.effective_date%type;
4577: l_effective_date pay_payroll_actions.effective_date%type;

Line 4574: l_date_start per_periods_of_service.date_start%TYPE;

4570: l_year_end pay_payroll_actions.effective_date%type;
4571: l_employee_type per_all_people_f.current_Employee_Flag%type;
4572: l_current_employee_flag per_all_people_f.current_employee_flag%type :='Y';
4573: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
4574: l_date_start per_periods_of_service.date_start%TYPE;
4575: l_asg_start pay_payroll_actions.effective_date%type;
4576: l_asg_end pay_payroll_actions.effective_date%type;
4577: l_effective_date pay_payroll_actions.effective_date%type;
4578: l_death_benefit_type varchar2(100);

Line 4586: l_fetched_termination_date per_periods_of_service.actual_termination_date%TYPE; --3263659

4582: l_fbt_assignment_action_id pay_assignment_actions.assignment_action_id%type; --2610141
4583: lump_sum_c_found boolean := false;
4584: l_final_process_date date; --263659
4585: l_term_date varchar2(10); --3263659
4586: l_fetched_termination_date per_periods_of_service.actual_termination_date%TYPE; --3263659
4587: l_reporting_flag varchar2(5) := 'YES'; --3098353
4588: l_bal_value varchar2(20); --3098353
4589: l_alw_bal_exist varchar2(20); --3098353
4590: l_lst_yr_term varchar2(10); --3661230

Line 4640: per_periods_of_service pps,

4636: to_number(substr(max(lpad(ppa.action_sequence,15,'0')||ppa.assignment_action_id),16)), --3755305
4637: pps.final_process_date final_process_date --3263659
4638: from per_all_people_f p,
4639: per_all_assignments_f a,
4640: per_periods_of_service pps,
4641: pay_all_payrolls_f papf, --4281290
4642: pay_payroll_actions pa,
4643: pay_assignment_actions ppa
4644: where a.person_id = p.person_id