DBA Data[Home] [Help]

APPS.PAY_LIV_BUS dependencies on PAY_ELEMENT_LINKS_V

Line 767: l_contributions_used pay_element_links_v.contributions_used%type;

763: ,p_effective_date in date
764: ) is
765: --
766: l_proc varchar2(72) := g_package||'chk_benefit_plan';
767: l_contributions_used pay_element_links_v.contributions_used%type;
768: l_name pay_input_values_f.name%type;
769:
770: Cursor C_contributions_used
771: is

Line 773: from pay_element_links_v

769:
770: Cursor C_contributions_used
771: is
772: select contributions_used
773: from pay_element_links_v
774: where element_link_id = p_element_link_id
775: and p_effective_date between effective_start_date
776: and effective_end_date;
777: