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.PYUDET dependencies on PER_ALL_ASSIGNMENTS_F

Line 256: per_all_assignments_f asg,

252: peo.effective_start_date,
253: peo.effective_end_date,
254: scl.segment1 -- Bug#8497477
255: from per_all_people_f peo,
256: per_all_assignments_f asg,
257: per_periods_of_service pps,
258: per_person_type_usages_f ptu,
259: per_person_types ppt,
260: pay_all_payrolls_f ppf, -- Bug#8497477

Line 339: from per_all_assignments_f asg,

335: pay.payroll_id,
336: assignment_number,
337: per_system_status asg_status,
338: sck.segment1 tax_ref
339: from per_all_assignments_f asg,
340: pay_all_payrolls_f pay,
341: per_assignment_status_types pat,
342: hr_soft_coding_keyflex sck
343: where asg.person_id = p_person_id

Line 402: from per_all_assignments_f asg,

398: -- This cursor is for Checking active and suspended assignments at the time of process run -- /*Added soy 08-09*/
399: -----------------------------------------------------------------------------------------------
400: CURSOR get_cpe_flag(p_person_id number, p_paye_ref varchar2, p_date date ) IS
401: select assignment_id
402: from per_all_assignments_f asg,
403: pay_all_payrolls_f pay,
404: per_assignment_status_types pat,
405: hr_soft_coding_keyflex sck
406: where asg.person_id = p_person_id

Line 518: from PER_ALL_ASSIGNMENTS_F paaf,

514: -- This cursor is for Checking assignment is teminated in future --
515: -------------------------------------------------------------------
516: CURSOR get_future_term_date(p_assignment_id number, p_effective_date date ) IS
517: select effective_start_date
518: from PER_ALL_ASSIGNMENTS_F paaf,
519: per_assignment_status_types past
520: where paaf.effective_start_date >= p_effective_date
521: and paaf.assignment_id = p_assignment_id
522: and paaf.assignment_status_type_id =past.assignment_status_type_id

Line 530: from PER_ALL_ASSIGNMENTS_F paaf

526: -- This cursor is for Checking assignment is ended in future --
527: -------------------------------------------------------------------
528: CURSOR get_future_end_asg_date(p_assignment_id number, p_effective_date date ) IS
529: select max(effective_end_date)
530: from PER_ALL_ASSIGNMENTS_F paaf
531: where paaf.effective_end_date >= p_effective_date
532: and paaf.assignment_id = p_assignment_id
533: and paaf.business_group_id = g_business_group_id;
534:

Line 2027: per_all_assignments_f asg,

2023: pps.actual_termination_date,
2024: pps.last_standard_process_date,
2025: p_m34_rec.effective_date
2026: from per_all_people_f peo,
2027: per_all_assignments_f asg,
2028: per_periods_of_service pps
2029: where asg.business_group_id = g_business_group_id
2030: and peo.business_group_id = g_business_group_id
2031: and peo.person_id = asg.person_id

Line 2069: per_all_assignments_f asg,

2065: pps.actual_termination_date,
2066: pps.last_standard_process_date,
2067: p_m34_rec.effective_date
2068: from per_all_people_f peo,
2069: per_all_assignments_f asg,
2070: per_periods_of_service pps
2071: where asg.business_group_id = g_business_group_id
2072: and peo.business_group_id = g_business_group_id
2073: and peo.person_id = asg.person_id

Line 2107: per_all_assignments_f asg,

2103: pps.actual_termination_date,
2104: pps.last_standard_process_date,
2105: p_m34_rec.effective_date
2106: from per_all_people_f peo,
2107: per_all_assignments_f asg,
2108: per_periods_of_service pps
2109: where asg.business_group_id = g_business_group_id
2110: and peo.business_group_id = g_business_group_id
2111: and peo.person_id = asg.person_id

Line 2145: per_all_assignments_f asg,

