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_P35 dependencies on PER_ASSIGNMENTS_F

Line 106: from per_assignments_f paaf, per_assignments_f paaf1

102: l_actid pay_assignment_actions.assignment_action_id%TYPE;
103:
104: cursor csr_check_multiple_asg IS
105: select paaf.person_id
106: from per_assignments_f paaf, per_assignments_f paaf1
107: where paaf.assignment_id= p_assignment_id
108: and paaf.business_group_id = p_bg_id
109: and paaf.business_group_id =paaf1.business_group_id
110: and paaf.person_id = paaf1.person_id

Line 117: FROM per_assignments_f paf,

113: and paaf1.effective_start_date <= p_end_date;
114:
115: cursor csr_get_max_assact is
116: SELECT MAX(paa.assignment_action_id)
117: FROM per_assignments_f paf,
118: pay_assignment_actions paa,
119: pay_payroll_actions ppa,
120: per_time_periods ptp
121: WHERE paf.person_id = l_person_id

Line 241: per_assignments_f asg,

237: asg.primary_flag,
238: paa.assignment_action_id,
239: trim(rrv1.result_value) result_value
240: FROM per_people_f per,
241: per_assignments_f asg,
242: pay_assignment_actions paa,
243: pay_payroll_actions ppa,
244: per_time_periods ptp,
245: pay_run_results prr,

Line 264: FROM per_assignments_f asg2,

260: AND per2.current_employee_flag = 'Y' )
261: AND asg.person_id = per.person_id
262: AND asg.effective_start_date =
263: (SELECT MIN (asg2.effective_start_date)
264: FROM per_assignments_f asg2,
265: per_assignment_status_types ast
266: WHERE asg2.assignment_id = asg.assignment_id
267: AND asg2.effective_start_date <= p_end_date
268: AND NVL (asg2.effective_end_date, p_end_date) >= p_start_date

Line 731: per_assignments_f asg,

727: --
728: hr_utility.set_location ('End Date 3',22);
729: sqlstr := 'select distinct asg.person_id
730: from per_periods_of_service pos,
731: per_assignments_f asg,
732: pay_payroll_actions ppa
733: where ppa.payroll_action_id = :payroll_action_id
734: and pos.person_id = asg.person_id
735: and pos.period_of_service_id = asg.period_of_service_id

Line 800: FROM per_assignments_f asg,

796: SELECT /*+ ORDERED USE_NL(asg, paa, ppa, ptp, flex) push_subq */
797: asg.person_id,
798: paa.assignment_id,
799: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) aa -- Bug 4672715
800: FROM per_assignments_f asg,
801: pay_assignment_actions paa,
802: pay_payroll_actions ppa,
803: pay_all_payrolls_f pap,
804: per_time_periods ptp,

Line 829: FROM per_assignments_f paf,

