DBA Data[Home] [Help]

APPS.PQP_GB_PSI_HRS_HISTORY dependencies on PER_ALL_ASSIGNMENTS_F

Line 45: ,assignment_number per_all_assignments_f.assignment_number%TYPE

41: TYPE r_asg_details IS RECORD(
42: person_id NUMBER
43: ,effective_start_date DATE
44: ,effective_end_date DATE
45: ,assignment_number per_all_assignments_f.assignment_number%TYPE
46: ,primary_flag per_all_assignments_f.primary_flag%TYPE
47: ,normal_hours per_all_assignments_f.normal_hours%TYPE
48: ,assignment_status_type_id NUMBER
49: ,employment_category per_all_assignments_f.employment_category%TYPE

Line 46: ,primary_flag per_all_assignments_f.primary_flag%TYPE

42: person_id NUMBER
43: ,effective_start_date DATE
44: ,effective_end_date DATE
45: ,assignment_number per_all_assignments_f.assignment_number%TYPE
46: ,primary_flag per_all_assignments_f.primary_flag%TYPE
47: ,normal_hours per_all_assignments_f.normal_hours%TYPE
48: ,assignment_status_type_id NUMBER
49: ,employment_category per_all_assignments_f.employment_category%TYPE
50: );

Line 47: ,normal_hours per_all_assignments_f.normal_hours%TYPE

43: ,effective_start_date DATE
44: ,effective_end_date DATE
45: ,assignment_number per_all_assignments_f.assignment_number%TYPE
46: ,primary_flag per_all_assignments_f.primary_flag%TYPE
47: ,normal_hours per_all_assignments_f.normal_hours%TYPE
48: ,assignment_status_type_id NUMBER
49: ,employment_category per_all_assignments_f.employment_category%TYPE
50: );
51:

Line 49: ,employment_category per_all_assignments_f.employment_category%TYPE

45: ,assignment_number per_all_assignments_f.assignment_number%TYPE
46: ,primary_flag per_all_assignments_f.primary_flag%TYPE
47: ,normal_hours per_all_assignments_f.normal_hours%TYPE
48: ,assignment_status_type_id NUMBER
49: ,employment_category per_all_assignments_f.employment_category%TYPE
50: );
51:
52: TYPE r_lookup_code IS RECORD(
53: lookup_code hr_lookups.lookup_code%TYPE

Line 110: g_assignment_dtl per_all_assignments_f%ROWTYPE;

106: g_tab_pen_ele_ids t_element_details;
107: g_tab_prs_dfn_cv pqp_utilities.t_config_values;
108: g_tab_event_desc_lov t_lookups;
109: g_person_dtl per_all_people_f%ROWTYPE;
110: g_assignment_dtl per_all_assignments_f%ROWTYPE;
111: g_tab_dated_table t_dated_table;
112: g_tab_pay_proc_evnts ben_ext_person.t_detailed_output_table;
113: g_tab_event_group t_event_group;
114: g_prev_pay_proc_evnts ben_ext_person.t_detailed_output_tab_rec;