APPS.PYUDET dependencies on PER_ALL_ASSIGNMENTS_F

Line 189: per_all_assignments_f asg,

185: g_effective_date,
186: peo.effective_start_date,
187: peo.effective_end_date
188: from per_all_people_f peo,
189: per_all_assignments_f asg,
190: per_periods_of_service pps,
191: per_person_type_usages_f ptu,
192: per_person_types ppt
193: where peo.person_id = asg.person_id

Line 261: from per_all_assignments_f asg,

257: pay.payroll_id,
258: assignment_number,
259: per_system_status asg_status,
260: sck.segment1 tax_ref
261: from per_all_assignments_f asg,
262: pay_all_payrolls_f pay,
263: per_assignment_status_types pat,
264: hr_soft_coding_keyflex sck
265: where asg.person_id = p_person_id

Line 323: from per_all_assignments_f asg,

319: -- This cursor is for Checking active and suspended assignments at the time of process run -- /*Added soy 08-09*/
320: -----------------------------------------------------------------------------------------------
321: CURSOR get_cpe_flag(p_person_id number, p_paye_ref varchar2, p_date date ) IS
322: select assignment_id
323: from per_all_assignments_f asg,
324: pay_all_payrolls_f pay,
325: per_assignment_status_types pat,
326: hr_soft_coding_keyflex sck
327: where asg.person_id = p_person_id

Line 439: from PER_ALL_ASSIGNMENTS_F paaf,

435: -- This cursor is for Checking assignment is teminated in future --
436: -------------------------------------------------------------------
437: CURSOR get_future_term_date(p_assignment_id number, p_effective_date date ) IS
438: select effective_start_date
439: from PER_ALL_ASSIGNMENTS_F paaf,
440: per_assignment_status_types past
441: where paaf.effective_start_date >= p_effective_date
442: and paaf.assignment_id = p_assignment_id
443: and paaf.assignment_status_type_id =past.assignment_status_type_id

Line 451: from PER_ALL_ASSIGNMENTS_F paaf

447: -- This cursor is for Checking assignment is ended in future --
448: -------------------------------------------------------------------
449: CURSOR get_future_end_asg_date(p_assignment_id number, p_effective_date date ) IS
450: select max(effective_end_date)
451: from PER_ALL_ASSIGNMENTS_F paaf
452: where paaf.effective_end_date >= p_effective_date
453: and paaf.assignment_id = p_assignment_id
454: and paaf.business_group_id = g_business_group_id;
455:

Line 1823: per_all_assignments_f asg,

1819: pps.actual_termination_date,
1820: pps.last_standard_process_date,
1821: p_m34_rec.effective_date
1822: from per_all_people_f peo,
1823: per_all_assignments_f asg,
1824: per_periods_of_service pps
1825: where asg.business_group_id = g_business_group_id
1826: and peo.business_group_id = g_business_group_id
1827: and peo.person_id = asg.person_id

Line 1857: from per_all_assignments_f asg,

1853: p_person_id number,
1854: p_date date,
1855: p_asg_no varchar2 default null) is
1856: select count(*)
1857: from per_all_assignments_f asg,
1858: pay_all_payrolls_f pay,
1859: hr_soft_coding_keyflex sck
1860: where asg.person_id = p_person_id
1861: and asg.payroll_id = pay.payroll_id

Line 1875: per_all_assignments_f asg,

1871: p_person_id number,
1872: p_date date) is
1873: select count(*)
1874: from per_all_people_f peo,
1875: per_all_assignments_f asg,
1876: pay_all_payrolls_f pay,
1877: hr_soft_coding_keyflex sck
1878: where peo.person_id = p_person_id
1879: and asg.person_id = peo.person_id

Line 1888: from per_all_assignments_f asg,

1884: and asg.effective_start_date > p_date
1885: and p_date between pay.effective_start_date and pay.effective_end_date
1886: and asg.effective_start_date between peo.effective_start_date and peo.effective_end_date
1887: and asg.assignment_id not in (select assignment_id
1888: from per_all_assignments_f asg,
1889: pay_all_payrolls_f pay,
1890: hr_soft_coding_keyflex sck
1891: where asg.person_id = p_person_id
1892: and asg.payroll_id = pay.payroll_id