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_INPUT_VALUES_F

Line 36: FROM pay_input_values_f piv

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

Line 222: FROM pay_input_values_f piv

218: ,c_element_type_id IN NUMBER
219: ,c_assignment_id IN NUMBER
220: ,c_input_value_id IN NUMBER) IS
221: SELECT pev.screen_entry_value
222: FROM pay_input_values_f piv
223: ,pay_element_entry_values_f pev
224: ,pay_element_entries_f pee
225: ,pay_element_links_f pel
226: WHERE c_effective_date BETWEEN piv.effective_start_date

Line 345: ,pay_input_values_f piv

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

Line 798: l_input_name pay_input_values_f.NAME%TYPE :='Pay Value';

794: SELECT pbt.balance_name
795: FROM pay_balance_types pbt
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;

Line 799: l_input_value_id pay_input_values_f.input_value_id%TYPE;

795: FROM pay_balance_types pbt
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;

Line 3099: FROM pay_input_values_f piv

3095: ,c_assignment_id IN NUMBER
3096: ,c_input_value_id IN NUMBER) IS
3097: SELECT pev.screen_entry_value
3098: ,pee.effective_start_date
3099: FROM pay_input_values_f piv
3100: ,pay_element_entry_values_f pev
3101: ,pay_element_entries_f pee
3102: ,pay_element_links_f pel
3103: WHERE c_effective_date BETWEEN piv.effective_start_date

Line 3125: l_input_value_id pay_input_values_f.input_value_id%TYPE;

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

Line 3380: l_input_value_id pay_input_values_f.input_value_id%TYPE;

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

Line 3907: l_input_value_id pay_input_values_f.input_value_id%TYPE;

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);
3911: BEGIN