APPS.PQP_PENSION_EXTRACTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 13: g_person_id per_all_assignments_f.person_id%TYPE;

9: g_action_type varchar2(50);
10: g_asgrun_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
11: g_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
12: g_business_group_id per_business_groups.business_group_id%TYPE;
13: g_person_id per_all_assignments_f.person_id%TYPE;
14: g_total_dtl_lines number(5);
15: g_processing_addl_asgs boolean;
16: g_gre_org_id number(15);
17:

Line 70: (person_id per_all_assignments_f.person_id%TYPE

66: g_element t_ele_details;
67:
68: -- Used to maintain the assignment action details
69: TYPE assig_details IS RECORD
70: (person_id per_all_assignments_f.person_id%TYPE
71: ,organization_id per_all_assignments_f.organization_id%TYPE
72: ,assignment_type per_all_assignments_f.assignment_type%TYPE
73: ,effective_start_date date
74: ,effective_end_date date

Line 71: ,organization_id per_all_assignments_f.organization_id%TYPE

67:
68: -- Used to maintain the assignment action details
69: TYPE assig_details IS RECORD
70: (person_id per_all_assignments_f.person_id%TYPE
71: ,organization_id per_all_assignments_f.organization_id%TYPE
72: ,assignment_type per_all_assignments_f.assignment_type%TYPE
73: ,effective_start_date date
74: ,effective_end_date date
75: ,Calculate_Amount VARCHAR2(50)

Line 72: ,assignment_type per_all_assignments_f.assignment_type%TYPE

68: -- Used to maintain the assignment action details
69: TYPE assig_details IS RECORD
70: (person_id per_all_assignments_f.person_id%TYPE
71: ,organization_id per_all_assignments_f.organization_id%TYPE
72: ,assignment_type per_all_assignments_f.assignment_type%TYPE
73: ,effective_start_date date
74: ,effective_end_date date
75: ,Calculate_Amount VARCHAR2(50)
76: ,assignment_status per_assignment_status_types.user_status%TYPE

Line 78: ,normal_hours per_all_assignments_f.normal_hours%TYPE

74: ,effective_end_date date
75: ,Calculate_Amount VARCHAR2(50)
76: ,assignment_status per_assignment_status_types.user_status%TYPE
77: ,employment_category hr_lookups.meaning%TYPE
78: ,normal_hours per_all_assignments_f.normal_hours%TYPE
79: ,date_start date
80: ,termination_date date
81: );
82:

Line 88: (person_id per_all_assignments_f.person_id%TYPE

84: g_primary_assig t_assig_details;
85:
86: -- Used to maintain the assignment details
87: TYPE leg_rules IS RECORD
88: (person_id per_all_assignments_f.person_id%TYPE
89: ,gre_org_id per_all_assignments_f.organization_id%TYPE
90: ,assignment_type per_all_assignments_f.assignment_type%TYPE
91: ,primary_asg_valid VARCHAR2(2)
92: ,secondary_asg_valid VARCHAR2(2)

Line 89: ,gre_org_id per_all_assignments_f.organization_id%TYPE

85:
86: -- Used to maintain the assignment details
87: TYPE leg_rules IS RECORD
88: (person_id per_all_assignments_f.person_id%TYPE
89: ,gre_org_id per_all_assignments_f.organization_id%TYPE
90: ,assignment_type per_all_assignments_f.assignment_type%TYPE
91: ,primary_asg_valid VARCHAR2(2)
92: ,secondary_asg_valid VARCHAR2(2)
93: );

Line 90: ,assignment_type per_all_assignments_f.assignment_type%TYPE

86: -- Used to maintain the assignment details
87: TYPE leg_rules IS RECORD
88: (person_id per_all_assignments_f.person_id%TYPE
89: ,gre_org_id per_all_assignments_f.organization_id%TYPE
90: ,assignment_type per_all_assignments_f.assignment_type%TYPE
91: ,primary_asg_valid VARCHAR2(2)
92: ,secondary_asg_valid VARCHAR2(2)
93: );
94:

Line 310: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

306: -- Pay_US_Pension_Criteria: The Main extract criteria that would be used for the
307: -- pension extract.
308: -- =============================================================================
309: FUNCTION Pension_Criteria_Full_Profile
310: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
311: ,p_effective_date IN date
312: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
313: ,p_warning_message OUT NOCOPY varchar2
314: ,p_error_message OUT NOCOPY varchar2

Line 312: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

308: -- =============================================================================
309: FUNCTION Pension_Criteria_Full_Profile
310: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
311: ,p_effective_date IN date
312: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
313: ,p_warning_message OUT NOCOPY varchar2
314: ,p_error_message OUT NOCOPY varchar2
315: ) RETURN varchar2;
316: -- =============================================================================