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_IE_P45_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 918: per_all_assignments_f pasf

914:
915: cursor cur_sep_name_dob(p_bg_id NUMBER) is
916: select papf.date_of_birth,papf.first_name, papf.last_name
917: from per_all_people_f papf,
918: per_all_assignments_f pasf
919: where pasf.assignment_id = p_assignment_id
920: and p_date_earned between
921: pasf.effective_start_date and pasf.effective_end_date
922: and pasf.business_group_id = p_bg_id

Line 933: from per_all_assignments_f

929: select paa.assignment_action_id pay_assg_act_id
930: from pay_assignment_actions paa,
931: pay_payroll_actions ppa
932: where paa.assignment_id in (select assignment_id
933: from per_all_assignments_f
934: where person_id = p_person_id
935: )
936: and paa.tax_unit_id = g_paye_ref
937: and paa.payroll_action_id = ppa.payroll_action_id

Line 969: from per_all_assignments_f

965: select max(paa.assignment_action_id)
966: from pay_assignment_actions paa,
967: pay_payroll_actions ppa
968: where paa.assignment_id in (select assignment_id
969: from per_all_assignments_f
970: where person_id = p_person_id
971: )
972: and paa.tax_unit_id = g_paye_ref
973: and paa.payroll_action_id = ppa.payroll_action_id

Line 1062: from per_all_assignments_f papf

1058: pay_assignment_actions pas,
1059: pay_payroll_actions ppa
1060: WHERE substr(pac.Context_Value,1,4) = p_context_value
1061: AND pac.assignment_id in (select papf.assignment_id
1062: from per_all_assignments_f papf
1063: where papf.person_id = p_person_id
1064: )
1065: AND pas.tax_unit_id = g_paye_ref
1066: AND pas.assignment_action_id = pac.assignment_action_id

Line 1083: from per_all_assignments_f papf

1079: where paa1.source_action_id = p_last_p45_act
1080: and pai.locking_action_id = paa1.assignment_action_id
1081: and pai.locked_action_id = paa.assignment_action_id
1082: and paa.assignment_id in (select papf.assignment_id
1083: from per_all_assignments_f papf
1084: where papf.person_id = p_person_id
1085: )
1086: and paa.tax_unit_id = g_paye_ref
1087: and paa.payroll_action_id = ppa.payroll_action_id

Line 1640: from per_all_assignments_f papf

1636: where paa1.source_action_id = p_last_p45_action
1637: and pai.locking_action_id = paa1.assignment_action_id
1638: and pai.locked_action_id = paa.assignment_action_id
1639: and paa.assignment_id in (select papf.assignment_id
1640: from per_all_assignments_f papf
1641: where papf.person_id = p_person_id
1642: )
1643: and paa.tax_unit_id = g_paye_ref
1644: and paa.payroll_action_id = ppa.payroll_action_id

Line 1671: from per_all_assignments_f papf

1667: pay_assignment_actions pas,
1668: pay_payroll_actions ppa
1669: WHERE pac.Context_Value like 'IE_A%'
1670: AND pac.assignment_id in (select papf.assignment_id
1671: from per_all_assignments_f papf
1672: where papf.person_id = p_person_id
1673: )
1674: AND pas.tax_unit_id = g_paye_ref
1675: AND pas.assignment_action_id = pac.assignment_action_id

Line 1734: from per_all_assignments_f paaf, per_assignment_extra_info paei

