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 718: per_all_assignments_f pasf

714:
715: cursor cur_sep_name_dob(p_bg_id NUMBER) is
716: select papf.date_of_birth,papf.first_name, papf.last_name
717: from per_all_people_f papf,
718: per_all_assignments_f pasf
719: where pasf.assignment_id = p_assignment_id
720: and p_date_earned between
721: pasf.effective_start_date and pasf.effective_end_date
722: and pasf.business_group_id = p_bg_id

Line 733: from per_all_assignments_f

729: select paa.assignment_action_id pay_assg_act_id
730: from pay_assignment_actions paa,
731: pay_payroll_actions ppa
732: where paa.assignment_id in (select assignment_id
733: from per_all_assignments_f
734: where person_id = p_person_id
735: )
736: and paa.tax_unit_id = g_paye_ref
737: and paa.payroll_action_id = ppa.payroll_action_id

Line 769: from per_all_assignments_f

765: select max(paa.assignment_action_id)
766: from pay_assignment_actions paa,
767: pay_payroll_actions ppa
768: where paa.assignment_id in (select assignment_id
769: from per_all_assignments_f
770: where person_id = p_person_id
771: )
772: and paa.tax_unit_id = g_paye_ref
773: and paa.payroll_action_id = ppa.payroll_action_id

Line 849: from per_all_assignments_f papf

845: pay_assignment_actions pas,
846: pay_payroll_actions ppa
847: WHERE substr(pac.Context_Value,1,4) = p_context_value
848: AND pac.assignment_id in (select papf.assignment_id
849: from per_all_assignments_f papf
850: where papf.person_id = p_person_id
851: )
852: AND pas.tax_unit_id = g_paye_ref
853: AND pas.assignment_action_id = pac.assignment_action_id

Line 870: from per_all_assignments_f papf

866: where paa1.source_action_id = p_last_p45_act
867: and pai.locking_action_id = paa1.assignment_action_id
868: and pai.locked_action_id = paa.assignment_action_id
869: and paa.assignment_id in (select papf.assignment_id
870: from per_all_assignments_f papf
871: where papf.person_id = p_person_id
872: )
873: and paa.tax_unit_id = g_paye_ref
874: and paa.payroll_action_id = ppa.payroll_action_id

Line 1376: from per_all_assignments_f papf

1372: where paa1.source_action_id = p_last_p45_action
1373: and pai.locking_action_id = paa1.assignment_action_id
1374: and pai.locked_action_id = paa.assignment_action_id
1375: and paa.assignment_id in (select papf.assignment_id
1376: from per_all_assignments_f papf
1377: where papf.person_id = p_person_id
1378: )
1379: and paa.tax_unit_id = g_paye_ref
1380: and paa.payroll_action_id = ppa.payroll_action_id

Line 1407: from per_all_assignments_f papf

1403: pay_assignment_actions pas,
1404: pay_payroll_actions ppa
1405: WHERE pac.Context_Value like 'IE_A%'
1406: AND pac.assignment_id in (select papf.assignment_id
1407: from per_all_assignments_f papf
1408: where papf.person_id = p_person_id
1409: )
1410: AND pas.tax_unit_id = g_paye_ref
1411: AND pas.assignment_action_id = pac.assignment_action_id

Line 1970: from per_all_assignments_f paf,

1966: ppos.actual_termination_date
1967: from per_periods_of_service ppos
1968: where ppos.person_id = p_person_id
1969: and ppos.period_of_service_id = (select max(paf.period_of_service_id)
1970: from per_all_assignments_f paf,
1971: pay_assignment_actions paa,
1972: pay_action_interlocks pai
1973: where pai.locking_action_id = p_action_context_id
1974: and pai.locked_action_id = paa.assignment_action_id

Line 1981: FROM per_all_assignments_f paaf,

1977: );
1978:
1979: CURSOR cur_max_end_date IS
1980: SELECT max(paaf.effective_end_date)
1981: FROM per_all_assignments_f paaf,
1982: pay_all_payrolls_f papf,
1983: hr_soft_coding_keyflex scl
1984: WHERE paaf.person_id = p_person_id
1985: AND paaf.payroll_id = papf.payroll_id

Line 1999: FROM per_all_assignments_f paaf

