DBA Data[Home] [Help]

APPS.PQH_GSP_DEFAULT dependencies on PAY_ELEMENT_ENTRIES_F

Line 1064: from pay_element_entries_f pee

1060: L_Cur_Sal Per_pay_Proposals.PROPOSED_SALARY_N%TYPE;
1061: l_input_value_id pay_input_values_f.Input_Value_id%TYPE;
1062: Cursor Sal is
1063: select pev.screen_entry_value
1064: from pay_element_entries_f pee
1065: ,pay_element_entry_values_f pev
1066: where pev.element_entry_id = pee.element_entry_id
1067: and p_Effective_Date between pev.Effective_Start_Date and pev.Effective_End_Date
1068: and pee.assignment_id = p_assignment_id

Line 1258: from pay_element_entries_f pee

1254: L_Payroll_name pay_all_payrolls_f.Payroll_name%TYPE;
1255:
1256: Cursor Sal is
1257: select pev.screen_entry_value*l_annualization_factor
1258: from pay_element_entries_f pee
1259: ,pay_element_entry_values_f pev
1260: where pev.element_entry_id = pee.element_entry_id
1261: and p_Effective_Date between pev.Effective_Start_Date and pev.Effective_End_Date
1262: and pee.assignment_id = p_assignment_id