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 PAY_ELEMENT_TYPES_F

Line 14: FROM pay_element_types_f pet1

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

Line 273: FROM pay_element_types_f pet

269: ,c_business_group_id IN NUMBER
270: ,c_legislation_code IN VARCHAR2) IS
271: SELECT pet.element_type_id
272: ,piv.input_value_id
273: FROM pay_element_types_f pet
274: ,pay_input_values_f piv
275: WHERE pet.element_name = c_element_name
276: AND piv.NAME = c_input_name
277: AND (pet.business_group_id = c_business_group_id OR

Line 339: FROM pay_element_types_f pet

335: SELECT pet.element_information_category -- Information Category
336: ,pet.element_information1 -- PreTax Category
337: ,pet.element_information10 -- Primary Balance Id
338: ,pet.element_name -- Element Name
339: FROM pay_element_types_f pet
340: WHERE pet.element_type_id = c_element_type_id
341: AND (pet.business_group_id = c_business_group_id OR
342: pet.legislation_code = c_legislation_code)
343: AND c_effective_date BETWEEN pet.effective_start_date

Line 682: l_ele_type_id pay_element_types_f.element_type_id%TYPE;

678: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Participant_Status_Code';
679: l_per_dates csr_per_dates%ROWTYPE;
680: l_asg_rec csr_asg%ROWTYPE;
681: l_entry_dtls csr_entry_dtls%ROWTYPE;
682: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
683: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
684: l_input_value_id pay_input_values_f.input_value_id%TYPE;
685: l_return_value NUMBER(2) :=0;
686: l_df_st_date DATE := To_Date('1900/01/01','YYYY/MM/DD');

Line 683: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;

679: l_per_dates csr_per_dates%ROWTYPE;
680: l_asg_rec csr_asg%ROWTYPE;
681: l_entry_dtls csr_entry_dtls%ROWTYPE;
682: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
683: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
684: l_input_value_id pay_input_values_f.input_value_id%TYPE;
685: l_return_value NUMBER(2) :=0;
686: l_df_st_date DATE := To_Date('1900/01/01','YYYY/MM/DD');
687: BEGIN

Line 1317: FROM pay_element_types_f pet

1313: ,c_effective_date IN DATE
1314: ,c_business_group_id IN NUMBER
1315: ,c_legislation_code IN VARCHAR2) IS
1316: SELECT pet.element_type_id
1317: FROM pay_element_types_f pet
1318: WHERE pet.element_name = c_element_name
1319: AND (pet.business_group_id = c_business_group_id OR
1320: pet.legislation_code = c_legislation_code)
1321: AND c_effective_date BETWEEN pet.effective_start_date

Line 1327: l_element_name pay_element_types_f.element_name%TYPE;

1323:
1324:
1325: l_input_name pay_input_values_f.NAME%TYPE;
1326: l_input_value_id pay_input_values_f.input_value_id%TYPE;
1327: l_element_name pay_element_types_f.element_name%TYPE;
1328: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
1329: l_balance_name pay_balance_types.balance_name%TYPE;
1330: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
1331: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 1328: l_ele_type_id pay_element_types_f.element_type_id%TYPE;

1324:
1325: l_input_name pay_input_values_f.NAME%TYPE;
1326: l_input_value_id pay_input_values_f.input_value_id%TYPE;
1327: l_element_name pay_element_types_f.element_name%TYPE;
1328: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
1329: l_balance_name pay_balance_types.balance_name%TYPE;
1330: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
1331: l_legislation_code per_business_groups.legislation_code%TYPE;
1332: l_info_category pay_element_types_f.element_information_category%TYPE;

Line 1332: l_info_category pay_element_types_f.element_information_category%TYPE;

1328: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
1329: l_balance_name pay_balance_types.balance_name%TYPE;
1330: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
1331: l_legislation_code per_business_groups.legislation_code%TYPE;
1332: l_info_category pay_element_types_f.element_information_category%TYPE;
1333: l_pretax_category pay_element_types_f.element_information1%TYPE;
1334: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Element_Info';
1335: l_ele_info_rec csr_ele_info%ROWTYPE;
1336: BEGIN

Line 1333: l_pretax_category pay_element_types_f.element_information1%TYPE;

1329: l_balance_name pay_balance_types.balance_name%TYPE;
1330: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
1331: l_legislation_code per_business_groups.legislation_code%TYPE;
1332: l_info_category pay_element_types_f.element_information_category%TYPE;
1333: l_pretax_category pay_element_types_f.element_information1%TYPE;
1334: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Element_Info';
1335: l_ele_info_rec csr_ele_info%ROWTYPE;
1336: BEGIN
1337: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 1601: l_element_name pay_element_types_f.element_name%TYPE;

1597: ,p_ext_dfn_type IN VARCHAR2) IS
1598:
1599: l_input_name pay_input_values_f.NAME%TYPE;
1600: l_input_value_id pay_input_values_f.input_value_id%TYPE;
1601: l_element_name pay_element_types_f.element_name%TYPE;
1602: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
1603: l_balance_name pay_balance_types.balance_name%TYPE;
1604: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
1605: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 1602: l_ele_type_id pay_element_types_f.element_type_id%TYPE;

