eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_US_PENSION_EXTRACTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 71: FROM per_all_assignments_f paf,

67: ,pps.actual_termination_date
68: ,paf.payroll_id
69: ,'PPG_CODE'
70: ,'PAY_MODE'
71: FROM per_all_assignments_f paf,
72: per_periods_of_service pps,
73: per_assignment_status_types ast
74: WHERE paf.assignment_id = c_assignment_id
75: AND pps.period_of_service_id = paf.period_of_service_id

Line 291: (c_primary_assignment_id IN per_all_assignments_f.assignment_id%TYPE

287: -- =============================================================================
288: -- Cursor to chk for other primary assig. within the extract date range.
289: -- =============================================================================
290: CURSOR csr_sec_assg
291: (c_primary_assignment_id IN per_all_assignments_f.assignment_id%TYPE
292: ,c_person_id IN per_all_people_f.person_id%TYPE
293: ,c_effective_date IN DATE
294: ,c_extract_start_date IN DATE
295: ,c_extract_end_date IN DATE ) IS

Line 303: FROM per_all_assignments_f asg

299: ,asg.effective_start_date
300: ,asg.effective_end_date
301: ,'NO'
302: ,asg.assignment_id
303: FROM per_all_assignments_f asg
304: WHERE asg.person_id = c_person_id
305: AND asg.assignment_id <> c_primary_assignment_id
306: AND asg.assignment_type ='E'
307: AND (( c_effective_date BETWEEN asg.effective_start_date

Line 313: FROM per_all_assignments_f asx

309: )
310: OR
311: ( asg.effective_end_date =
312: (SELECT Max(asx.effective_end_date)
313: FROM per_all_assignments_f asx
314: WHERE asx.assignment_id = asg.assignment_id
315: AND asx.person_id = c_person_id
316: AND asx.assignment_type = 'E'
317: AND ((asx.effective_end_date BETWEEN c_extract_start_date

Line 379: FROM per_all_assignments_f paf

375: ,paf.grade_id
376: ,paf.job_id
377: ,paf.location_id
378: ,paf.assignment_id
379: FROM per_all_assignments_f paf
380: WHERE paf.assignment_id = c_assignment_id
381: AND paf.business_group_id = g_business_group_id
382: AND c_effective_date BETWEEN paf.effective_start_date
383: AND paf.effective_end_date;

Line 1168: FROM per_all_assignments_f paf

1164:
1165: CURSOR csr_gre_id (c_effective_date IN DATE
1166: ,c_assignment_id IN NUMBER) IS
1167: SELECT segment1
1168: FROM per_all_assignments_f paf
1169: ,hr_soft_coding_keyflex hsc
1170: WHERE hsc.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
1171: AND paf.assignment_id = c_assignment_id
1172: AND paf.business_group_id = g_business_group_id

Line 3020: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

3016: ,p_person_id IN NUMBER
3017: ,p_asgaction_no IN NUMBER
3018: ,p_error_message OUT NOCOPY VARCHAR2) IS
3019: l_proc_name VARCHAR2(150) := g_proc_name ||'Create_AsgAction_Lines';
3020: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3021: l_organization_id per_all_assignments_f.organization_id%TYPE;
3022: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
3023: l_main_rec csr_rslt_dtl%ROWTYPE;
3024: l_new_rec csr_rslt_dtl%ROWTYPE;

Line 3021: l_organization_id per_all_assignments_f.organization_id%TYPE;

3017: ,p_asgaction_no IN NUMBER
3018: ,p_error_message OUT NOCOPY VARCHAR2) IS
3019: l_proc_name VARCHAR2(150) := g_proc_name ||'Create_AsgAction_Lines';
3020: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3021: l_organization_id per_all_assignments_f.organization_id%TYPE;
3022: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
3023: l_main_rec csr_rslt_dtl%ROWTYPE;
3024: l_new_rec csr_rslt_dtl%ROWTYPE;
3025: l_effective_date DATE;

Line 3022: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

3018: ,p_error_message OUT NOCOPY VARCHAR2) IS
3019: l_proc_name VARCHAR2(150) := g_proc_name ||'Create_AsgAction_Lines';
3020: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3021: l_organization_id per_all_assignments_f.organization_id%TYPE;
3022: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
3023: l_main_rec csr_rslt_dtl%ROWTYPE;
3024: l_new_rec csr_rslt_dtl%ROWTYPE;
3025: l_effective_date DATE;
3026: BEGIN

Line 3522: i per_all_assignments_f.business_group_id%TYPE;

3518: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
3519: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
3520: l_valid_action VARCHAR2(2);
3521: l_ele_count NUMBER(10);
3522: i per_all_assignments_f.business_group_id%TYPE;
3523: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE;
3524: l_proc_name VARCHAR2(150) := g_proc_name ||'Process_Assignments';
3525: BEGIN
3526: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 3643: i per_all_assignments_f.business_group_id%TYPE;

3639: ,p_error_message OUT NOCOPY VARCHAR2
3640: ) RETURN VARCHAR2 IS
3641:
3642: l_return_value VARCHAR2(50);
3643: i per_all_assignments_f.business_group_id%TYPE;
3644: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
3645: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
3646: l_valid_action VARCHAR2(2);
3647: l_no_asg_action NUMBER(5) := 0;

Line 3654: l_asg_type per_all_assignments_f.assignment_type%TYPE;

3650: l_effective_date DATE;
3651: l_criteria_value VARCHAR2(2);
3652: l_warning_message VARCHAR2(2000);
3653: l_error_message VARCHAR2(2000);
3654: l_asg_type per_all_assignments_f.assignment_type%TYPE;
3655: l_main_rec csr_rslt_dtl%ROWTYPE;
3656: l_person_id per_all_people_f.person_id%TYPE;
3657: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3658: BEGIN

Line 3657: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

3653: l_error_message VARCHAR2(2000);
3654: l_asg_type per_all_assignments_f.assignment_type%TYPE;
3655: l_main_rec csr_rslt_dtl%ROWTYPE;
3656: l_person_id per_all_people_f.person_id%TYPE;
3657: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3658: BEGIN
3659: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
3660: i := p_business_group_id;
3661:

Line 3940: FROM per_all_assignments_f paf

3936: CURSOR csr_pay_basis (c_assignment_id IN NUMBER
3937: ,c_effective_date IN DATE
3938: ,c_business_group_id IN NUMBER) IS
3939: SELECT ppb.pay_annualization_factor
3940: FROM per_all_assignments_f paf
3941: ,per_pay_bases ppb
3942: WHERE assignment_id = c_assignment_id
3943: AND paf.pay_basis_id = ppb.pay_basis_id
3944: AND ppb.business_group_id = c_business_group_id

Line 3969: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;

3965: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Data_Elements';
3966: l_return_value VARCHAR2(250);
3967: l_base_salary NUMBER(15,2);
3968: i NUMBER;
3969: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
3970: l_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
3971:
3972: BEGIN
3973: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 4149: i per_all_assignments_f.business_group_id%TYPE;

4145: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
4146: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
4147: l_legislation_code per_business_groups.legislation_code%TYPE;
4148: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
4149: i per_all_assignments_f.business_group_id%TYPE;
4150: l_valid_action VARCHAR2(2);
4151: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Deduction_Amount';
4152: BEGIN
4153: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 4424: i per_all_assignments_f.business_group_id%TYPE;

4420: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
4421: l_balance_amount NUMBER :=0;
4422: l_bal_total_amt NUMBER :=0;
4423: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
4424: i per_all_assignments_f.business_group_id%TYPE;
4425: l_legislation_code per_business_groups.legislation_code%TYPE;
4426: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
4427: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
4428: l_new_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

Line 4675: i per_all_assignments_f.business_group_id%TYPE;

4671: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
4672: l_balance_amount NUMBER :=0;
4673: l_bal_total_amt NUMBER :=0;
4674: l_dimension_name VARCHAR2(100);
4675: i per_all_assignments_f.business_group_id%TYPE;
4676: l_legislation_code per_business_groups.legislation_code%TYPE;
4677: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
4678: l_index NUMBER;
4679: BEGIN

Line 4883: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

4879: -- Pension_Criteria_Full_Profile: The Main extract criteria that would be used
4880: -- for the pension extract.
4881: -- =============================================================================
4882: FUNCTION Pension_Criteria_Full_Profile
4883: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
4884: ,p_effective_date IN DATE
4885: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
4886: ,p_warning_message OUT NOCOPY VARCHAR2
4887: ,p_error_message OUT NOCOPY VARCHAR2

Line 4885: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

4881: -- =============================================================================
4882: FUNCTION Pension_Criteria_Full_Profile
4883: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
4884: ,p_effective_date IN DATE
4885: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
4886: ,p_warning_message OUT NOCOPY VARCHAR2
4887: ,p_error_message OUT NOCOPY VARCHAR2
4888: ) RETURN VARCHAR2 IS
4889: -- =========================================

Line 4940: FROM per_all_assignments_f paf

4936: ,c_gre_id IN NUMBER) IS
4937:
4938: SELECT 'X'
4939:
4940: FROM per_all_assignments_f paf
4941: ,hr_soft_coding_keyflex hcf
4942:
4943: WHERE paf.assignment_id = c_assignment_id
4944: AND paf.business_group_id = c_business_group_id