825: AND asg.person_id BETWEEN stperson AND endperson
826: --decode added to pick the previous assignments also in case of ReHire having diff overrides.
827: AND asg.effective_end_date = DECODE(OVERRIDE_PPSN(asg.assignment_id),NULL, --6633719
828: (SELECT MAX (paf.effective_end_date)
829: FROM per_assignments_f paf,
830: pay_assignment_actions paa1, --Bug fix 4130665
831: pay_payroll_actions ppa1,
832: per_time_periods ptp1 --Tar 15081088.6
833: ,pay_all_payrolls_f pay

Line 867: AND (pap.payroll_id in (select b.payroll_id from per_assignments_f a,per_assignments_f b

863: -- Bug 4142582
864: AND flex.segment4 = l_segment4
865: AND pap.effective_start_date <= l_end_date
866: AND pap.effective_end_date >= l_start_date
867: AND (pap.payroll_id in (select b.payroll_id from per_assignments_f a,per_assignments_f b
868: where a.payroll_id = l_payroll_id
869: and a.person_id = b.person_id
870: and a.person_id = asg.person_id
871: --bug 6642916

Line 880: , per_assignments_f paf

876: AND ((l_assignment_set_id is not null
877: AND (l_set_flag ='I' AND EXISTS(SELECT 1
878: FROM hr_assignment_set_amendments hasa
879: , hr_assignment_sets has
880: , per_assignments_f paf
881: -- , pay_all_payrolls_f pay
882: -- , hr_soft_coding_keyflex hflex
883: WHERE has.assignment_set_id = hasa.assignment_set_id
884: AND has.business_group_id = l_bg_id

Line 894: , per_assignments_f paf

890: --AND hflex.segment4 = l_segment4)
891: OR l_set_flag = 'E' AND NOT EXISTS(SELECT 1
892: FROM hr_assignment_set_amendments hasa
893: , hr_assignment_sets has
894: , per_assignments_f paf
895: -- , pay_all_payrolls_f pay
896: -- , hr_soft_coding_keyflex hflex
897: WHERE has.assignment_set_id = hasa.assignment_set_id
898: AND has.business_group_id = l_bg_id

Line 911: per_assignments_f paaf_p35,

907: AND NOT EXISTS (
908: SELECT 1
909: FROM pay_assignment_actions paa_p35,
910: pay_payroll_actions ppa_p35,
911: per_assignments_f paaf_p35,
912: pay_all_payrolls_f ppf_p35,
913: hr_soft_coding_keyflex flex_p35,
914: pay_action_interlocks plock
915: WHERE ppa_p35.report_type = 'IEP35'

Line 1171: l_arch_person_id per_assignments_f.person_id%TYPE;

1167: l_arch_ppsn pay_action_information.action_information4%TYPE;
1168: l_arch_works_number pay_action_information.action_information14%TYPE
1169: DEFAULT ' '; --BUG 3306202 Added default value
1170: l_segment4 hr_soft_coding_keyflex.segment4%TYPE;
1171: l_arch_person_id per_assignments_f.person_id%TYPE;
1172: l_arch_assignment_id pay_assignment_actions.assignment_id%TYPE;
1173: l_arch_assmt_action_id_bal pay_assignment_actions.assignment_action_id%TYPE;
1174: l_arch_tax_deduction_basis pay_action_information.action_information17%TYPE;
1175: l_arch_surname pay_action_information.action_information29%TYPE;

Line 1220: l_asg_id per_assignments_f.assignment_id%TYPE;

1216: -- Temporary variable to hold values when Class K or M exists
1217: l_temp_prsi_cont pay_action_information.action_information4%TYPE := NULL;
1218: l_oth_arch_ovn pay_action_information.object_version_number%TYPE;
1219: l_pds_id per_periods_of_service.period_of_service_id%TYPE;
1220: l_asg_id per_assignments_f.assignment_id%TYPE;
1221: l_aact_id pay_assignment_actions.assignment_action_id%TYPE;
1222: l_max_act_for_bal pay_assignment_actions.assignment_action_id%TYPE;
1223: l_set_flag hr_assignment_set_amendments.include_or_exclude%TYPE ;
1224: l_arch_primary_flag per_assignments_f.primary_flag%TYPE;

Line 1224: l_arch_primary_flag per_assignments_f.primary_flag%TYPE;

1220: l_asg_id per_assignments_f.assignment_id%TYPE;
1221: l_aact_id pay_assignment_actions.assignment_action_id%TYPE;
1222: l_max_act_for_bal pay_assignment_actions.assignment_action_id%TYPE;
1223: l_set_flag hr_assignment_set_amendments.include_or_exclude%TYPE ;
1224: l_arch_primary_flag per_assignments_f.primary_flag%TYPE;
1225: v_primary_flag per_assignments_f.primary_flag%TYPE;
1226: -- pension variables
1227: l_arch_pen_emp_rbs pay_action_information.action_information30%TYPE;
1228: l_arch_pen_empr_rbs pay_action_information.action_information30%TYPE;

Line 1225: v_primary_flag per_assignments_f.primary_flag%TYPE;

1221: l_aact_id pay_assignment_actions.assignment_action_id%TYPE;
1222: l_max_act_for_bal pay_assignment_actions.assignment_action_id%TYPE;
1223: l_set_flag hr_assignment_set_amendments.include_or_exclude%TYPE ;
1224: l_arch_primary_flag per_assignments_f.primary_flag%TYPE;
1225: v_primary_flag per_assignments_f.primary_flag%TYPE;
1226: -- pension variables
1227: l_arch_pen_emp_rbs pay_action_information.action_information30%TYPE;
1228: l_arch_pen_empr_rbs pay_action_information.action_information30%TYPE;
1229: l_arch_pen_emp_prsa pay_action_information.action_information30%TYPE;

Line 1429: per_assignments_f paf,

1425: ) -- Q1_Previous_Emp_Tax
1426: FROM pay_action_information pact_edi,
1427: pay_action_information pact_iedi,
1428: pay_action_information pact_ad,
1429: per_assignments_f paf,
1430: per_periods_of_service pps,
1431: -- pay_ie_paye_details_f payef,
1432: per_time_periods ptp,
1433: per_people_f ppf

Line 1450: FROM per_assignments_f asg

1446: AND paf.assignment_id = pact_ad.assignment_id
1447: --AND paf.primary_flag = 'Y'
1448: AND paf.effective_end_date =
1449: (SELECT MAX (asg.effective_end_date)
1450: FROM per_assignments_f asg
1451: WHERE asg.assignment_id = paf.assignment_id
1452: AND asg.effective_start_date <=
1453: l_end_date --pay_ie_p35.get_start_date()
1454: AND asg.effective_end_date >=

Line 1636: per_assignments_f paf,

1632: FROM pay_action_interlocks pai,
1633: pay_assignment_actions paa,
1634: per_people_f ppf,
1635: per_periods_of_service pps,
1636: per_assignments_f paf,
1637: per_addresses pad,
1638: -- pay_ie_paye_details_f payef, --Bug 4154171
1639: pay_all_payrolls_f papf,
1640: pay_payroll_actions ppa

Line 1655: FROM per_assignments_f asg

1651: AND pad.person_id(+) = paf.person_id
1652: AND NVL (pad.primary_flag, 'Y') = 'Y'
1653: AND paf.effective_end_date =
1654: (SELECT MAX (asg.effective_end_date)
1655: FROM per_assignments_f asg
1656: WHERE asg.assignment_id = paf.assignment_id
1657: AND asg.effective_start_date <= l_end_date
1658: AND asg.effective_end_date >= l_start_date)
1659: AND ppf.effective_end_date =

Line 1839: per_assignments_f paf,

1835: ) -- Q1_Previous_Emp_Tax
1836: FROM pay_assignment_actions paa,
1837: per_people_f ppf,
1838: per_periods_of_service pps,
1839: per_assignments_f paf,
1840: per_addresses pad,
1841: -- pay_ie_paye_details_f payef,
1842: pay_all_payrolls_f papf,
1843: pay_payroll_actions ppa

Line 1856: FROM per_assignments_f asg

1852: AND pad.person_id(+) = paf.person_id
1853: AND NVL (pad.primary_flag, 'Y') = 'Y'
1854: AND paf.effective_end_date =
1855: (SELECT MAX (asg.effective_end_date)
1856: FROM per_assignments_f asg
1857: WHERE asg.assignment_id = paf.assignment_id
1858: AND asg.effective_start_date <= l_end_date
1859: AND asg.effective_end_date >= l_start_date)
1860: AND ppf.effective_end_date =

Line 1915: FROM per_assignments_f paf,

1911: ),
1912: 0) --Bug 4111753
1913: /*( NVL(paye.weekly_tax_credit,0) +
1914: NVL(paye.Monthly_tax_credit,0)) * ptp.period_num */
1915: FROM per_assignments_f paf,
1916: per_time_periods ptp,
1917: pay_ie_paye_details_f paye
1918: WHERE paf.assignment_id = p_assignment_id
1919: AND paye.assignment_id=paf.assignment_id

Line 1987: ,per_assignments_f asg

1983: and l_end_date
1984: ORDER BY actual_termination_date desc; */
1985: SELECT max(pps.period_of_service_id)
1986: FROM per_periods_of_service pps
1987: ,per_assignments_f asg
1988: ,pay_all_payrolls_f pay
1989: ,hr_soft_coding_keyflex flex
1990: WHERE pps.person_id = v_person_id
1991: AND pps.person_id = asg.person_id

Line 2003: FROM per_assignments_f

1999: AND l_end_date;
2000:
2001: /*CURSOR c_get_terminated_asg(p_pds_id NUMBER) IS
2002: SELECT assignment_id
2003: FROM per_assignments_f
2004: WHERE period_of_service_id = p_pds_id
2005: AND primary_flag = 'Y';*/
2006:
2007: CURSOR c_get_max_aact(p_pds_id NUMBER) IS

Line 2013: FROM per_assignments_f

2009: FROM pay_assignment_Actions paa,
2010: pay_payroll_actions ppa
2011: -- ,per_time_periods ptp -- removed to improve performance 4771780
2012: WHERE paa.assignment_id in (SELECT assignment_id
2013: FROM per_assignments_f
2014: WHERE period_of_service_id = p_pds_id)
2015: AND paa.payroll_action_id = ppa.payroll_action_id
2016: AND ppa.action_type IN ('R','Q','I','B','V')
2017: AND paa.action_status = 'C'

Line 2034: from per_assignments_f paf,

2030: -- for bug 5301598, increased the size to 12
2031: select NVL (SUBSTR (paf.assignment_number, 1, 12), ' '), -- WORKS NUMBER
2032: paf.primary_flag,
2033: paf.assignment_id
2034: from per_assignments_f paf,
2035: pay_assignment_actions paa
2036: where paf.assignment_id = paa.assignment_id
2037: and paa.assignment_action_id = p_action_id
2038: and paf.effective_start_date <= l_end_date

Line 2049: from per_assignments_f paf,

2045: select NVL (SUBSTR (paf.assignment_number, 1, 12), ' '), -- WORKS NUMBER
2046: paf.primary_flag,
2047: paf.assignment_id,
2048: max(effective_end_date) end_date
2049: from per_assignments_f paf,
2050: pay_assignment_actions paa
2051: where paf.assignment_id = paa.assignment_id
2052: and paa.assignment_action_id = p_action_id
2053: and paf.effective_start_date <= l_end_date

Line 2062: from per_assignments_f paf, per_assignment_extra_info paei

2058: --6633719
2059: /* Cursor to fetch primary flag for terminated assignments for PPSN OVERRIDE case*/
2060: CURSOR csr_get_primary_flag1(p_ppsn_override varchar2) is
2061: select NVL (SUBSTR (paf.assignment_number, 1, 12), ' ') -- WORKS NUMBER
2062: from per_assignments_f paf, per_assignment_extra_info paei
2063: where paf.assignment_id = paei.assignment_id
2064: and aei_information1 = p_ppsn_override
2065: and paf.effective_start_date <= l_end_date
2066: and paf.effective_end_date >= l_start_date

Line 2073: from per_assignments_f paf,

2069:
2070: /* Cursor to fetch primary flag for active assignments PPSN OVERRIDE case*/
2071: CURSOR csr_get_primary_flag_active1(p_ppsn_override varchar2) is
2072: select NVL (SUBSTR (paf.assignment_number, 1, 12), ' ') -- WORKS NUMBER
2073: from per_assignments_f paf,
2074: per_assignment_extra_info paei
2075: where paf.assignment_id = paei.assignment_id
2076: and aei_information1 = p_ppsn_override
2077: and paf.effective_start_date <= l_end_date

Line 2088: v_work_number per_assignments_f.assignment_number%TYPE;

2084:
2085: cnt number;
2086: v_action_type pay_payroll_actions.action_type%TYPE;
2087: v_report_type pay_payroll_actions.report_type%TYPE;
2088: v_work_number per_assignments_f.assignment_number%TYPE;
2089: v_assignment_id pay_assignment_actions.assignment_id%TYPE;
2090: v_action_id pay_assignment_actions.assignment_action_id%TYPE;
2091: v_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
2092: v_chunk pay_assignment_actions.chunk_number%TYPE;

Line 2093: l_max_assignment_id per_assignments_f.assignment_id%TYPE;

2089: v_assignment_id pay_assignment_actions.assignment_id%TYPE;
2090: v_action_id pay_assignment_actions.assignment_action_id%TYPE;
2091: v_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
2092: v_chunk pay_assignment_actions.chunk_number%TYPE;
2093: l_max_assignment_id per_assignments_f.assignment_id%TYPE;
2094: v_date date;
2095: asg_assignment_id per_assignments_f.assignment_id%TYPE;
2096: l_max_action_id pay_assignment_actions.assignment_action_id%TYPE;
2097: l_cnt number;

Line 2095: asg_assignment_id per_assignments_f.assignment_id%TYPE;

2091: v_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
2092: v_chunk pay_assignment_actions.chunk_number%TYPE;
2093: l_max_assignment_id per_assignments_f.assignment_id%TYPE;
2094: v_date date;
2095: asg_assignment_id per_assignments_f.assignment_id%TYPE;
2096: l_max_action_id pay_assignment_actions.assignment_action_id%TYPE;
2097: l_cnt number;
2098: -- for P60 enhancement.
2099: l_prev_pay pay_action_information.action_information4%TYPE;

Line 4675: per_assignments_f paf,

4671: SELECT /*+ ORDERED USE_NL(paa, ppa, ptp)
4672: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
4673: paa.assignment_action_id),16)) assignment_action_id --bug fix 4004470
4674: FROM per_people_f ppf,
4675: per_assignments_f paf,
4676: pay_assignment_actions paa,
4677: pay_payroll_actions ppa,
4678: per_time_periods ptp
4679: WHERE

Line 4720: per_assignments_f asg,

4716: asg.primary_flag,
4717: paa.assignment_action_id,
4718: trim(rrv1.result_value) result_value
4719: FROM per_people_f per,
4720: per_assignments_f asg,
4721: pay_assignment_actions paa,
4722: pay_payroll_actions ppa,
4723: per_time_periods ptp,
4724: pay_run_results prr,

Line 4753: FROM per_assignments_f asg2,

4749: AND per2.current_employee_flag = 'Y' )
4750: AND asg.person_id = per.person_id
4751: AND asg.effective_start_date =
4752: (SELECT MIN (asg2.effective_start_date)
4753: FROM per_assignments_f asg2,
4754: per_assignment_status_types ast --Bug fix 3828506
4755: WHERE asg2.assignment_id = asg.assignment_id
4756: AND asg2.effective_start_date <= p_end_date
4757: AND NVL (asg2.effective_end_date, p_end_date) >= p_start_date

Line 4840: per_assignments_f asg,

4836: '0'
4837: )
4838: ) class_name
4839: FROM per_people_f per,
4840: per_assignments_f asg,
4841: pay_assignment_actions paa,
4842: pay_payroll_actions ppa,
4843: per_time_periods ptp,
4844: pay_run_results prr,

Line 4870: FROM per_assignments_f asg2,

4866: WHERE ast.per_system_status ='ACTIVE_ASSIGN'
4867: AND ast.assignment_status_type_id = asg.assignment_status_type_id)
4868: AND asg.effective_start_date =
4869: (SELECT MIN (asg2.effective_start_date)
4870: FROM per_assignments_f asg2,
4871: per_assignment_status_types ast --For bug fix 3828506
4872: WHERE asg2.assignment_id = asg.assignment_id
4873: AND asg2.effective_start_date <= p_end_date
4874: AND NVL (asg2.effective_end_date, p_end_date) >= p_start_date

Line 5185: FROM per_assignments_f asg

5181: NVL (piw.insurable_weeks, 0)
5182: FROM pay_ie_p35_insurable_weeks_v piw
5183: WHERE piw.person_id =
5184: (SELECT asg.person_id
5185: FROM per_assignments_f asg
5186: WHERE asg.assignment_id = p_assignment_id
5187: AND asg.effective_start_date =
5188: (SELECT MIN (asg2.effective_start_date)
5189: FROM per_assignments_f asg2

Line 5189: FROM per_assignments_f asg2

5185: FROM per_assignments_f asg
5186: WHERE asg.assignment_id = p_assignment_id
5187: AND asg.effective_start_date =
5188: (SELECT MIN (asg2.effective_start_date)
5189: FROM per_assignments_f asg2
5190: WHERE asg.assignment_id =
5191: asg2.assignment_id))
5192: AND piw.insurable_weeks =
5193: (SELECT MAX (piw2.insurable_weeks)

Line 5675: p_assignment_id per_assignments_f.assignment_id%TYPE,

5671: RETURN l_end_date;
5672: END get_end_date;
5673:
5674: Function check_assignment_in_set(
5675: p_assignment_id per_assignments_f.assignment_id%TYPE,
5676: p_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE,
5677: p_business_group per_assignments_f.business_group_id%TYPE
5678: ) return NUMBER
5679: AS

Line 5677: p_business_group per_assignments_f.business_group_id%TYPE

5673:
5674: Function check_assignment_in_set(
5675: p_assignment_id per_assignments_f.assignment_id%TYPE,
5676: p_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE,
5677: p_business_group per_assignments_f.business_group_id%TYPE
5678: ) return NUMBER
5679: AS
5680: CURSOR csr_locked_asg_sets
5681: is