1730: pay_assignment_actions pas,
1731: pay_payroll_actions ppa
1732: WHERE pac.Context_Value like 'IE_A%'
1733: AND pac.assignment_id in (select paaf.assignment_id
1734: from per_all_assignments_f paaf, per_assignment_extra_info paei
1735: where paaf.person_id = p_person_id
1736: and paaf.assignment_id=paei.assignment_id
1737: and paei.information_type = 'IE_ASG_OVERRIDE'
1738: and paei.aei_information1 = c_ppsn_override

Line 2637: from per_all_assignments_f paf,

2633: ppos.actual_termination_date
2634: from per_periods_of_service ppos
2635: where ppos.person_id = p_person_id
2636: and ppos.period_of_service_id = (select max(paf.period_of_service_id)
2637: from per_all_assignments_f paf,
2638: pay_assignment_actions paa,
2639: pay_action_interlocks pai
2640: where pai.locking_action_id = p_action_context_id
2641: and pai.locked_action_id = paa.assignment_action_id

Line 2648: FROM per_all_assignments_f paaf,

2644: );
2645:
2646: CURSOR cur_max_end_date IS
2647: SELECT max(paaf.effective_end_date)
2648: FROM per_all_assignments_f paaf,
2649: pay_all_payrolls_f papf,
2650: hr_soft_coding_keyflex scl
2651: WHERE paaf.person_id = p_person_id
2652: AND paaf.payroll_id = papf.payroll_id

Line 2666: FROM per_all_assignments_f paaf

2662: /* changed the cursor to handle case where 2 user defined assignment status exist mapping to
2663: same per_system_status (5073577) */
2664: CURSOR cur_get_asg_end_date IS
2665: SELECT max(effective_end_date)
2666: FROM per_all_assignments_f paaf
2667: WHERE paaf.assignment_id = p_assignment_id
2668: AND paaf.assignment_status_type_id in
2669: (SELECT ast.assignment_status_type_id
2670: FROM per_assignment_status_types ast

Line 2811: from per_all_assignments_f paf,

2807: ppos.actual_termination_date
2808: from per_periods_of_service ppos
2809: where ppos.person_id = p_person_id
2810: and ppos.period_of_service_id = (select max(paf.period_of_service_id)
2811: from per_all_assignments_f paf,
2812: pay_assignment_actions paa,
2813: pay_action_interlocks pai
2814: where pai.locking_action_id = p_action_context_id
2815: and pai.locked_action_id = paa.assignment_action_id

Line 2823: per_all_assignments_f paf

2819: /*
2820: SELECT decode(ppos.leaving_reason, 'D','Y','N'),
2821: ppos.actual_termination_date
2822: FROM per_periods_of_service ppos,
2823: per_all_assignments_f paf
2824: WHERE paf.assignment_id = p_assignment_id
2825: AND ppos.period_of_service_id = paf.period_of_service_id;
2826: */
2827: /* changed the cursor to handle case where 2 user defined assignment status exist mapping to

Line 2831: FROM per_all_assignments_f paaf,

2827: /* changed the cursor to handle case where 2 user defined assignment status exist mapping to
2828: same per_system_status (5073577) */
2829: CURSOR cur_max_end_date IS
2830: SELECT max(paaf.effective_end_date)
2831: FROM per_all_assignments_f paaf,
2832: pay_all_payrolls_f papf,
2833: hr_soft_coding_keyflex scl
2834: WHERE paaf.person_id = p_person_id
2835: AND paaf.payroll_id = papf.payroll_id

Line 2849: FROM per_all_assignments_f paaf

2845: /* changed the cursor to handle case where 2 user defined assignment status exist mapping to
2846: same per_system_status (5073577) */
2847: CURSOR cur_get_asg_end_date IS
2848: SELECT max(effective_end_date)
2849: FROM per_all_assignments_f paaf
2850: WHERE paaf.assignment_id = p_assignment_id
2851: AND paaf.assignment_status_type_id in
2852: (SELECT ast.assignment_status_type_id
2853: FROM per_assignment_status_types ast

Line 2874: from per_all_assignments_f paf,

2870: ptpt.number_per_fiscal_year,
2871: ptpr.periods_per_period,
2872: ptp.start_date,
2873: ptp.end_date
2874: from per_all_assignments_f paf,
2875: per_time_periods ptp,
2876: per_time_period_types ptpt,
2877: per_time_period_rules ptpr
2878: where paf.assignment_id = p_assignment_id

Line 2901: from per_all_assignments_f

2897: pay_input_values_f piv,
2898: pay_assignment_actions pas,
2899: pay_payroll_actions ppa
2900: where pas.assignment_id in (select assignment_id
2901: from per_all_assignments_f
2902: where person_id = p_person_id)
2903: and pas.tax_unit_id = g_paye_ref
2904: and pas.payroll_action_id = ppa.payroll_action_id
2905: and to_char(ppa.effective_date,'YYYY') = to_char(p_date_earned,'YYYY')

Line 2924: from per_all_assignments_f

2920: and pai.action_context_type = 'AAP'
2921: and pai.action_information_category = 'IE P45 INFORMATION'
2922: and paa.tax_unit_id = g_paye_ref
2923: and paa.assignment_id in ( select assignment_id
2924: from per_all_assignments_f
2925: where person_id = p_person_id
2926: )
2927: and to_date(pai.action_information3) = l_termination_date;
2928: -- and fnd_date.canonical_to_date(pai.action_information3) = l_termination_date;

Line 3330: FROM per_all_assignments_f paf

3326: CURSOR csr_check_archive( cp_payroll_action_id number
3327: ,cp_payroll_id number
3328: ,cp_effective_date date) IS
3329: SELECT DISTINCT paf.organization_id
3330: FROM per_all_assignments_f paf
3331: WHERE paf.payroll_id = cp_payroll_id
3332: AND cp_effective_date between paf.effective_start_date
3333: AND paf.effective_end_date
3334: AND NOT EXISTS (

Line 3640: per_all_assignments_f as1,

3636: act1.assignment_action_id prepaid_action_id,
3637: as1.assignment_number works_number,
3638: as1.period_of_service_id period_of_service_id
3639: FROM --per_periods_of_service ppos,
3640: per_all_assignments_f as1,
3641: pay_assignment_actions act,
3642: pay_payroll_actions appa,
3643: pay_action_interlocks pai,
3644: pay_assignment_actions act1,

Line 3653: from per_all_assignments_f paf1

3649: AND as1.person_id BETWEEN stperson AND endperson
3650: /* Assignment End Date should be between archive start date and end date */
3651: AND as1.effective_end_date between g_archive_start_date AND g_archive_end_date
3652: AND (as1.effective_end_date = (select max(effective_end_date)
3653: from per_all_assignments_f paf1
3654: where paf1.assignment_id = as1.assignment_id
3655: /* changed the cursor to handle case where 2 user defined assignment status exist mapping to
3656: same per_system_status (5073577) */
3657: and paf1.assignment_status_type_id in

Line 3676: from per_all_assignments_f paf1

3672: and a.effective_start_date <= g_archive_end_date
3673: -- and a.effective_end_date >= trunc(g_archive_end_date,'Y') -- bug 6144761
3674: -- 5758951
3675: and a.effective_end_date = (select max(effective_end_date)
3676: from per_all_assignments_f paf1
3677: where paf1.assignment_id = a.assignment_id
3678: and paf1.assignment_status_type_id in
3679: (SELECT ast.assignment_status_type_id
3680: FROM per_assignment_status_types ast

Line 3721: from per_all_assignments_f paaf

3717: where pai.locked_action_id= act3.assignment_action_id
3718: and pai.locking_action_id=act2.assignment_action_id
3719: and act3.action_sequence >= act1.action_sequence --bug 4193738
3720: and act3.assignment_id in (select distinct paaf.assignment_id
3721: from per_all_assignments_f paaf
3722: where paaf.person_id = as1.person_id
3723: )
3724: and act3.tax_unit_id = act1.tax_unit_id
3725: and act3.action_status IN ('C','S') --10225372

Line 3735: FROM per_all_assignments_f paf,

3731: and appa3.report_type = 'P45')
3732: /* check person does not hold employment with the employer between start of year and archive end date */
3733: AND NOT EXISTS (
3734: SELECT MIN(paf.effective_start_date),MAX(paf.effective_end_date)
3735: FROM per_all_assignments_f paf,
3736: pay_all_payrolls_f papf,
3737: hr_soft_coding_keyflex scl
3738: WHERE paf.person_id = as1.person_id
3739: AND paf.payroll_id = papf.payroll_id

Line 3775: (select 1 from per_all_assignments_f paaf

3771: from per_assignment_extra_info paei
3772: where paei.information_type = 'IE_ASG_OVERRIDE'
3773: and paei.aei_information1 = p_ppsn_override
3774: and exists
3775: (select 1 from per_all_assignments_f paaf
3776: where paaf.assignment_id = paei.assignment_id
3777: and paaf.person_id = p_person_id)
3778: GROUP BY paei.aei_information1;
3779:

Line 3982: from per_all_assignments_f

3978: FROM pay_assignment_actions paa,
3979: pay_payroll_actions ppa
3980: WHERE paa.payroll_action_id = ppa.payroll_action_id
3981: AND paa.assignment_id in (select assignment_id
3982: from per_all_assignments_f
3983: where person_id = p_person_id
3984: )
3985: AND paa.tax_unit_id = g_paye_ref
3986: AND (paa.source_action_id is not null or ppa.action_type in ('I','V','B'))

Line 4049: FROM per_all_assignments_f

4045: -- cursor to retrieve payroll id
4046: CURSOR cur_assgn_payroll(p_assignment_id NUMBER,
4047: p_date_earned DATE) IS
4048: SELECT payroll_id,person_id,period_of_service_id
4049: FROM per_all_assignments_f
4050: WHERE assignment_id = p_assignment_id
4051: AND p_date_earned
4052: BETWEEN effective_start_date AND effective_end_date;
4053:

Line 4076: from per_all_assignments_f paaf, per_assignment_extra_info paei

4072: FROM pay_assignment_actions paa,
4073: pay_payroll_actions ppa
4074: WHERE paa.payroll_action_id = ppa.payroll_action_id
4075: AND paa.assignment_id in (select paaf.assignment_id
4076: from per_all_assignments_f paaf, per_assignment_extra_info paei
4077: where paaf.person_id = p_person_id
4078: and paaf.assignment_id=paei.assignment_id
4079: and paei.information_type = 'IE_ASG_OVERRIDE'
4080: and paei.aei_information1 = c_ppsn_override --'314678745T'

Line 4735: CURSOR cur_p45_supp_details (p_assignment_id per_all_assignments_f.assignment_id%TYPE,

4731: AND emp_paye.assignment_action_id = p_assignment_action_id;
4732: cur_p45_paye_prsi_rec cur_p45_paye_prsi_details%ROWTYPE;
4733: --
4734: --Bug 3991416 Added period,frequency and date earned check to fetch single record
4735: CURSOR cur_p45_supp_details (p_assignment_id per_all_assignments_f.assignment_id%TYPE,
4736: p_date_earned date,
4737: p_period NUMBER,
4738: p_freq VARCHAR2) IS
4739: SELECT (round(to_number(emp_supp.total_tax),2)*100) supp_totaltax

Line 4788: from per_all_assignments_f paf,

4784: select 'Y'
4785: from per_periods_of_service ppos
4786: where ppos.person_id = c_person_id
4787: and ppos.period_of_service_id = (select max(paf.period_of_service_id)
4788: from per_all_assignments_f paf,
4789: pay_assignment_actions paa,
4790: pay_action_interlocks pai
4791: where pai.locking_action_id = c_action_context_id
4792: and pai.locked_action_id = paa.assignment_action_id