1598:
1599: l_input_name pay_input_values_f.NAME%TYPE;
1600: l_input_value_id pay_input_values_f.input_value_id%TYPE;
1601: l_element_name pay_element_types_f.element_name%TYPE;
1602: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
1603: l_balance_name pay_balance_types.balance_name%TYPE;
1604: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
1605: l_legislation_code per_business_groups.legislation_code%TYPE;
1606: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Element_Info';

Line 3074: l_ele_type_id pay_element_types_f.element_type_id%TYPE;

3070: ,p_element_set_id IN NUMBER
3071: ,p_effective_date IN DATE
3072: ,p_business_group_id IN NUMBER) IS
3073: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Element_Details';
3074: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
3075: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
3076: l_CatchUp_ele_type_id pay_element_types_f.element_type_id%TYPE;
3077: l_AT_ele_type_id pay_element_types_f.element_type_id%TYPE;
3078: l_Roth_ele_type_id pay_element_types_f.element_type_id%TYPE;

Line 3075: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;

3071: ,p_effective_date IN DATE
3072: ,p_business_group_id IN NUMBER) IS
3073: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Element_Details';
3074: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
3075: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
3076: l_CatchUp_ele_type_id pay_element_types_f.element_type_id%TYPE;
3077: l_AT_ele_type_id pay_element_types_f.element_type_id%TYPE;
3078: l_Roth_ele_type_id pay_element_types_f.element_type_id%TYPE;
3079: l_RothER_Element_id pay_element_types_f.element_type_id%TYPE;

Line 3076: l_CatchUp_ele_type_id pay_element_types_f.element_type_id%TYPE;

3072: ,p_business_group_id IN NUMBER) IS
3073: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Element_Details';
3074: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
3075: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
3076: l_CatchUp_ele_type_id pay_element_types_f.element_type_id%TYPE;
3077: l_AT_ele_type_id pay_element_types_f.element_type_id%TYPE;
3078: l_Roth_ele_type_id pay_element_types_f.element_type_id%TYPE;
3079: l_RothER_Element_id pay_element_types_f.element_type_id%TYPE;
3080: l_ATER_Element_id pay_element_types_f.element_type_id%TYPE;

Line 3077: l_AT_ele_type_id pay_element_types_f.element_type_id%TYPE;

3073: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Element_Details';
3074: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
3075: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
3076: l_CatchUp_ele_type_id pay_element_types_f.element_type_id%TYPE;
3077: l_AT_ele_type_id pay_element_types_f.element_type_id%TYPE;
3078: l_Roth_ele_type_id pay_element_types_f.element_type_id%TYPE;
3079: l_RothER_Element_id pay_element_types_f.element_type_id%TYPE;
3080: l_ATER_Element_id pay_element_types_f.element_type_id%TYPE;
3081: l_ER_element_id pay_element_types_f.element_type_id%TYPE;

Line 3078: l_Roth_ele_type_id pay_element_types_f.element_type_id%TYPE;

3074: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
3075: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
3076: l_CatchUp_ele_type_id pay_element_types_f.element_type_id%TYPE;
3077: l_AT_ele_type_id pay_element_types_f.element_type_id%TYPE;
3078: l_Roth_ele_type_id pay_element_types_f.element_type_id%TYPE;
3079: l_RothER_Element_id pay_element_types_f.element_type_id%TYPE;
3080: l_ATER_Element_id pay_element_types_f.element_type_id%TYPE;
3081: l_ER_element_id pay_element_types_f.element_type_id%TYPE;
3082:

Line 3079: l_RothER_Element_id pay_element_types_f.element_type_id%TYPE;

3075: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
3076: l_CatchUp_ele_type_id pay_element_types_f.element_type_id%TYPE;
3077: l_AT_ele_type_id pay_element_types_f.element_type_id%TYPE;
3078: l_Roth_ele_type_id pay_element_types_f.element_type_id%TYPE;
3079: l_RothER_Element_id pay_element_types_f.element_type_id%TYPE;
3080: l_ATER_Element_id pay_element_types_f.element_type_id%TYPE;
3081: l_ER_element_id pay_element_types_f.element_type_id%TYPE;
3082:
3083: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE;

Line 3080: l_ATER_Element_id pay_element_types_f.element_type_id%TYPE;

3076: l_CatchUp_ele_type_id pay_element_types_f.element_type_id%TYPE;
3077: l_AT_ele_type_id pay_element_types_f.element_type_id%TYPE;
3078: l_Roth_ele_type_id pay_element_types_f.element_type_id%TYPE;
3079: l_RothER_Element_id pay_element_types_f.element_type_id%TYPE;
3080: l_ATER_Element_id pay_element_types_f.element_type_id%TYPE;
3081: l_ER_element_id pay_element_types_f.element_type_id%TYPE;
3082:
3083: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE;
3084: BEGIN

Line 3081: l_ER_element_id pay_element_types_f.element_type_id%TYPE;

