APPS.PQP_US_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_gre_tax_unit_id hr_all_organization_units.organization_id%TYPE;
14: g_total_dtl_lines Number;
15:
16: TYPE ValTabTyp IS TABLE OF ben_Ext_rslt_dtl.val_01%TYPE

Line 74: (person_id per_all_assignments_f.person_id%TYPE

70: TYPE t_ele_details IS TABLE OF ele_details INDEX BY Binary_Integer;
71: g_element t_ele_details;
72:
73: TYPE assig_details IS RECORD
74: (person_id per_all_assignments_f.person_id%TYPE
75: ,organization_id per_all_assignments_f.organization_id%TYPE
76: ,assignment_type per_all_assignments_f.assignment_type%TYPE
77: ,effective_start_date Date
78: ,effective_end_date Date

Line 75: ,organization_id per_all_assignments_f.organization_id%TYPE

71: g_element t_ele_details;
72:
73: TYPE assig_details IS RECORD
74: (person_id per_all_assignments_f.person_id%TYPE
75: ,organization_id per_all_assignments_f.organization_id%TYPE
76: ,assignment_type per_all_assignments_f.assignment_type%TYPE
77: ,effective_start_date Date
78: ,effective_end_date Date
79: ,Calculate_Amount Varchar2(50)

Line 76: ,assignment_type per_all_assignments_f.assignment_type%TYPE

72:
73: TYPE assig_details IS RECORD
74: (person_id per_all_assignments_f.person_id%TYPE
75: ,organization_id per_all_assignments_f.organization_id%TYPE
76: ,assignment_type per_all_assignments_f.assignment_type%TYPE
77: ,effective_start_date Date
78: ,effective_end_date Date
79: ,Calculate_Amount Varchar2(50)
80: ,assignment_status per_assignment_status_types.user_status%TYPE

Line 82: ,normal_hours per_all_assignments_f.normal_hours%TYPE

78: ,effective_end_date Date
79: ,Calculate_Amount Varchar2(50)
80: ,assignment_status per_assignment_status_types.user_status%TYPE
81: ,employment_category hr_lookups.meaning%TYPE
82: ,normal_hours per_all_assignments_f.normal_hours%TYPE
83: ,date_start Date
84: ,termination_date Date
85: ,payroll_id pay_payrolls_f.payroll_id%TYPE
86: ,PPG_Billing_Code Varchar2(150)

Line 323: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

319: -- Pay_US_Pension_Criteria: The Main extract criteria that would be used for the
320: -- pension extract.
321: -- =============================================================================
322: FUNCTION Pension_Criteria_Full_Profile
323: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
324: ,p_effective_date IN Date
325: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
326: ,p_warning_message OUT NOCOPY Varchar2
327: ,p_error_message OUT NOCOPY Varchar2

Line 325: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

321: -- =============================================================================
322: FUNCTION Pension_Criteria_Full_Profile
323: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
324: ,p_effective_date IN Date
325: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
326: ,p_warning_message OUT NOCOPY Varchar2
327: ,p_error_message OUT NOCOPY Varchar2
328: ) RETURN Varchar2;
329: -- =============================================================================