DBA Data[Home] [Help]

APPS.PQH_EMPLOYEE_SALARY dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 37: L_Salary pay_element_entry_values_f.screen_entry_value%TYPE;

33: l_pgm_id Per_All_Assignments_f.GRADE_LADDER_PGM_ID%type;
34: l_payroll_id Per_All_Assignments_f.payroll_id%type;
35: l_basis_Annl_fctr Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
36: l_precision Fnd_Currencies.Precision%type;
37: L_Salary pay_element_entry_values_f.screen_entry_value%TYPE;
38: --
39: --
40: l_proc varchar2(72);
41: --

Line 53: pay_element_entry_values_f pev,

49: Cursor Sal is
50: Select pev.screen_entry_value,pet.INPUT_CURRENCY_CODE
51: From pay_element_entries_f pee,
52: pay_input_values_f piv,
53: pay_element_entry_values_f pev,
54: pay_element_types_f pet
55: Where pee.Assignment_id = P_Assignment_id
56: and P_Effective_Date
57: between pee.Effective_Start_Date and pee.Effective_End_Date