APPS.PSP_LABOR_DIST dependencies on PER_ALL_ASSIGNMENTS_F

Line 5308: from per_all_assignments_f

5304: 0,
5305: 0,
5306: sysdate,
5307: sysdate
5308: from per_all_assignments_f
5309: where assignment_id = p_assignment_id
5310: and assignment_type = 'E'
5311: and rownum = 1;
5312:

Line 6881: from per_all_assignments_f

6877:
6878:
6879: cursor get_asg_number(p_asg_id integer) is
6880: select person_id, assignment_number
6881: from per_all_assignments_f
6882: where assignment_id = p_asg_id
6883: and assignment_type = 'E'
6884: order by effective_end_date desc;
6885:

Line 6951: per_all_assignments_f paf

6947: p_dist_date date,
6948: p_funding_source_code varchar2) is
6949: select org.organization_account_id
6950: from psp_organization_accounts org,
6951: per_all_assignments_f paf
6952: where org.account_type_code in ( 'ORG_EXCESS')
6953: and p_dist_date between org.start_date_active and nvl(org.end_date_active, fnd_date.canonical_to_date('4000/01/31'))
6954: and paf.assignment_type = 'E'
6955: and paf.assignment_id = p_asg_id

Line 7085: From per_all_assignments_f paf,

7081: if g_cap_element_set_id is null then
7082: l_element_sql_str :=
7083: 'and (ppl.assignment_id, ppl.element_type_id) in
7084: (select paf.assignment_id, min(piv.element_type_id)
7085: From per_all_assignments_f paf,
7086: per_pay_bases ppb,
7087: pay_input_values_f piv
7088: where paf.payroll_id = '||control_details_rec.payroll_id||'
7089: and ('||''''||l_tp_start_date ||''''||' between paf.effective_start_date and paf.effective_end_date

Line 7961: per_all_assignments_f paf,

7957: select ppf.full_name,
7958: paf.assignment_number,
7959: hou.name
7960: from per_all_people_f ppf,
7961: per_all_assignments_f paf,
7962: hr_all_organization_units hou
7963: where ppf.person_id = p_person_id
7964: and p_eff_date between ppf.effective_start_date and ppf.effective_end_date
7965: and paf.assignment_type = 'E'