APPS.PQP_NL_PENSION_EXTRACTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 12: g_person_id per_all_assignments_f.person_id%TYPE;

8: g_action_type VARCHAR2(50);
9: g_asgrun_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
10: g_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
11: g_business_group_id per_business_groups.business_group_id%TYPE;
12: g_person_id per_all_assignments_f.person_id%TYPE;
13: g_index_fur NUMBER := 0;
14: g_count_fur NUMBER := 0;
15: g_index_ipap NUMBER := 0;
16: g_count_ipap NUMBER := 0;

Line 113: (person_id per_all_assignments_f.person_id%TYPE

109:
110:
111:
112: TYPE assig_details IS RECORD
113: (person_id per_all_assignments_f.person_id%TYPE
114: ,organization_id per_all_assignments_f.organization_id%TYPE
115: ,assignment_type per_all_assignments_f.assignment_type%TYPE
116: ,effective_start_date DATE
117: ,effective_end_date DATE

Line 114: ,organization_id per_all_assignments_f.organization_id%TYPE

110:
111:
112: TYPE assig_details IS RECORD
113: (person_id per_all_assignments_f.person_id%TYPE
114: ,organization_id per_all_assignments_f.organization_id%TYPE
115: ,assignment_type per_all_assignments_f.assignment_type%TYPE
116: ,effective_start_date DATE
117: ,effective_end_date DATE
118: ,assignment_status per_assignment_status_types.user_status%TYPE

Line 115: ,assignment_type per_all_assignments_f.assignment_type%TYPE

111:
112: TYPE assig_details IS RECORD
113: (person_id per_all_assignments_f.person_id%TYPE
114: ,organization_id per_all_assignments_f.organization_id%TYPE
115: ,assignment_type per_all_assignments_f.assignment_type%TYPE
116: ,effective_start_date DATE
117: ,effective_end_date DATE
118: ,assignment_status per_assignment_status_types.user_status%TYPE
119: ,employment_category hr_lookups.meaning%TYPE

Line 125: ,asg_seq_num per_all_assignments_f.assignment_sequence%TYPE

121: ,termination_date DATE
122: ,payroll_id pay_payrolls_f.payroll_id%TYPE
123: ,abp_er_num VARCHAR2(10)
124: ,ee_num per_all_people_f.employee_number%TYPE
125: ,asg_seq_num per_all_assignments_f.assignment_sequence%TYPE
126: ,ni_num per_all_people_f.national_identifier%TYPE
127: ,per_ln per_all_people_f.last_name%TYPE
128: ,per_initials per_all_people_f.per_information1%TYPE
129: ,per_prefix per_all_people_f.pre_name_adjunct%TYPE

Line 136: ,primary_flag per_all_assignments_f.primary_flag%TYPE

132: ,partner_last_name per_all_people_f.last_name%TYPE
133: ,partner_prefix per_all_people_f.pre_name_adjunct%TYPE
134: ,address_fem_ee per_all_people_f.per_information14%TYPE
135: ,marital_status per_all_people_f.marital_status%TYPE
136: ,primary_flag per_all_assignments_f.primary_flag%TYPE
137: );
138:
139: TYPE t_assig_details IS TABLE OF assig_details INDEX BY BINARY_INTEGER;
140: g_primary_assig t_assig_details;

Line 305: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

301: -- Pension_Criteria_Full_Profile: The Main extract criteria that would be used
302: -- for the pension extract.
303: -- =============================================================================
304: FUNCTION Pension_Criteria_Full_Profile
305: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
306: ,p_effective_date IN date
307: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
308: ,p_warning_message OUT NOCOPY VARCHAR2
309: ,p_error_message OUT NOCOPY VARCHAR2

Line 307: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

303: -- =============================================================================
304: FUNCTION Pension_Criteria_Full_Profile
305: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
306: ,p_effective_date IN date
307: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
308: ,p_warning_message OUT NOCOPY VARCHAR2
309: ,p_error_message OUT NOCOPY VARCHAR2
310: ) RETURN VARCHAR2;
311: