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 500: per_assignment_status_types ast

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