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 PAY_ELEMENT_TYPES_F

Line 16: FROM pay_element_types_f pet1

12: WHERE petr.element_set_id = c_element_set_id
13: AND petr.include_or_exclude = 'I'
14: UNION ALL
15: SELECT DISTINCT pet1.element_type_id
16: FROM pay_element_types_f pet1
17: WHERE pet1.classification_id IN
18: (SELECT classification_id
19: FROM pay_ele_classification_rules
20: WHERE element_set_id = c_element_set_id)

Line 344: FROM pay_element_types_f pet

340: ,c_business_group_id IN NUMBER
341: ,c_legislation_code IN VARCHAR2) IS
342: SELECT pet.element_type_id
343: ,piv.input_value_id
344: FROM pay_element_types_f pet
345: ,pay_input_values_f piv
346: WHERE pet.element_name = c_element_name
347: AND piv.NAME = c_input_name
348: AND (pet.business_group_id = c_business_group_id OR

Line 785: FROM pay_element_types_f pet

781: SELECT pet.element_information_category -- Information Category
782: ,pet.element_information1 -- PreTax Category
783: ,pet.element_information10 -- Primary Balance Id
784: ,pet.element_name -- Element Name
785: FROM pay_element_types_f pet
786: WHERE pet.element_type_id = c_element_type_id
787: AND (pet.business_group_id = c_business_group_id OR
788: pet.legislation_code = c_legislation_code)
789: AND c_effective_date BETWEEN pet.effective_start_date

Line 800: l_element_name pay_element_types_f.element_name%TYPE;

796: WHERE pbt.balance_type_id = c_balance_type_id;
797:
798: l_input_name pay_input_values_f.NAME%TYPE :='Pay Value';
799: l_input_value_id pay_input_values_f.input_value_id%TYPE;
800: l_element_name pay_element_types_f.element_name%TYPE;
801: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
802: l_balance_name pay_balance_types.balance_name%TYPE;
803: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
804: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 801: l_ele_type_id pay_element_types_f.element_type_id%TYPE;

797:
798: l_input_name pay_input_values_f.NAME%TYPE :='Pay Value';
799: l_input_value_id pay_input_values_f.input_value_id%TYPE;
800: l_element_name pay_element_types_f.element_name%TYPE;
801: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
802: l_balance_name pay_balance_types.balance_name%TYPE;
803: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
804: l_legislation_code per_business_groups.legislation_code%TYPE;
805: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Element_Info';

Line 2274: l_ele_type_id pay_element_types_f.element_type_id%TYPE;

2270: ,p_element_set_id IN NUMBER
2271: ,p_effective_date IN DATE
2272: ,p_business_group_id IN NUMBER) IS
2273: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Element_Details';
2274: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
2275: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
2276: l_CatchUp_ele_type_id pay_element_types_f.element_type_id%TYPE;
2277: l_AT_ele_type_id pay_element_types_f.element_type_id%TYPE;
2278: BEGIN

Line 2275: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;

2271: ,p_effective_date IN DATE
2272: ,p_business_group_id IN NUMBER) IS
2273: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Element_Details';
2274: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
2275: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
2276: l_CatchUp_ele_type_id pay_element_types_f.element_type_id%TYPE;
2277: l_AT_ele_type_id pay_element_types_f.element_type_id%TYPE;
2278: BEGIN
2279: hr_utility.set_location('Entering: '||l_proc_name, 5);

Line 2276: l_CatchUp_ele_type_id pay_element_types_f.element_type_id%TYPE;

2272: ,p_business_group_id IN NUMBER) IS
2273: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Element_Details';
2274: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
2275: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
2276: l_CatchUp_ele_type_id pay_element_types_f.element_type_id%TYPE;
2277: l_AT_ele_type_id pay_element_types_f.element_type_id%TYPE;
2278: BEGIN
2279: hr_utility.set_location('Entering: '||l_proc_name, 5);
2280: -- If element set was selected

Line 2277: l_AT_ele_type_id pay_element_types_f.element_type_id%TYPE;

2273: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Element_Details';
2274: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
2275: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
2276: l_CatchUp_ele_type_id pay_element_types_f.element_type_id%TYPE;
2277: l_AT_ele_type_id pay_element_types_f.element_type_id%TYPE;
2278: BEGIN
2279: hr_utility.set_location('Entering: '||l_proc_name, 5);
2280: -- If element set was selected
2281: FOR ele_rec IN csr_ele_id (c_element_set_id => p_element_set_id)

Line 2309: l_ele_type_id pay_element_types_f.element_type_id%TYPE;

