DBA Data[Home] [Help]

APPS.PQP_GB_PSI_SERVICE_HISTORY dependencies on PER_ALL_ASSIGNMENTS_F

Line 76: ,assignment_number per_all_assignments_f.assignment_number%TYPE

72: TYPE r_asg_details IS RECORD(
73: person_id NUMBER
74: ,effective_start_date DATE
75: ,effective_end_date DATE
76: ,assignment_number per_all_assignments_f.assignment_number%TYPE
77: ,primary_flag per_all_assignments_f.primary_flag%TYPE
78: ,normal_hours per_all_assignments_f.normal_hours%TYPE
79: ,assignment_status_type_id NUMBER
80: ,employment_category per_all_assignments_f.employment_category%TYPE

Line 77: ,primary_flag per_all_assignments_f.primary_flag%TYPE

73: person_id NUMBER
74: ,effective_start_date DATE
75: ,effective_end_date DATE
76: ,assignment_number per_all_assignments_f.assignment_number%TYPE
77: ,primary_flag per_all_assignments_f.primary_flag%TYPE
78: ,normal_hours per_all_assignments_f.normal_hours%TYPE
79: ,assignment_status_type_id NUMBER
80: ,employment_category per_all_assignments_f.employment_category%TYPE
81: );

Line 78: ,normal_hours per_all_assignments_f.normal_hours%TYPE

74: ,effective_start_date DATE
75: ,effective_end_date DATE
76: ,assignment_number per_all_assignments_f.assignment_number%TYPE
77: ,primary_flag per_all_assignments_f.primary_flag%TYPE
78: ,normal_hours per_all_assignments_f.normal_hours%TYPE
79: ,assignment_status_type_id NUMBER
80: ,employment_category per_all_assignments_f.employment_category%TYPE
81: );
82:

Line 80: ,employment_category per_all_assignments_f.employment_category%TYPE

76: ,assignment_number per_all_assignments_f.assignment_number%TYPE
77: ,primary_flag per_all_assignments_f.primary_flag%TYPE
78: ,normal_hours per_all_assignments_f.normal_hours%TYPE
79: ,assignment_status_type_id NUMBER
80: ,employment_category per_all_assignments_f.employment_category%TYPE
81: );
82:
83: TYPE r_lookup_code IS RECORD(
84: lookup_code hr_lookups.lookup_code%TYPE

Line 142: g_assignment_dtl per_all_assignments_f%ROWTYPE;

138: g_tab_pen_ele_ids t_element_details;
139: g_tab_prs_dfn_cv pqp_utilities.t_config_values;
140: g_tab_event_desc_lov t_lookups;
141: g_person_dtl per_all_people_f%ROWTYPE;
142: g_assignment_dtl per_all_assignments_f%ROWTYPE;
143: g_tab_dated_table t_dated_table;
144: g_tab_pay_proc_evnts ben_ext_person.t_detailed_output_table;
145: g_tab_event_group t_event_group;
146: g_prev_pay_proc_evnts ben_ext_person.t_detailed_output_tab_rec;