1995: /* changed the cursor to handle case where 2 user defined assignment status exist mapping to
1996: same per_system_status (5073577) */
1997: CURSOR cur_get_asg_end_date IS
1998: SELECT max(effective_end_date)
1999: FROM per_all_assignments_f paaf
2000: WHERE paaf.assignment_id = p_assignment_id
2001: AND paaf.assignment_status_type_id in
2002: (SELECT ast.assignment_status_type_id
2003: FROM per_assignment_status_types ast

Line 2144: from per_all_assignments_f paf,

2140: ppos.actual_termination_date
2141: from per_periods_of_service ppos
2142: where ppos.person_id = p_person_id
2143: and ppos.period_of_service_id = (select max(paf.period_of_service_id)
2144: from per_all_assignments_f paf,
2145: pay_assignment_actions paa,
2146: pay_action_interlocks pai
2147: where pai.locking_action_id = p_action_context_id
2148: and pai.locked_action_id = paa.assignment_action_id

Line 2156: per_all_assignments_f paf

2152: /*
2153: SELECT decode(ppos.leaving_reason, 'D','Y','N'),
2154: ppos.actual_termination_date
2155: FROM per_periods_of_service ppos,
2156: per_all_assignments_f paf
2157: WHERE paf.assignment_id = p_assignment_id
2158: AND ppos.period_of_service_id = paf.period_of_service_id;
2159: */
2160: /* changed the cursor to handle case where 2 user defined assignment status exist mapping to

Line 2164: FROM per_all_assignments_f paaf,

2160: /* changed the cursor to handle case where 2 user defined assignment status exist mapping to
2161: same per_system_status (5073577) */
2162: CURSOR cur_max_end_date IS
2163: SELECT max(paaf.effective_end_date)
2164: FROM per_all_assignments_f paaf,
2165: pay_all_payrolls_f papf,
2166: hr_soft_coding_keyflex scl
2167: WHERE paaf.person_id = p_person_id
2168: AND paaf.payroll_id = papf.payroll_id

Line 2182: FROM per_all_assignments_f paaf

2178: /* changed the cursor to handle case where 2 user defined assignment status exist mapping to
2179: same per_system_status (5073577) */
2180: CURSOR cur_get_asg_end_date IS
2181: SELECT max(effective_end_date)
2182: FROM per_all_assignments_f paaf
2183: WHERE paaf.assignment_id = p_assignment_id
2184: AND paaf.assignment_status_type_id in
2185: (SELECT ast.assignment_status_type_id
2186: FROM per_assignment_status_types ast

Line 2207: from per_all_assignments_f paf,

2203: ptpt.number_per_fiscal_year,
2204: ptpr.periods_per_period,
2205: ptp.start_date,
2206: ptp.end_date
2207: from per_all_assignments_f paf,
2208: per_time_periods ptp,
2209: per_time_period_types ptpt,
2210: per_time_period_rules ptpr
2211: where paf.assignment_id = p_assignment_id

Line 2234: from per_all_assignments_f

2230: pay_input_values_f piv,
2231: pay_assignment_actions pas,
2232: pay_payroll_actions ppa
2233: where pas.assignment_id in (select assignment_id
2234: from per_all_assignments_f
2235: where person_id = p_person_id)
2236: and pas.tax_unit_id = g_paye_ref
2237: and pas.payroll_action_id = ppa.payroll_action_id
2238: and to_char(ppa.effective_date,'YYYY') = to_char(p_date_earned,'YYYY')

Line 2257: from per_all_assignments_f

2253: and pai.action_context_type = 'AAP'
2254: and pai.action_information_category = 'IE P45 INFORMATION'
2255: and paa.tax_unit_id = g_paye_ref
2256: and paa.assignment_id in ( select assignment_id
2257: from per_all_assignments_f
2258: where person_id = p_person_id
2259: )
2260: and to_date(pai.action_information3) = l_termination_date;
2261: -- and fnd_date.canonical_to_date(pai.action_information3) = l_termination_date;

Line 2624: FROM per_all_assignments_f paf

2620: CURSOR csr_check_archive( cp_payroll_action_id number
2621: ,cp_payroll_id number
2622: ,cp_effective_date date) IS
2623: SELECT DISTINCT paf.organization_id
2624: FROM per_all_assignments_f paf
2625: WHERE paf.payroll_id = cp_payroll_id
2626: AND cp_effective_date between paf.effective_start_date
2627: AND paf.effective_end_date
2628: AND NOT EXISTS (

Line 2932: per_all_assignments_f as1,

2928: act1.assignment_action_id prepaid_action_id,
2929: as1.assignment_number works_number,
2930: as1.period_of_service_id period_of_service_id
2931: FROM --per_periods_of_service ppos,
2932: per_all_assignments_f as1,
2933: pay_assignment_actions act,
2934: pay_payroll_actions appa,
2935: pay_action_interlocks pai,
2936: pay_assignment_actions act1,

Line 2945: from per_all_assignments_f paf1

2941: AND as1.person_id BETWEEN stperson AND endperson
2942: /* Assignment End Date should be between archive start date and end date */
2943: AND as1.effective_end_date between g_archive_start_date AND g_archive_end_date
2944: AND (as1.effective_end_date = (select max(effective_end_date)
2945: from per_all_assignments_f paf1
2946: where paf1.assignment_id = as1.assignment_id
2947: /* changed the cursor to handle case where 2 user defined assignment status exist mapping to
2948: same per_system_status (5073577) */
2949: and paf1.assignment_status_type_id in

Line 2968: from per_all_assignments_f paf1

2964: and a.effective_start_date <= g_archive_end_date
2965: -- and a.effective_end_date >= trunc(g_archive_end_date,'Y') -- bug 6144761
2966: -- 5758951
2967: and a.effective_end_date = (select max(effective_end_date)
2968: from per_all_assignments_f paf1
2969: where paf1.assignment_id = a.assignment_id
2970: and paf1.assignment_status_type_id in
2971: (SELECT ast.assignment_status_type_id
2972: FROM per_assignment_status_types ast

Line 3013: from per_all_assignments_f paaf

3009: where pai.locked_action_id= act3.assignment_action_id
3010: and pai.locking_action_id=act2.assignment_action_id
3011: and act3.action_sequence >= act1.action_sequence --bug 4193738
3012: and act3.assignment_id in (select distinct paaf.assignment_id
3013: from per_all_assignments_f paaf
3014: where paaf.person_id = as1.person_id
3015: )
3016: and act3.tax_unit_id = act1.tax_unit_id
3017: and act3.action_status = 'C'

Line 3027: FROM per_all_assignments_f paf,

3023: and appa3.report_type = 'P45')
3024: /* check person does not hold employment with the employer between start of year and archive end date */
3025: AND NOT EXISTS (
3026: SELECT MIN(paf.effective_start_date),MAX(paf.effective_end_date)
3027: FROM per_all_assignments_f paf,
3028: pay_all_payrolls_f papf,
3029: hr_soft_coding_keyflex scl
3030: WHERE paf.person_id = as1.person_id
3031: AND paf.payroll_id = papf.payroll_id

Line 3213: from per_all_assignments_f

3209: FROM pay_assignment_actions paa,
3210: pay_payroll_actions ppa
3211: WHERE paa.payroll_action_id = ppa.payroll_action_id
3212: AND paa.assignment_id in (select assignment_id
3213: from per_all_assignments_f
3214: where person_id = p_person_id
3215: )
3216: AND paa.tax_unit_id = g_paye_ref
3217: AND (paa.source_action_id is not null or ppa.action_type in ('I','V','B'))

Line 3277: FROM per_all_assignments_f

3273: -- cursor to retrieve payroll id
3274: CURSOR cur_assgn_payroll(p_assignment_id NUMBER,
3275: p_date_earned DATE) IS
3276: SELECT payroll_id,person_id,period_of_service_id
3277: FROM per_all_assignments_f
3278: WHERE assignment_id = p_assignment_id
3279: AND p_date_earned
3280: BETWEEN effective_start_date AND effective_end_date;
3281:

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

3795: AND emp_paye.assignment_action_id = p_assignment_action_id;
3796: cur_p45_paye_prsi_rec cur_p45_paye_prsi_details%ROWTYPE;
3797: --
3798: --Bug 3991416 Added period,frequency and date earned check to fetch single record
3799: CURSOR cur_p45_supp_details (p_assignment_id per_all_assignments_f.assignment_id%TYPE,
3800: p_date_earned date,
3801: p_period NUMBER,
3802: p_freq VARCHAR2) IS
3803: SELECT (round(to_number(emp_supp.total_tax),2)*100) supp_totaltax