DBA Data[Home] [Help]

APPS.PQH_EMPLOYEE_SALARY dependencies on PAY_INPUT_VALUES_F

Line 28: l_input_value_id pay_input_values_f.Input_Value_id%TYPE;

24: p_pay_basis_frequency OUT nocopy varchar2
25: ) IS
26: --
27: L_Cur_Sal Per_pay_Proposals.PROPOSED_SALARY_N%TYPE;
28: l_input_value_id pay_input_values_f.Input_Value_id%TYPE;
29: l_dummy_iv_id pay_input_values_f.Input_Value_id%TYPE;
30: l_business_group_id Per_All_Assignments_f.business_group_id%type;
31: --
32: l_pay_basis_id Per_All_Assignments_f.pay_basis_id%type;

Line 29: l_dummy_iv_id pay_input_values_f.Input_Value_id%TYPE;

25: ) IS
26: --
27: L_Cur_Sal Per_pay_Proposals.PROPOSED_SALARY_N%TYPE;
28: l_input_value_id pay_input_values_f.Input_Value_id%TYPE;
29: l_dummy_iv_id pay_input_values_f.Input_Value_id%TYPE;
30: l_business_group_id Per_All_Assignments_f.business_group_id%type;
31: --
32: l_pay_basis_id Per_All_Assignments_f.pay_basis_id%type;
33: l_pgm_id Per_All_Assignments_f.GRADE_LADDER_PGM_ID%type;

Line 52: pay_input_values_f piv,

48: --
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