APPS.PER_ASSIGNMENTS_F1_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 46: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

42: --
43:
44: l_fin_proc_date date;
45: l_person_id number;
46: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
47: l_pdp_date_start date;
48: --
49: l_proc varchar2(18) := 'iud_update_primary';
50: --

Line 68: FROM per_all_assignments_f paaf

64: SELECT paaf.person_id
65: ,paaf.assignment_type
66: ,paaf.period_of_placement_date_start
67: ,paaf.object_version_number -- added for bug 9644377
68: FROM per_all_assignments_f paaf
69: WHERE paaf.assignment_id = p_ass_id
70: AND paaf.assignment_type IN ('E', 'C');
71: --
72: -- Bug 3240313 starts here.

Line 79: FROM per_all_assignments_f paaf

75: SELECT paaf.person_id
76: ,paaf.assignment_type
77: ,paaf.period_of_placement_date_start
78: ,paaf.object_version_number -- added for bug 9644377
79: FROM per_all_assignments_f paaf
80: WHERE paaf.assignment_id = p_new_prim_ass_id
81: AND paaf.assignment_type IN ('E', 'C');
82: --
83: -- Bug 3240313 ends here.

Line 1064: from per_all_assignments_f

1060: ,vendor_site_id
1061: ,po_header_id
1062: ,po_line_id
1063: ,projected_assignment_end
1064: from per_all_assignments_f
1065: where assignment_id = p_asg_id
1066: and p_eff_date between effective_start_date
1067: and effective_end_date;
1068: --

Line 2144: from per_all_assignments_f

2140: ,vendor_site_id
2141: ,po_header_id
2142: ,po_line_id
2143: ,projected_assignment_end
2144: from per_all_assignments_f
2145: where assignment_id = p_asg_id
2146: and p_eff_date between effective_start_date
2147: and effective_end_date;
2148: --

Line 2298: ,p_base_table_name => 'per_all_assignments_f'

2294: END IF;
2295: dt_api.validate_dt_mode
2296: (p_effective_date => p_sess_date
2297: ,p_datetrack_mode => 'INSERT'
2298: ,p_base_table_name => 'per_all_assignments_f'
2299: ,p_base_key_column => 'assignment_id'
2300: ,p_base_key_value => p_ass_id
2301: ,p_validation_start_date => l_vsd
2302: ,p_validation_end_date => l_ved

Line 2474: from per_all_assignments_f

2470: is
2471: select effective_start_date
2472: , object_version_number
2473: , business_group_id
2474: from per_all_assignments_f
2475: where assignment_id = p_asg_id
2476: and p_eff_date between effective_start_date
2477: and effective_end_date;
2478: --