DBA Data[Home] [Help]

APPS.PQH_GSP_POST_PROCESS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1990: pay_element_entry_values_f entval

1986: CURSOR Element_Info(P_assignmnet_id number,P_pay_basis_id number, P_Effective_Date in DAte) IS
1987: Select ele.element_entry_id
1988: from per_pay_bases bas,
1989: pay_element_entries_f ele,
1990: pay_element_entry_values_f entval
1991: where bas.pay_basis_id = P_pay_basis_id
1992: and entval.input_value_id = bas.input_value_id
1993: and p_effective_date
1994: between entval.effective_start_date

Line 3578: pay_element_entry_values_f entval

3574: CURSOR Element_Info(P_assignmnet_id number,P_pay_basis_id number, P_Effective_Date in DAte) IS
3575: Select ele.element_entry_id
3576: from per_pay_bases bas,
3577: pay_element_entries_f ele,
3578: pay_element_entry_values_f entval
3579: where bas.pay_basis_id = P_pay_basis_id
3580: and entval.input_value_id = bas.input_value_id
3581: and p_effective_date
3582: between entval.effective_start_date