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_PENSION_EXTRACTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 62: FROM per_all_assignments_f paf,

58: paf.employment_category) employment_category
59: ,paf.normal_hours
60: ,pps.date_start
61: ,pps.actual_termination_date
62: FROM per_all_assignments_f paf,
63: per_periods_of_service pps,
64: per_assignment_status_types ast
65: WHERE paf.assignment_id = c_assignment_id
66: AND pps.period_of_service_id(+) = paf.period_of_service_id

Line 305: FROM per_all_assignments_f paf

301: ,paf.grade_id
302: ,paf.job_id
303: ,paf.location_id
304: ,paf.assignment_id
305: FROM per_all_assignments_f paf
306: WHERE paf.assignment_id = c_assignment_id
307: AND paf.business_group_id = g_business_group_id
308: AND c_effective_date BETWEEN paf.effective_start_date
309: AND paf.effective_end_date;

Line 363: (c_primary_assignment_id IN per_all_assignments_f.assignment_id%TYPE

359: -- cursor fetchs the secondary as well as terminated assigs within the extract
360: -- date range.
361: -- =============================================================================
362: CURSOR csr_sec_assg
363: (c_primary_assignment_id IN per_all_assignments_f.assignment_id%TYPE
364: ,c_person_id IN per_all_people_f.person_id%TYPE
365: ,c_effective_date IN DATE
366: ,c_extract_start_date IN DATE
367: ,c_extract_end_date IN DATE ) IS

Line 375: FROM per_all_assignments_f asg

371: ,asg.effective_start_date
372: ,asg.effective_end_date
373: ,asg.primary_flag
374: ,asg.assignment_id
375: FROM per_all_assignments_f asg
376: WHERE asg.person_id = c_person_id
377: AND asg.assignment_id <> c_primary_assignment_id
378: AND asg.assignment_type ='E'
379: AND (( c_effective_date BETWEEN asg.effective_start_date

Line 385: FROM per_all_assignments_f asx

381: )
382: OR
383: ( asg.effective_end_date =
384: (SELECT MAX(asx.effective_end_date)
385: FROM per_all_assignments_f asx
386: WHERE asx.assignment_id = asg.assignment_id
387: AND asx.person_id = c_person_id
388: AND asx.assignment_type = 'E'
389: AND ((asx.effective_end_date BETWEEN c_extract_start_date

Line 2213: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

2209: ,p_person_id IN NUMBER
2210: ,p_asgaction_no IN NUMBER
2211: ,p_error_message OUT NOCOPY VARCHAR2) IS
2212: l_proc_name VARCHAR2(150) := g_proc_name ||'Create_AsgAction_Lines';
2213: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2214: l_organization_id per_all_assignments_f.organization_id%TYPE;
2215: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
2216: l_main_rec csr_rslt_dtl%ROWTYPE;
2217: l_new_rec csr_rslt_dtl%ROWTYPE;

Line 2214: l_organization_id per_all_assignments_f.organization_id%TYPE;

2210: ,p_asgaction_no IN NUMBER
2211: ,p_error_message OUT NOCOPY VARCHAR2) IS
2212: l_proc_name VARCHAR2(150) := g_proc_name ||'Create_AsgAction_Lines';
2213: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2214: l_organization_id per_all_assignments_f.organization_id%TYPE;
2215: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
2216: l_main_rec csr_rslt_dtl%ROWTYPE;
2217: l_new_rec csr_rslt_dtl%ROWTYPE;
2218: l_effective_date DATE;

Line 2215: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

2211: ,p_error_message OUT NOCOPY VARCHAR2) IS
2212: l_proc_name VARCHAR2(150) := g_proc_name ||'Create_AsgAction_Lines';
2213: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2214: l_organization_id per_all_assignments_f.organization_id%TYPE;
2215: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
2216: l_main_rec csr_rslt_dtl%ROWTYPE;
2217: l_new_rec csr_rslt_dtl%ROWTYPE;
2218: l_effective_date DATE;
2219: BEGIN

Line 2312: i per_all_assignments_f.business_group_id%TYPE;

2308:
2309: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
2310: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
2311: l_valid_action VARCHAR2(2);
2312: i per_all_assignments_f.business_group_id%TYPE;
2313: l_proc_name CONSTANT VARCHAR2(150) := g_proc_name ||'Process_Assignments';
2314: l_valid_person_chk VARCHAR2(2);
2315:
2316: BEGIN

Line 2446: i per_all_assignments_f.business_group_id%TYPE;

2442: ,p_error_message OUT NOCOPY VARCHAR2
2443: ) RETURN VARCHAR2 IS
2444:
2445: l_return_value VARCHAR2(50);
2446: i per_all_assignments_f.business_group_id%TYPE;
2447: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
2448: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
2449: l_valid_action VARCHAR2(2);
2450: l_no_asg_action NUMBER(5) := 0;

Line 2457: l_asg_type per_all_assignments_f.assignment_type%TYPE;

2453: l_effective_date DATE;
2454: l_criteria_value VARCHAR2(2);
2455: l_warning_message VARCHAR2(2000);
2456: l_error_message VARCHAR2(2000);
2457: l_asg_type per_all_assignments_f.assignment_type%TYPE;
2458: l_main_rec csr_rslt_dtl%ROWTYPE;
2459: l_person_id per_all_people_f.person_id%TYPE;
2460: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2461: BEGIN

Line 2460: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

2456: l_error_message VARCHAR2(2000);
2457: l_asg_type per_all_assignments_f.assignment_type%TYPE;
2458: l_main_rec csr_rslt_dtl%ROWTYPE;
2459: l_person_id per_all_people_f.person_id%TYPE;
2460: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2461: BEGIN
2462:
2463: hr_utility.set_location('Entering: '||l_proc_name, 5);
2464: i := p_business_group_id;

Line 2818: FROM per_all_assignments_f paf

2814: CURSOR csr_gre_id (c_assignment_id IN NUMBER
2815: ,c_business_group_id IN NUMBER
2816: ,c_effective_date IN DATE) IS
2817: SELECT to_number(nvl(segment1,0))
2818: FROM per_all_assignments_f paf
2819: ,hr_soft_coding_keyflex hfc
2820: WHERE paf.assignment_id = c_assignment_id
2821: AND paf.business_group_id = c_business_group_id
2822: AND c_effective_date BETWEEN paf.effective_start_date

Line 2840: FROM per_all_assignments_f paf

2836: CURSOR csr_per_id(c_assignment_id IN NUMBER
2837: ,c_business_group_id IN NUMBER
2838: ,c_effective_date IN DATE) IS
2839: SELECT paf.person_id
2840: FROM per_all_assignments_f paf
2841: WHERE paf.assignment_id = c_assignment_id
2842: AND paf.business_group_id = c_business_group_id
2843: AND c_effective_date BETWEEN paf.effective_start_date
2844: AND paf.effective_end_date;

Line 3213: FROM per_all_assignments_f paf

3209: CURSOR csr_pay_basis (c_assignment_id IN NUMBER
3210: ,c_effective_date IN DATE
3211: ,c_business_group_id IN NUMBER) IS
3212: SELECT ppb.pay_annualization_factor
3213: FROM per_all_assignments_f paf
3214: ,per_pay_bases ppb
3215: WHERE assignment_id = c_assignment_id
3216: AND paf.pay_basis_id = ppb.pay_basis_id
3217: AND ppb.business_group_id = c_business_group_id

Line 3242: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;

3238: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Data_Elements';
3239: l_return_value VARCHAR2(250);
3240: l_base_salary NUMBER(15,2);
3241: l_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
3242: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
3243: BEGIN
3244: hr_utility.set_location('Entering: '||l_proc_name, 5);
3245: IF g_primary_assig.EXISTS(p_assignment_id) THEN
3246: IF p_data_ele_name = 'EMPLOYMENT_CATEGORY' THEN

Line 3477: i per_all_assignments_f.business_group_id%TYPE;

3473: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
3474: l_balance_amount NUMBER :=0;
3475: l_bal_total_amt NUMBER :=0;
3476: l_dimension_name VARCHAR2(100);
3477: i per_all_assignments_f.business_group_id%TYPE;
3478: l_legislation_code per_business_groups.legislation_code%TYPE;
3479: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
3480: l_index NUMBER;
3481: l_valid_person_chk VARCHAR2(2);

Line 3812: ,per_all_assignments_f paa

3808: ,paa.location_id
3809: ,paa.organization_id
3810:
3811: FROM per_all_people_f paf
3812: ,per_all_assignments_f paa
3813: WHERE paf.person_id = c_person_id
3814: AND paa.person_id = paf.person_id
3815: AND paa.assignment_type = 'E'
3816: AND paa.business_group_id = paf.business_group_id

Line 3906: i per_all_assignments_f.business_group_id%TYPE;

3902: l_balance_amount NUMBER := 0;
3903: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
3904: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
3905: l_legislation_code per_business_groups.legislation_code%TYPE;
3906: i per_all_assignments_f.business_group_id%TYPE;
3907: l_input_value_id pay_input_values_f.input_value_id%TYPE;
3908: l_valid_action VARCHAR2(2);
3909: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Pay_value';
3910: l_valid_person_chk VARCHAR2(2);

Line 3997: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

3993: -- Pension_Criteria_Full_Profile: The Main extract criteria that would be used
3994: -- for the pension extract.
3995: -- =============================================================================
3996: FUNCTION Pension_Criteria_Full_Profile
3997: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
3998: ,p_effective_date IN DATE
3999: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
4000: ,p_warning_message OUT NOCOPY VARCHAR2
4001: ,p_error_message OUT NOCOPY VARCHAR2

Line 3999: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

3995: -- =============================================================================
3996: FUNCTION Pension_Criteria_Full_Profile
3997: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
3998: ,p_effective_date IN DATE
3999: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
4000: ,p_warning_message OUT NOCOPY VARCHAR2
4001: ,p_error_message OUT NOCOPY VARCHAR2
4002: ) RETURN VARCHAR2 IS
4003: -- =========================================

Line 4064: FROM per_all_assignments_f paf

4060: ,c_org_id IN NUMBER) IS
4061:
4062: SELECT 'X'
4063:
4064: FROM per_all_assignments_f paf
4065:
4066: WHERE paf.assignment_id = c_assignment_id
4067: AND paf.business_group_id = c_business_group_id
4068: AND (c_org_id IS NULL OR

Line 4111: FROM per_all_assignments_f paf

4107: ,c_start_date IN DATE
4108: ,c_end_date IN DATE
4109: ) IS
4110: SELECT 'x'
4111: FROM per_all_assignments_f paf
4112: WHERE paf.assignment_id = c_assignment_id
4113: AND (c_payroll_id IS NULL OR
4114: paf.payroll_id = NVL(c_payroll_id,paf.payroll_id)
4115: )

Line 4131: i per_all_assignments_f.business_group_id%TYPE;

4127: -- =========================================
4128: l_ext_params csr_ext_params%ROWTYPE;
4129: l_conc_reqest_id ben_ext_rslt.request_id%TYPE;
4130: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE;
4131: i per_all_assignments_f.business_group_id%TYPE;
4132: l_ext_rslt_id ben_ext_rslt.ext_rslt_id%TYPE;
4133: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;
4134: l_return_value VARCHAR2(2) :='N';
4135: l_valid_action VARCHAR2(2);

Line 4654: FROM per_all_assignments_f

4650: l_person_id NUMBER;
4651: BEGIN
4652: SELECT person_id
4653: INTO l_person_id
4654: FROM per_all_assignments_f
4655: WHERE assignment_id = p_assignment_id
4656: AND ROWNUM < 2;
4657: RETURN l_person_id;
4658: EXCEPTION