2305: ,p_no_asg_action IN OUT NOCOPY NUMBER
2306: ,p_error_message OUT NOCOPY VARCHAR2
2307: ) IS
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';

Line 2310: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;

2306: ,p_error_message OUT NOCOPY VARCHAR2
2307: ) IS
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);

Line 2447: l_ele_type_id pay_element_types_f.element_type_id%TYPE;

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;
2451: l_proc_name VARCHAR2(150) := g_proc_name ||'Check_Asg_Actions';

Line 2448: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;

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;
2451: l_proc_name VARCHAR2(150) := g_proc_name ||'Check_Asg_Actions';
2452: l_sec_assg_rec csr_sec_assg%ROWTYPE;

Line 3123: l_ele_type_id pay_element_types_f.element_type_id%TYPE;

3119: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Participant_Status_Code';
3120: l_per_dates csr_per_dates%ROWTYPE;
3121: l_asg_rec csr_asg%ROWTYPE;
3122: l_entry_dtls csr_entry_dtls%ROWTYPE;
3123: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
3124: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
3125: l_input_value_id pay_input_values_f.input_value_id%TYPE;
3126: l_return_value NUMBER(2) :=0;
3127: l_df_st_date DATE := To_Date('1900/01/01','YYYY/MM/DD');

Line 3124: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;

3120: l_per_dates csr_per_dates%ROWTYPE;
3121: l_asg_rec csr_asg%ROWTYPE;
3122: l_entry_dtls csr_entry_dtls%ROWTYPE;
3123: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
3124: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
3125: l_input_value_id pay_input_values_f.input_value_id%TYPE;
3126: l_return_value NUMBER(2) :=0;
3127: l_df_st_date DATE := To_Date('1900/01/01','YYYY/MM/DD');
3128: BEGIN

Line 3379: l_element_type_id pay_element_types_f.element_type_id%TYPE;

3375: ,p_input_name IN VARCHAR2
3376: ,p_error_message OUT NOCOPY VARCHAR2
3377: ) RETURN VARCHAR2 IS
3378:
3379: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3380: l_input_value_id pay_input_values_f.input_value_id%TYPE;
3381: l_result_value pay_run_result_values.result_value%TYPE;
3382: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;
3383: l_effective_date DATE;

Line 3654: FROM pay_element_types_f

3650: CURSOR csr_ele_name( c_element_type_id IN NUMBER
3651: ,c_end_date IN DATE
3652: )IS
3653: SELECT element_name
3654: FROM pay_element_types_f
3655: WHERE element_type_id = c_element_type_id
3656: AND c_end_date BETWEEN effective_start_date
3657: AND effective_end_date;
3658:

Line 3701: l_element_name pay_element_types_f.element_name%TYPE;

3697:
3698: l_proc_name VARCHAR2(150) := g_proc_name ||'Set_ConcProg_Parameter_Values';
3699: l_extract_name ben_ext_dfn.NAME%TYPE;
3700: l_element_set pay_element_sets.element_set_name%TYPE;
3701: l_element_name pay_element_types_f.element_name%TYPE;
3702: l_gre_name hr_organization_units.NAME%TYPE ;
3703: l_payroll_name pay_payrolls_f.payroll_name%TYPE ;
3704: l_con_set_name pay_consolidation_sets.consolidation_set_name%TYPE;
3705: l_org_name hr_all_organization_units.NAME%TYPE;

Line 3903: l_ele_type_id pay_element_types_f.element_type_id%TYPE;

3899: ,p_error_message OUT NOCOPY VARCHAR2
3900: ) RETURN NUMBER IS
3901: l_bal_total_amt NUMBER := 0;
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;

Line 3904: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;

3900: ) RETURN NUMBER IS
3901: l_bal_total_amt NUMBER := 0;
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);

Line 4136: l_ele_type_id pay_element_types_f.element_type_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);
4136: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
4137: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
4138: l_proc_name VARCHAR2(150) := g_proc_name ||'Pension_Criteria_Full_Profile';
4139: l_assig_rec csr_assig%ROWTYPE;
4140: l_valid_person_chk VARCHAR2(2);

Line 4137: l_prev_ele_type_id pay_element_types_f.element_type_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);
4136: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
4137: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
4138: l_proc_name VARCHAR2(150) := g_proc_name ||'Pension_Criteria_Full_Profile';
4139: l_assig_rec csr_assig%ROWTYPE;
4140: l_valid_person_chk VARCHAR2(2);
4141: l_Chg_Evt_Exists VARCHAR2(2);