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 499: from per_all_assignments_f asg,

495: asg.assignment_number,
496: asg.effective_start_date,
497: asg.effective_end_date,
498: nvl(ast.per_system_status,'NoSystemStatus') assignment_status_type
499: from per_all_assignments_f asg,
500: per_assignment_status_types ast
501: where asg.person_id = p_pid
502: and asg.assignment_type in ('E','C')
503: and asg.primary_flag = 'Y'

Line 890: from per_all_assignments_f

886: begin
887:
888: select min(effective_start_date)
889: into l_date
890: from per_all_assignments_f
891: where person_id = p_resource_id;
892:
893: return l_date;
894: