APPS.HXC_TIMECARD_PROPERTIES dependencies on PER_ALL_ASSIGNMENTS_F

Line 32: type asg_number is table of per_all_assignments_f.assignment_number%type index by binary_integer;

28: g_period_list_cache period_list_cache;
29:
30: Type asg_id is table of number index by binary_integer;
31: Type asg_date is table of date index by binary_integer;
32: type asg_number is table of per_all_assignments_f.assignment_number%type index by binary_integer;
33: type asg_status is table of per_assignment_status_types.per_system_status%type index by binary_integer;
34:
35: function find_segment
36: (p_context_code in fnd_descr_flex_column_usages.descriptive_flex_context_code%type

Line 477: from per_all_assignments_f asg,

473: asg.assignment_number,
474: asg.effective_start_date,
475: asg.effective_end_date,
476: nvl(ast.per_system_status,'NoSystemStatus') assignment_status_type
477: from per_all_assignments_f asg,
478: per_assignment_status_types ast
479: where asg.person_id = p_pid
480: and asg.assignment_type in ('E','C')
481: and asg.primary_flag = 'Y'

Line 863: from per_all_assignments_f

859: begin
860:
861: select min(effective_start_date)
862: into l_date
863: from per_all_assignments_f
864: where person_id = p_resource_id;
865:
866: return l_date;
867: