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

Line 832: from per_all_assignments_f a,

828: -- fnd_number.canonical_to_number(substr(max(
829: fnd_number.canonical_to_number(substr((
830: lpad(paa.action_sequence,15,'0')||
831: paa.assignment_action_id),16)) assignment_action_id
832: from per_all_assignments_f a,
833: pay_assignment_actions paa,
834: pay_payroll_actions ppa,
835: pay_all_payrolls_f pay,
836: hr_soft_coding_keyflex flex

Line 838: FROM per_all_assignments_f a2,

834: pay_payroll_actions ppa,
835: pay_all_payrolls_f pay,
836: hr_soft_coding_keyflex flex
837: ,(SELECT a2.assignment_id, max(a2.effective_start_date) max_effective_start_date -- Bug 9292092
838: FROM per_all_assignments_f a2,
839: per_assignment_status_types past
840: WHERE /* a2.assignment_id = a.assignment_id
841: AND */ a2.effective_start_date <= c_agg_active_end
842: AND a2.effective_end_date >= c_agg_active_start

Line 869: -- FROM per_all_assignments_f a2,

865: order by (lpad(paa.action_sequence,15,'0')|| paa.assignment_action_id) desc;
866: -- 5144323: Ensure the action belongs to an assignment that shares continuous active
867: -- period of employement with the given terminated assignment
868: -- AND a.effective_start_date = (SELECT /*+ ORDERED */ max(a2.effective_start_date)
869: -- FROM per_all_assignments_f a2,
870: -- per_assignment_status_types past
871: -- WHERE a2.assignment_id = a.assignment_id
872: -- AND a2.effective_start_date <= to_date(c_agg_active_end, 'MM/DD/YYYY HH24:MI:SS')
873: -- AND a2.effective_end_date >= to_date(c_agg_active_start, 'MM/DD/YYYY HH24:MI:SS')

Line 1286: from per_all_assignments_f paf,

1282: is
1283: CURSOR csr_tax_ref (c_assignment_id in number,
1284: c_effective_end_date in date) is
1285: select scl.segment1
1286: from per_all_assignments_f paf,
1287: pay_all_payrolls_f ppf,
1288: hr_soft_coding_keyflex scl
1289: where paf.assignment_id = c_assignment_id
1290: and paf.payroll_id = ppf.payroll_id

Line 1352: from per_all_assignments_f paf,

1348: is
1349: CURSOR csr_tax_ref (c_assignment_id in number,
1350: c_effective_end_date in date) is
1351: select scl.segment1
1352: from per_all_assignments_f paf,
1353: pay_all_payrolls_f ppf,
1354: hr_soft_coding_keyflex scl
1355: where paf.assignment_id = c_assignment_id
1356: and paf.payroll_id = ppf.payroll_id

Line 1432: , per_all_assignments_f a

1428: , org.name org_name
1429: , p.date_of_birth /* P45 A4 2008/09 */
1430: , p.sex /* P45 A4 2008/09 */
1431: from per_all_people_f p
1432: , per_all_assignments_f a
1433: , per_periods_of_service serv
1434: , hr_all_organization_units org
1435: , fnd_sessions sess
1436: where a.assignment_id = p_assignment_id

Line 1698: 'per_all_assignments_f paaf '||

1694: -- Payroll ID has been used in param, restrict by this.
1695: hr_utility.set_location(l_proc,20);
1696: sqlstr := 'select distinct paaf.person_id '||
1697: 'from pay_payroll_actions ppa, '||
1698: 'per_all_assignments_f paaf '||
1699: 'where ppa.payroll_action_id = :payroll_action_id '||
1700: 'and paaf.business_group_id + 0 = ppa.business_group_id '||
1701: 'and paaf.payroll_id = '||to_char(l_payroll_id)||
1702: ' order by paaf.person_id';

Line 1909: from per_all_assignments_f paf,

1905: cursor csr_future_assignment (c_assignment_id in number,
1906: c_effective_end_date in date) is
1907: select 1 from dual where exists
1908: (select paf.effective_end_date
1909: from per_all_assignments_f paf,
1910: per_assignment_status_types past
1911: where past.assignment_status_type_id = paf.assignment_status_type_id
1912: and paf.assignment_id = c_assignment_id
1913: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 1948: from per_all_assignments_f paf,

1944: c_effective_end_date in date,
1945: c_tax_ref in varchar2) is
1946: select 1 from dual where exists
1947: (select scl.segment1
1948: from per_all_assignments_f paf,
1949: pay_all_payrolls_f ppf,
1950: hr_soft_coding_keyflex scl
1951: where paf.assignment_id = c_assignment_id
1952: and paf.payroll_id = ppf.payroll_id

Line 2020: from per_all_assignments_f paf,

2016: and paa.assignment_id = c_assignment_id
2017: and ppa.action_type in ('R','Q','V','I','B')
2018: and ptp.regular_payment_date =
2019: (select max(ptp.regular_payment_date)
2020: from per_all_assignments_f paf,
2021: per_time_periods ptp
2022: where ptp.regular_payment_date <= c_last_process_date
2023: and paf.assignment_id = c_assignment_id
2024: and ptp.payroll_id = paf.payroll_id

Line 2238: from per_all_assignments_f a,

2234: c_agg_start_date in date,
2235: c_agg_end_date in date) is
2236: select a.assignment_id,
2237: a.effective_end_date
2238: from per_all_assignments_f a,
2239: pay_all_payrolls_f pay,
2240: hr_soft_coding_keyflex flex,
2241: per_periods_of_service serv
2242: where a.person_id = c_person_id

Line 2254: FROM per_all_assignments_f a1,

2250: and a.period_of_service_id = c_period_of_service_id
2251: -- 5144323: only last active/suspended dt instances of the
2252: -- assignemnts are needed
2253: AND a.effective_end_date = ( SELECT max(effective_end_date)
2254: FROM per_all_assignments_f a1,
2255: per_assignment_status_types past
2256: WHERE a.assignment_id = a1.assignment_id
2257: AND a1.assignment_status_type_id = past.assignment_status_type_id
2258: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN'))

Line 2260: AND EXISTS (SELECT 1 FROM per_all_assignments_f a2

2256: WHERE a.assignment_id = a1.assignment_id
2257: AND a1.assignment_status_type_id = past.assignment_status_type_id
2258: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN'))
2259: -- 5144323: assignments must exist during the aggregation period
2260: AND EXISTS (SELECT 1 FROM per_all_assignments_f a2
2261: WHERE a.assignment_id = a2.assignment_id
2262: AND a2.effective_start_date <= c_agg_end_date
2263: AND a2.effective_end_date >= c_agg_start_date)
2264: -- 5144323: assignments must share continuous period of

Line 2267: FROM per_all_assignments_f a3,

2263: AND a2.effective_end_date >= c_agg_start_date)
2264: -- 5144323: assignments must share continuous period of
2265: -- employment with the input assignment
2266: AND EXISTS (SELECT 1
2267: FROM per_all_assignments_f a3,
2268: per_assignment_status_types past
2269: WHERE a.assignment_id = a3.assignment_id
2270: AND a3.assignment_status_type_id = past.assignment_status_type_id
2271: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 2287: per_all_assignments_f a,

2283: decode(p.per_information10,'Y','Y',NULL) agg_paye_flag,
2284: max(a.effective_end_date) asg_end_date,
2285: ptp.regular_payment_date
2286: FROM per_all_people_f p,
2287: per_all_assignments_f a,
2288: per_assignment_status_types past,
2289: pay_all_payrolls_f ppf,
2290: per_time_periods ptp,
2291: per_periods_of_service serv,

Line 2311: -- from per_all_assignments_f asg2,

2307: AND g_effective_date >= a.effective_start_date -- added by kvinayku for bug 14206931,15971584
2308:
2309: -- AND a.effective_end_date = -- the latest active or susp asg exclude DT update
2310: -- (select max(asg2.effective_end_date)
2311: -- from per_all_assignments_f asg2,
2312: -- per_assignment_status_types past
2313: -- where asg2.assignment_id = a.assignment_id
2314: -- and asg2.assignment_status_type_id =past.assignment_status_type_id
2315: -- and past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')

Line 2346: per_all_assignments_f a,

2342: max(a.effective_end_date) asg_end_date,
2343: ptp.regular_payment_date
2344: FROM pay_population_ranges ppr,
2345: per_all_people_f p,
2346: per_all_assignments_f a,
2347: per_assignment_status_types past,
2348: pay_all_payrolls_f ppf,
2349: per_time_periods ptp,
2350: per_periods_of_service serv,

Line 2373: -- from per_all_assignments_f asg2,

2369: AND g_effective_date >= a.effective_start_date -- added by kvinayku for bug 14206931,15971584
2370:
2371: --AND a.effective_end_date = -- the latest active or susp asg exclude DT update
2372: -- (select max(asg2.effective_end_date)
2373: -- from per_all_assignments_f asg2,
2374: -- per_assignment_status_types past
2375: -- where asg2.assignment_id = a.assignment_id
2376: -- and asg2.assignment_status_type_id =
2377: -- past.assignment_status_type_id

Line 3225: per_all_assignments_f ass

3221: FROM
3222: per_all_people_f p,
3223: hr_all_organization_units org,
3224: per_periods_of_service serv,
3225: per_all_assignments_f ass
3226: WHERE ass.assignment_id = p_assid
3227: AND serv.period_of_service_id = ass.period_of_service_id
3228: AND ass.effective_end_date = p_term_date
3229: AND ass.organization_id = org.organization_id

Line 4807: from per_all_assignments_f asg1, per_all_assignments_f asg2

4803: ) IS
4804: --
4805: Cursor csr_get_all_asg(c_assignment_id NUMBER) IS
4806: select distinct asg1.assignment_id, asg1.person_id
4807: from per_all_assignments_f asg1, per_all_assignments_f asg2
4808: where asg2.assignment_id = c_assignment_id
4809: and asg2.person_id = asg1.person_id
4810: and asg1.assignment_id <> p_assignment_id;
4811:

Line 4842: FROM per_all_assignments_f paaf,

4838: */
4839:
4840: Cursor csr_get_paye_ref(c_assignment_id NUMBER, c_effective_date DATE) IS
4841: SELECT flex.segment1 paye_ref, paaf.period_of_service_id
4842: FROM per_all_assignments_f paaf,
4843: pay_all_payrolls_f papf,
4844: hr_soft_coding_keyflex flex
4845: WHERE paaf.assignment_id = c_assignment_id
4846: AND c_effective_date between paaf.effective_start_date and paaf.effective_end_date

Line 4857: from per_all_assignments_f a,

4853: c_tax_ref in varchar2,
4854: c_effective_date date
4855: ) is
4856: select 1
4857: from per_all_assignments_f a,
4858: per_assignment_status_types past
4859: where a.assignment_status_type_id = past.assignment_status_type_id
4860: and past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
4861: and a.assignment_id = c_assignment_id

Line 4878: from per_all_assignments_f a,

4874: -- to fetch the last active/susp status date for the given assignment
4875: --
4876: cursor csr_asg_last_active_date(c_assignment_id number) is
4877: select max(effective_end_date)
4878: from per_all_assignments_f a,
4879: per_assignment_status_types past
4880: where a.assignment_id = c_assignment_id
4881: and a.assignment_status_type_id = past.assignment_status_type_id
4882: and past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');

Line 4900: from per_all_assignments_f a

4896: -- the earliest aggregation start date and final payment date
4897: --
4898: cursor csr_asg_present_status(c_assignment_id number, c_start_date date, c_end_date date) is
4899: select 1
4900: from per_all_assignments_f a
4901: where a.assignment_id = c_assignment_id
4902: and a.effective_end_date >= c_start_date
4903: and a.effective_start_date <= c_end_date;
4904: