DBA Data[Home] [Help]

APPS.PQH_GSP_POST_PROCESS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1830: pay_element_entry_values_f entval

1826: CURSOR Element_Info(P_assignmnet_id number,P_pay_basis_id number, P_Effective_Date in DAte) IS
1827: Select ele.element_entry_id
1828: from per_pay_bases bas,
1829: pay_element_entries_f ele,
1830: pay_element_entry_values_f entval
1831: where bas.pay_basis_id = P_pay_basis_id
1832: and entval.input_value_id = bas.input_value_id
1833: and p_effective_date
1834: between entval.effective_start_date

Line 3418: pay_element_entry_values_f entval

3414: CURSOR Element_Info(P_assignmnet_id number,P_pay_basis_id number, P_Effective_Date in DAte) IS
3415: Select ele.element_entry_id
3416: from per_pay_bases bas,
3417: pay_element_entries_f ele,
3418: pay_element_entry_values_f entval
3419: where bas.pay_basis_id = P_pay_basis_id
3420: and entval.input_value_id = bas.input_value_id
3421: and p_effective_date
3422: between entval.effective_start_date