3077: l_AT_ele_type_id pay_element_types_f.element_type_id%TYPE;
3078: l_Roth_ele_type_id pay_element_types_f.element_type_id%TYPE;
3079: l_RothER_Element_id pay_element_types_f.element_type_id%TYPE;
3080: l_ATER_Element_id pay_element_types_f.element_type_id%TYPE;
3081: l_ER_element_id pay_element_types_f.element_type_id%TYPE;
3082:
3083: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE;
3084: BEGIN
3085: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 3242: l_ele_type_id pay_element_types_f.element_type_id%TYPE;

3238:
3239: l_valid_action VARCHAR2(2);
3240: l_valid_entry VARCHAR2(2);
3241: l_return_value NUMBER(5);
3242: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
3243: l_input_value_id pay_input_values_f.input_value_id%TYPE;
3244: l_report_dimension VARCHAR2(100);
3245: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Element_Count';
3246: BEGIN

Line 3518: l_ele_type_id pay_element_types_f.element_type_id%TYPE;

3514: ,p_return_value IN OUT NOCOPY VARCHAR2
3515: ,p_no_asg_action IN OUT NOCOPY NUMBER
3516: ,p_error_message OUT NOCOPY VARCHAR2)IS
3517:
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;

Line 3519: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;

3515: ,p_no_asg_action IN OUT NOCOPY NUMBER
3516: ,p_error_message OUT NOCOPY VARCHAR2)IS
3517:
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;

Line 3644: l_ele_type_id pay_element_types_f.element_type_id%TYPE;

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

Line 3645: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;

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

Line 3783: l_ele_type_id pay_element_types_f.element_type_id%TYPE;

3779: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Contr_AmtPer';
3780: l_return_value VARCHAR2(150) ;
3781: l_input_value_id pay_input_values_f.input_value_id%TYPE;
3782: l_get_value BOOLEAN;
3783: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
3784: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
3785: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;
3786: l_Count NUMBER(5) := 0;
3787: BEGIN

Line 3784: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;

3780: l_return_value VARCHAR2(150) ;
3781: l_input_value_id pay_input_values_f.input_value_id%TYPE;
3782: l_get_value BOOLEAN;
3783: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
3784: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
3785: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;
3786: l_Count NUMBER(5) := 0;
3787: BEGIN
3788: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 4145: l_ele_type_id pay_element_types_f.element_type_id%TYPE;

4141:
4142: l_bal_total_amt NUMBER;
4143: l_balance_amount NUMBER;
4144: l_defined_balance_id pay_defined_balances.defined_balance_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;

Line 4146: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;

4142: l_bal_total_amt NUMBER;
4143: l_balance_amount NUMBER;
4144: l_defined_balance_id pay_defined_balances.defined_balance_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);

Line 4325: l_element_type_id pay_element_types_f.element_type_id%TYPE;

4321: ,p_input_name IN VARCHAR2
4322: ,p_error_message OUT NOCOPY VARCHAR2
4323: ) RETURN VARCHAR2 IS
4324:
4325: l_element_type_id pay_element_types_f.element_type_id%TYPE;
4326: l_input_value_id pay_input_values_f.input_value_id%TYPE;
4327: l_result_value pay_run_result_values.result_value%TYPE;
4328: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;
4329: l_effective_date DATE;

Line 4784: FROM pay_element_types_f

4780: CURSOR csr_ele_name( c_element_type_id IN NUMBER
4781: ,c_end_date IN DATE
4782: )IS
4783: SELECT element_name
4784: FROM pay_element_types_f
4785: WHERE element_type_id = c_element_type_id
4786: AND c_end_date BETWEEN effective_start_date
4787: AND effective_end_date;
4788:

Line 4812: l_element_name pay_element_types_f.element_name%TYPE;

4808: WHERE con.consolidation_set_id = c_con_set;
4809: l_proc_name VARCHAR2(150) := g_proc_name ||'Set_ConcProg_Parameter_Values';
4810: l_extract_name ben_ext_dfn.NAME%TYPE;
4811: l_element_set PAY_ELEMENT_SETS.ELEMENT_SET_NAME%TYPE;
4812: l_element_name pay_element_types_f.element_name%TYPE;
4813: l_gre_name hr_organization_units.NAME%TYPE ;
4814: l_payroll_name PAY_PAYROLLS_F.PAYROLL_NAME%TYPE ;
4815: l_con_set_name PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_NAME%TYPE;
4816:

Line 5021: l_ele_type_id pay_element_types_f.element_type_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);
5021: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
5022: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
5023: l_proc_name VARCHAR2(150) := g_proc_name ||'Pension_Criteria_Full_Profile';
5024: l_assig_rec csr_assig%ROWTYPE;
5025: l_Chg_Evt_Exists VARCHAR2(2);

Line 5022: l_prev_ele_type_id pay_element_types_f.element_type_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);
5021: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
5022: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
5023: l_proc_name VARCHAR2(150) := g_proc_name ||'Pension_Criteria_Full_Profile';
5024: l_assig_rec csr_assig%ROWTYPE;
5025: l_Chg_Evt_Exists VARCHAR2(2);
5026: l_effective_date DATE;