DBA Data[Home] [Help]

APPS.PQH_GSP_DEFAULT dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1065: ,pay_element_entry_values_f pev

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
1069: and p_Effective_Date between pee.Effective_Start_Date and pee.Effective_End_Date

Line 1259: ,pay_element_entry_values_f pev

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
1263: and p_Effective_Date between pee.Effective_Start_Date and pee.Effective_End_Date