DBA Data[Home] [Help]

APPS.PER_DIF_STMT_REPORT dependencies on PER_ALL_ASSIGNMENTS_F

Line 70: l_select := 'select distinct per.person_id emp_id, estab.organization_id estab_id, per.full_name name, per.employee_number empnum from per_all_people_f per, per_all_assignments_f ass, pay_element_entries_f ent, '||

66: --
67: -- Get a list of employees for this establishment
68: -- and accrual plan, if any
69: -- Build the query dynamically
70: l_select := 'select distinct per.person_id emp_id, estab.organization_id estab_id, per.full_name name, per.employee_number empnum from per_all_people_f per, per_all_assignments_f ass, pay_element_entries_f ent, '||
71: 'pay_accrual_plans acc, hr_all_organization_units estab';
72: l_where := ' where per.person_id = ass.person_id and per.business_group_id = '||p_business_group_id||' and '|| '''' ||l_date_to|| ''''||' between per.effective_start_date '
73: ||'and per.effective_end_date and estab.business_group_id = per.business_group_id and ass.establishment_id = estab.organization_id '
74: ||'and ass.effective_end_date >= '|| '''' ||l_date_from|| ''''||' and ass.effective_start_date <= '|| '''' ||l_date_to|| ''''||' and ass.assignment_id = ent.assignment_id '

Line 295: per_all_assignments_f asg,

291: from per_all_people_f per,
292: per_addresses per_addr,
293: fnd_territories per_ft,
294: per_periods_of_service serv,
295: per_all_assignments_f asg,
296: per_collective_agreements col_agr
297: where per.person_id = p_emp_id
298: and asg.person_id = per.person_id
299: and per.effective_end_date = (select max(effective_end_date)

Line 304: from per_all_assignments_f

300: from per_all_people_f
301: where person_id = per.person_id
302: and effective_end_date >= p_date_from)
303: and asg.effective_end_date =(select max(effective_end_date)
304: from per_all_assignments_f
305: where person_id = per.person_id
306: and effective_end_date >= p_date_from)
307: and serv.person_id = per.person_id
308: and (serv.actual_termination_date is null

Line 326: per_all_assignments_f asg

322: hr_general.decode_lookup('CONTRACT_TYPE',ctr.type) ctr_hdr_type,
323: hr_general.decode_lookup('FR_CONTRACT_CATEGORY',ctr_information2) ctr_hdr_category,
324: decode(ctr.ctr_information12, 'HOUR', ctr.ctr_information11, to_char(asg.normal_hours)) ctr_hdr_hours
325: from per_contracts_f ctr,
326: per_all_assignments_f asg
327: where asg.person_id = p_emp_id
328: and asg.effective_start_date <= p_date_to
329: and asg.effective_end_date >= p_date_from
330: and asg.contract_id(+) = ctr.contract_id

Line 347: per_all_assignments_f asg

343: 'acc_hdr_enrol_end',
344: decode(ent.effective_end_date, hr_general.end_of_time,null, to_char(ent.effective_end_date, 'dd-Mon-yy'))
345: from pay_accrual_plans acc,
346: pay_element_entries_f ent,
347: per_all_assignments_f asg
348: where acc.accrual_plan_id = p_accrual_plan_id
349: and asg.person_id = p_emp_id
350: and ent.assignment_id = asg.assignment_id
351: and ent.element_type_id = acc.accrual_plan_element_type_id

Line 366: per_all_assignments_f asg,

362: -- Cursor for selecting the greater of enrollment date and hiredate
363: Cursor csr_get_co_start is
364: select greatest(ent.effective_start_date, per.original_date_of_hire) co_start_date
365: from pay_element_entries_f ent,
366: per_all_assignments_f asg,
367: per_all_people_f per,
368: pay_accrual_plans acc
369: where acc.accrual_plan_id = p_accrual_plan_id
370: and per.person_id = p_emp_id

Line 377: from per_all_assignments_f

373: from per_all_people_f
374: where person_id = per.person_id
375: and effective_end_date >= p_date_from)
376: and asg.effective_end_date =(select max(effective_end_date)
377: from per_all_assignments_f
378: where person_id = per.person_id
379: and effective_end_date >= p_date_from)
380: and ent.assignment_id = asg.assignment_id
381: and ent.element_type_id = acc.accrual_plan_element_type_id

Line 396: from per_all_assignments_f asg,

392: select asg.effective_start_date start_date,
393: substr(hruserdt.get_table_value(p_business_group_id, 'FR_CIPDZ', 'CIPDZ',nvl(asg.employment_category,'FR'),p_date_from),1,1) asg_catg,
394: asg.payroll_id payroll_id,
395: decode(ctr.ctr_information12, 'HOUR', fnd_number.canonical_to_number(ctr.ctr_information11), asg.normal_hours) wkg_hours
396: from per_all_assignments_f asg,
397: per_contracts_f ctr
398: where asg.person_id= p_emp_id
399: and asg.effective_end_date >= p_date_from
400: and asg.effective_start_date <= p_date_to