APPS.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 9: g_person_id per_all_assignments_f.person_id%TYPE;

5: g_action_effective_date DATE;
6: g_action_type VARCHAR2(50);
7: g_asgrun_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
8: g_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
9: g_person_id per_all_assignments_f.person_id%TYPE;
10: g_retro_ptp_count NUMBER := 0;
11: g_debug BOOLEAN := FALSE;
12: g_legislation_code per_business_groups.legislation_code%TYPE;
13: g_business_group_id per_business_groups.business_group_id%TYPE;

Line 73: (person_id per_all_assignments_f.person_id%TYPE

69: g_ord_details t_org_details;
70: g_ord_details1 t_org_details;
71:
72: TYPE assig_details IS RECORD
73: (person_id per_all_assignments_f.person_id%TYPE
74: ,organization_id per_all_assignments_f.organization_id%TYPE
75: ,assignment_type per_all_assignments_f.assignment_type%TYPE
76: ,effective_start_date DATE
77: ,effective_end_date DATE

Line 74: ,organization_id per_all_assignments_f.organization_id%TYPE

70: g_ord_details1 t_org_details;
71:
72: TYPE assig_details IS RECORD
73: (person_id per_all_assignments_f.person_id%TYPE
74: ,organization_id per_all_assignments_f.organization_id%TYPE
75: ,assignment_type per_all_assignments_f.assignment_type%TYPE
76: ,effective_start_date DATE
77: ,effective_end_date DATE
78: ,assignment_status per_assignment_status_types.user_status%TYPE

Line 75: ,assignment_type per_all_assignments_f.assignment_type%TYPE

71:
72: TYPE assig_details IS RECORD
73: (person_id per_all_assignments_f.person_id%TYPE
74: ,organization_id per_all_assignments_f.organization_id%TYPE
75: ,assignment_type per_all_assignments_f.assignment_type%TYPE
76: ,effective_start_date DATE
77: ,effective_end_date DATE
78: ,assignment_status per_assignment_status_types.user_status%TYPE
79: ,employment_category hr_lookups.meaning%TYPE

Line 85: ,asg_seq_num per_all_assignments_f.assignment_sequence%TYPE

81: ,termination_date DATE
82: ,payroll_id pay_payrolls_f.payroll_id%TYPE
83: ,pggm_er_num VARCHAR2(10)
84: ,ee_num per_all_people_f.employee_number%TYPE
85: ,asg_seq_num per_all_assignments_f.assignment_sequence%TYPE
86: ,ni_num per_all_people_f.national_identifier%TYPE
87: ,per_ln per_all_people_f.last_name%TYPE
88: ,per_initials per_all_people_f.per_information1%TYPE
89: ,per_prefix per_all_people_f.pre_name_adjunct%TYPE

Line 96: ,primary_flag per_all_assignments_f.primary_flag%TYPE

92: ,partner_last_name per_all_people_f.last_name%TYPE
93: ,partner_prefix per_all_people_f.pre_name_adjunct%TYPE
94: ,address_fem_ee per_all_people_f.per_information14%TYPE
95: ,marital_status per_all_people_f.marital_status%TYPE
96: ,primary_flag per_all_assignments_f.primary_flag%TYPE
97: );
98:
99: TYPE t_assig_details IS TABLE OF assig_details INDEX BY BINARY_INTEGER;
100: g_primary_assig t_assig_details;

Line 241: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

237: -- Pension_Criteria_Full_Profile: The Main extract criteria that would be used
238: -- for the pension extract.
239: -- =============================================================================
240: FUNCTION Pension_Criteria_Full_Profile
241: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
242: ,p_effective_date IN date
243: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
244: ,p_warning_message OUT NOCOPY VARCHAR2
245: ,p_error_message OUT NOCOPY VARCHAR2

Line 243: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

239: -- =============================================================================
240: FUNCTION Pension_Criteria_Full_Profile
241: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
242: ,p_effective_date IN date
243: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
244: ,p_warning_message OUT NOCOPY VARCHAR2
245: ,p_error_message OUT NOCOPY VARCHAR2
246: ) RETURN VARCHAR2;
247: -- ====================================================================