APPS.PAY_PPM_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 140: from per_all_assignments_f pa

136: cursor asg_sel is
137: select pa.payroll_id,
138: pa.effective_start_date,
139: pa.effective_end_date
140: from per_all_assignments_f pa
141: where pa.assignment_id = p_assignment_id
142: and pa.business_group_id + 0 = p_business_group_id
143: and pa.effective_end_date >= p_effective_date
144: order by pa.effective_start_date;

Line 404: l_type per_all_assignments_f.assignment_type%type;

400: procedure chk_assignment_type
401: (p_assignment_id in number
402: ,p_effective_date in date) is
403: --
404: l_type per_all_assignments_f.assignment_type%type;
405: l_proc varchar2(72) := g_package||'chk_assignment_type';
406: --
407: cursor csr_ass_type is
408: select asg.assignment_type

Line 409: from per_all_assignments_f asg

405: l_proc varchar2(72) := g_package||'chk_assignment_type';
406: --
407: cursor csr_ass_type is
408: select asg.assignment_type
409: from per_all_assignments_f asg
410: where asg.assignment_id = p_assignment_id
411: and p_effective_date between asg.effective_start_date
412: and asg.effective_end_date;
413: --

Line 714: per_all_assignments_f asg

710: --
711: cursor csr_chk_contact is
712: select null
713: from per_contact_relationships ctr,
714: per_all_assignments_f asg
715: where ctr.contact_person_id = p_payee_id
716: and ctr.person_id = asg.person_id
717: and asg.assignment_id = p_assignment_id
718: and p_effective_date between asg.effective_start_date

Line 1645: (p_base_table_name => 'per_all_assignments_f',

1641: Raise l_integrity_error;
1642: End If;
1643: If ((nvl(p_assignment_id, hr_api.g_number) <> hr_api.g_number) and
1644: NOT (dt_api.check_min_max_dates
1645: (p_base_table_name => 'per_all_assignments_f',
1646: p_base_key_column => 'assignment_id',
1647: p_base_key_value => p_assignment_id,
1648: p_from_date => p_validation_start_date,
1649: p_to_date => p_validation_end_date))) Then