2141: pps.actual_termination_date,
2142: pps.last_standard_process_date,
2143: p_m34_rec.effective_date
2144: from per_all_people_f peo,
2145: per_all_assignments_f asg,
2146: per_periods_of_service pps
2147: where asg.business_group_id = g_business_group_id
2148: and peo.business_group_id = g_business_group_id
2149: and peo.person_id = asg.person_id

Line 2177: from per_all_assignments_f asg,

2173: p_person_id number,
2174: p_date date,
2175: p_asg_no varchar2 default null) is
2176: select count(*)
2177: from per_all_assignments_f asg,
2178: pay_all_payrolls_f pay,
2179: hr_soft_coding_keyflex sck
2180: where asg.person_id = p_person_id
2181: and asg.payroll_id = pay.payroll_id

Line 2195: per_all_assignments_f asg,

2191: p_person_id number,
2192: p_date date) is
2193: select count(*)
2194: from per_all_people_f peo,
2195: per_all_assignments_f asg,
2196: pay_all_payrolls_f pay,
2197: hr_soft_coding_keyflex sck
2198: where peo.person_id = p_person_id
2199: and asg.person_id = peo.person_id

Line 2208: from per_all_assignments_f asg,

2204: and asg.effective_start_date > p_date
2205: and p_date between pay.effective_start_date and pay.effective_end_date
2206: and asg.effective_start_date between peo.effective_start_date and peo.effective_end_date
2207: and asg.assignment_id not in (select assignment_id
2208: from per_all_assignments_f asg,
2209: pay_all_payrolls_f pay,
2210: hr_soft_coding_keyflex sck
2211: where asg.person_id = p_person_id
2212: and asg.payroll_id = pay.payroll_id

Line 2517: per_all_assignments_f paaf,

2513: select paaf.assignment_number,
2514: paaf.assignment_id,
2515: nvl(papf.per_information10,'N')
2516: from per_assignment_extra_info paei,
2517: per_all_assignments_f paaf,
2518: per_assignment_status_types pat,
2519: per_all_people_f papf
2520: where paei.AEI_INFORMATION_CATEGORY = 'GB_RTI_AGGREGATION'
2521: and paei.AEI_INFORMATION3 = p_m34_rec.assignment_number

Line 2531: from per_all_assignments_f paaf,

2527: and p_m34_rec.effective_date between papf.effective_start_date and papf.effective_end_date
2528: and ( nvl(papf.per_information10,'N') <> 'Y' OR paaf.PRIMARY_FLAG = 'Y');
2529: cursor csr_asg is
2530: select paaf.assignment_id
2531: from per_all_assignments_f paaf,
2532: pay_payrolls_f pay,
2533: hr_soft_coding_keyflex sck
2534: where paaf.person_id = (select distinct person_id from per_all_assignments_f where ASSIGNMENT_ID =l_asg_id)
2535: and pay.payroll_id = paaf.payroll_id

Line 2534: where paaf.person_id = (select distinct person_id from per_all_assignments_f where ASSIGNMENT_ID =l_asg_id)

2530: select paaf.assignment_id
2531: from per_all_assignments_f paaf,
2532: pay_payrolls_f pay,
2533: hr_soft_coding_keyflex sck
2534: where paaf.person_id = (select distinct person_id from per_all_assignments_f where ASSIGNMENT_ID =l_asg_id)
2535: and pay.payroll_id = paaf.payroll_id
2536: and pay.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID
2537: and sck.SEGMENT1 = p_m34_rec.paye_ref
2538: and paaf.EFFECTIVE_START_DATE =

Line 2540: from per_all_assignments_f paaf1

2536: and pay.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID
2537: and sck.SEGMENT1 = p_m34_rec.paye_ref
2538: and paaf.EFFECTIVE_START_DATE =
2539: ( select max(paaf1.effective_start_date)
2540: from per_all_assignments_f paaf1
2541: where paaf1.assignment_id = paaf.assignment_id
2542: and paaf1.assignment_type = 'E'
2543: and paaf1.effective_start_date <= p_m34_rec.effective_date
2544: )