Line 4991: FROM per_all_assignments_f paf

4987: ,c_start_date IN DATE
4988: ,c_end_date IN DATE
4989: ) IS
4990: SELECT 'x'
4991: FROM per_all_assignments_f paf
4992: ,hr_soft_coding_keyflex hcf
4993: WHERE paf.assignment_id = c_assignment_id
4994: AND hcf.soft_coding_keyflex_id(+) = paf.soft_coding_keyflex_id
4995: AND (c_tax_unit_id IS NULL OR

Line 5016: i per_all_assignments_f.business_group_id%TYPE;

5012: -- =========================================
5013: l_ext_params csr_ext_params%ROWTYPE;
5014: l_conc_reqest_id ben_ext_rslt.request_id%TYPE;
5015: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE;
5016: i per_all_assignments_f.business_group_id%TYPE;
5017: l_ext_rslt_id ben_ext_rslt.ext_rslt_id%TYPE;
5018: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;
5019: l_return_value VARCHAR2(2) :='N';
5020: l_valid_action VARCHAR2(2);

Line 5463: FROM per_all_assignments_f

5459: l_person_id NUMBER;
5460: BEGIN
5461: SELECT person_id
5462: INTO l_person_id
5463: FROM per_all_assignments_f
5464: WHERE assignment_id = p_assignment_id
5465: AND ROWNUM < 2;
5466: RETURN l_person_id;
5467: EXCEPTION