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 767: from per_all_assignments_f a,

763: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
764: fnd_number.canonical_to_number(substr(max(
765: lpad(paa.action_sequence,15,'0')||
766: paa.assignment_action_id),16)) assignment_action_id
767: from per_all_assignments_f a,
768: pay_assignment_actions paa,
769: pay_payroll_actions ppa,
770: pay_all_payrolls_f pay,
771: hr_soft_coding_keyflex flex

Line 791: FROM per_all_assignments_f a2,

787: and ppa.action_type in ('R', 'Q', 'I', 'V', 'B')
788: -- 5144323: Ensure the action belongs to an assignment that shares continuous active
789: -- period of employement with the given terminated assignment
790: AND a.effective_start_date = (SELECT /*+ ORDERED use_nl(past a2) */ max(a2.effective_start_date)
791: FROM per_all_assignments_f a2,
792: per_assignment_status_types past
793: WHERE a2.assignment_id = a.assignment_id
794: AND a2.effective_start_date <= c_agg_active_end
795: AND a2.effective_end_date >= c_agg_active_start

Line 1179: from per_all_assignments_f paf,

1175: is
1176: CURSOR csr_tax_ref (c_assignment_id in number,
1177: c_effective_end_date in date) is
1178: select scl.segment1
1179: from per_all_assignments_f paf,
1180: pay_all_payrolls_f ppf,
1181: hr_soft_coding_keyflex scl
1182: where paf.assignment_id = c_assignment_id
1183: and paf.payroll_id = ppf.payroll_id

Line 1244: from per_all_assignments_f paf,

1240: is
1241: CURSOR csr_tax_ref (c_assignment_id in number,
1242: c_effective_end_date in date) is
1243: select scl.segment1
1244: from per_all_assignments_f paf,
1245: pay_all_payrolls_f ppf,
1246: hr_soft_coding_keyflex scl
1247: where paf.assignment_id = c_assignment_id
1248: and paf.payroll_id = ppf.payroll_id

Line 1318: , per_all_assignments_f a

1314: , a.payroll_id
1315: , org.organization_id
1316: , org.name org_name
1317: from per_all_people_f p
1318: , per_all_assignments_f a
1319: , per_periods_of_service serv
1320: , hr_all_organization_units org
1321: , fnd_sessions sess
1322: where a.assignment_id = p_assignment_id

Line 1581: 'per_all_assignments_f paaf '||

1577: -- Payroll ID has been used in param, restrict by this.
1578: hr_utility.set_location(l_proc,20);
1579: sqlstr := 'select distinct paaf.person_id '||
1580: 'from pay_payroll_actions ppa, '||
1581: 'per_all_assignments_f paaf '||
1582: 'where ppa.payroll_action_id = :payroll_action_id '||
1583: 'and paaf.business_group_id + 0 = ppa.business_group_id '||
1584: 'and paaf.payroll_id = '||to_char(l_payroll_id)||
1585: ' order by paaf.person_id';

Line 1792: from per_all_assignments_f paf,

1788: cursor csr_future_assignment (c_assignment_id in number,
1789: c_effective_end_date in date) is
1790: select 1 from dual where exists
1791: (select paf.effective_end_date
1792: from per_all_assignments_f paf,
1793: per_assignment_status_types past
1794: where past.assignment_status_type_id = paf.assignment_status_type_id
1795: and paf.assignment_id = c_assignment_id
1796: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 1829: from per_all_assignments_f paf,

1825: c_effective_end_date in date,
1826: c_tax_ref in varchar2) is
1827: select 1 from dual where exists
1828: (select scl.segment1
1829: from per_all_assignments_f paf,
1830: pay_all_payrolls_f ppf,
1831: hr_soft_coding_keyflex scl
1832: where paf.assignment_id = c_assignment_id
1833: and paf.payroll_id = ppf.payroll_id

Line 1898: from per_all_assignments_f paf,

1894: and paa.assignment_id = c_assignment_id
1895: and ppa.action_type in ('R','Q','V','I','B')
1896: and ptp.regular_payment_date =
1897: (select max(ptp.regular_payment_date)
1898: from per_all_assignments_f paf,
1899: per_time_periods ptp
1900: where ptp.regular_payment_date <= c_last_process_date
1901: and paf.assignment_id = c_assignment_id
1902: and ptp.payroll_id = paf.payroll_id

Line 2111: from per_all_assignments_f a,

2107: c_agg_start_date in date,
2108: c_agg_end_date in date) is
2109: select a.assignment_id,
2110: a.effective_end_date
2111: from per_all_assignments_f a,
2112: pay_all_payrolls_f pay,
2113: hr_soft_coding_keyflex flex,
2114: per_periods_of_service serv
2115: where a.person_id = c_person_id

Line 2127: FROM per_all_assignments_f a1,

2123: and a.period_of_service_id = c_period_of_service_id
2124: -- 5144323: only last active/suspended dt instances of the
2125: -- assignemnts are needed
2126: AND a.effective_end_date = ( SELECT max(effective_end_date)
2127: FROM per_all_assignments_f a1,
2128: per_assignment_status_types past
2129: WHERE a.assignment_id = a1.assignment_id
2130: AND a1.assignment_status_type_id = past.assignment_status_type_id
2131: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN'))

Line 2133: AND EXISTS (SELECT 1 FROM per_all_assignments_f a2

2129: WHERE a.assignment_id = a1.assignment_id
2130: AND a1.assignment_status_type_id = past.assignment_status_type_id
2131: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN'))
2132: -- 5144323: assignments must exist during the aggregation period
2133: AND EXISTS (SELECT 1 FROM per_all_assignments_f a2
2134: WHERE a.assignment_id = a2.assignment_id
2135: AND a2.effective_start_date <= c_agg_end_date
2136: AND a2.effective_end_date >= c_agg_start_date)
2137: -- 5144323: assignments must share continuous period of

Line 2140: FROM per_all_assignments_f a3,

2136: AND a2.effective_end_date >= c_agg_start_date)
2137: -- 5144323: assignments must share continuous period of
2138: -- employment with the input assignment
2139: AND EXISTS (SELECT 1
2140: FROM per_all_assignments_f a3,
2141: per_assignment_status_types past
2142: WHERE a.assignment_id = a3.assignment_id
2143: AND a3.assignment_status_type_id = past.assignment_status_type_id
2144: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 2160: per_all_assignments_f a,

2156: decode(p.per_information10,'Y','Y',NULL) agg_paye_flag,
2157: max(a.effective_end_date) asg_end_date,
2158: ptp.regular_payment_date
2159: FROM per_all_people_f p,
2160: per_all_assignments_f a,
2161: per_assignment_status_types past,
2162: pay_all_payrolls_f ppf,
2163: per_time_periods ptp,
2164: per_periods_of_service serv,

Line 2183: -- from per_all_assignments_f asg2,

2179: AND a.effective_end_date <= g_end_date -- before run end date
2180:
2181: -- AND a.effective_end_date = -- the latest active or susp asg exclude DT update
2182: -- (select max(asg2.effective_end_date)
2183: -- from per_all_assignments_f asg2,
2184: -- per_assignment_status_types past
2185: -- where asg2.assignment_id = a.assignment_id
2186: -- and asg2.assignment_status_type_id =past.assignment_status_type_id
2187: -- and past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')

Line 2215: per_all_assignments_f a,

2211: max(a.effective_end_date) asg_end_date,
2212: ptp.regular_payment_date
2213: FROM pay_population_ranges ppr,
2214: per_all_people_f p,
2215: per_all_assignments_f a,
2216: per_assignment_status_types past,
2217: pay_all_payrolls_f ppf,
2218: per_time_periods ptp,
2219: per_periods_of_service serv,

Line 2241: -- from per_all_assignments_f asg2,

2237: AND a.effective_end_date <= g_end_date -- before run end date
2238:
2239: --AND a.effective_end_date = -- the latest active or susp asg exclude DT update
2240: -- (select max(asg2.effective_end_date)
2241: -- from per_all_assignments_f asg2,
2242: -- per_assignment_status_types past
2243: -- where asg2.assignment_id = a.assignment_id
2244: -- and asg2.assignment_status_type_id =
2245: -- past.assignment_status_type_id

Line 2859: per_all_assignments_f ass

2855: FROM
2856: per_all_people_f p,
2857: hr_all_organization_units org,
2858: per_periods_of_service serv,
2859: per_all_assignments_f ass
2860: WHERE ass.assignment_id = p_assid
2861: AND serv.period_of_service_id = ass.period_of_service_id
2862: AND ass.effective_end_date = p_term_date
2863: AND ass.organization_id = org.organization_id

Line 4000: from per_all_assignments_f asg1, per_all_assignments_f asg2

3996: ) IS
3997: --
3998: Cursor csr_get_all_asg(c_assignment_id NUMBER) IS
3999: select distinct asg1.assignment_id, asg1.person_id
4000: from per_all_assignments_f asg1, per_all_assignments_f asg2
4001: where asg2.assignment_id = c_assignment_id
4002: and asg2.person_id = asg1.person_id
4003: and asg1.assignment_id <> p_assignment_id;
4004:

Line 4035: FROM per_all_assignments_f paaf,

4031: */
4032:
4033: Cursor csr_get_paye_ref(c_assignment_id NUMBER, c_effective_date DATE) IS
4034: SELECT flex.segment1 paye_ref, paaf.period_of_service_id
4035: FROM per_all_assignments_f paaf,
4036: pay_all_payrolls_f papf,
4037: hr_soft_coding_keyflex flex
4038: WHERE paaf.assignment_id = c_assignment_id
4039: AND c_effective_date between paaf.effective_start_date and paaf.effective_end_date

Line 4050: from per_all_assignments_f a,

4046: c_tax_ref in varchar2,
4047: c_effective_date date
4048: ) is
4049: select 1
4050: from per_all_assignments_f a,
4051: per_assignment_status_types past
4052: where a.assignment_status_type_id = past.assignment_status_type_id
4053: and past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
4054: and a.assignment_id = c_assignment_id

Line 4071: from per_all_assignments_f a,

4067: -- to fetch the last active/susp status date for the given assignment
4068: --
4069: cursor csr_asg_last_active_date(c_assignment_id number) is
4070: select max(effective_end_date)
4071: from per_all_assignments_f a,
4072: per_assignment_status_types past
4073: where a.assignment_id = c_assignment_id
4074: and a.assignment_status_type_id = past.assignment_status_type_id
4075: and past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');

Line 4093: from per_all_assignments_f a

4089: -- the earliest aggregation start date and final payment date
4090: --
4091: cursor csr_asg_present_status(c_assignment_id number, c_start_date date, c_end_date date) is
4092: select 1
4093: from per_all_assignments_f a
4094: where a.assignment_id = c_assignment_id
4095: and a.effective_end_date >= c_start_date
4096: and a.effective_start_date <= c_end_date;
4097: