DBA Data[Home] [Help]

APPS.PQP_GB_OSP_FUNCTIONS dependencies on PAY_ELEMENT_ENTRIES_F

Line 728: FROM pay_element_entries_f ele

724: -- AND ele.effective_start_date BETWEEN eev.effective_start_date
725: -- AND eev.effective_end_date
726: -- AND eev.input_value_id = p_ssp_week_iv_id
727: -- ) SSP_weeks
728: FROM pay_element_entries_f ele
729: WHERE ele.assignment_id = p_primary_assignment_id -- primary assignment id offline
730: AND ele.element_link_id = p_element_link_id -- run once for evry bg related link
731: AND ele.creator_type = 'S' -- determine piw_id offline
732: AND ele.creator_id = p_piw_id;

Line 784: FROM pay_element_entries_f ele

780: -- BETWEEN piv.effective_start_date
781: -- AND piv.effective_end_date
782: -- AND piv.input_value_id = p_recoverable_amount_iv_id -- g_smp_input_values(4).id
783: -- )
784: FROM pay_element_entries_f ele
785: WHERE ele.assignment_id = p_primary_assignment_id -- primary assignment id offline
786: AND ele.element_link_id = p_element_link_id
787: AND ele.creator_type = 'M'
788: AND ele.creator_id = p_maternity_id; -- determine maternity id offline