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_INPUT_VALUES_F

Line 33: FROM pay_input_values_f piv

29: ,c_effective_date IN DATE
30: ,c_business_group_id IN NUMBER
31: ,c_legislation_code IN VARCHAR2 ) IS
32: SELECT piv.input_value_id
33: FROM pay_input_values_f piv
34: WHERE piv.NAME = c_input_name
35: AND piv.element_type_id = c_element_type_id
36: AND (piv.business_group_id = c_business_group_id OR
37: piv.legislation_code = c_legislation_code)

Line 188: FROM pay_input_values_f piv

184: ,c_element_type_id IN NUMBER
185: ,c_assignment_id IN NUMBER
186: ,c_input_value_id IN NUMBER) IS
187: SELECT pev.screen_entry_value
188: FROM pay_input_values_f piv
189: ,pay_element_entry_values_f pev
190: ,pay_element_entries_f pee
191: ,pay_element_links_f pel
192: WHERE c_effective_date BETWEEN piv.effective_start_date

Line 274: ,pay_input_values_f piv

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
278: pet.legislation_code = c_legislation_code)

Line 658: FROM pay_input_values_f piv

654: ,c_assignment_id IN NUMBER
655: ,c_input_value_id IN NUMBER) IS
656: SELECT pev.screen_entry_value
657: ,pee.effective_start_date
658: FROM pay_input_values_f piv
659: ,pay_element_entry_values_f pev
660: ,pay_element_entries_f pee
661: ,pay_element_links_f pel
662: WHERE c_effective_date BETWEEN piv.effective_start_date

Line 684: l_input_value_id pay_input_values_f.input_value_id%TYPE;

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
688: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 1325: l_input_name pay_input_values_f.NAME%TYPE;

1321: AND c_effective_date BETWEEN pet.effective_start_date
1322: AND pet.effective_end_date;
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;

Line 1326: l_input_value_id pay_input_values_f.input_value_id%TYPE;

1322: AND pet.effective_end_date;
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;

Line 1599: l_input_name pay_input_values_f.NAME%TYPE;

1595: ,p_business_group_id IN NUMBER
1596: ,p_effective_date IN DATE
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;

Line 1600: l_input_value_id pay_input_values_f.input_value_id%TYPE;

1596: ,p_effective_date IN DATE
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;

Line 3243: l_input_value_id pay_input_values_f.input_value_id%TYPE;

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
3247: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 3781: l_input_value_id pay_input_values_f.input_value_id%TYPE;

3777: ,p_error_message OUT NOCOPY VARCHAR2
3778: ) RETURN NUMBER IS
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;

Line 4326: l_input_value_id pay_input_values_f.input_value_id%TYPE;

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;
4330: l_return_value VARCHAR2(50) := '0';