APPS.HXC_TIMECARD_PROPERTIES dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 33: type asg_status is table of per_assignment_status_types.per_system_status%type index by binary_integer;

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
37: ,p_segment_name in fnd_descr_flex_column_usages.end_user_column_name%type

Line 478: per_assignment_status_types ast

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'
482: and asg.assignment_status_type_id = ast.assignment_status_type_id;