DBA Data[Home] [Help]

APPS.PAY_USER_COLUMN_INSTA_MATRIX dependencies on HR_PUMP_BATCH_LINES

Line 575: from hr_pump_batch_lines

571: If (p_batch_line_id is not null)
572: then
573:
574: select link_value into l_link_value
575: from hr_pump_batch_lines
576: where batch_line_id = p_batch_line_id;
577:
578: else
579:

Line 623: select nvl(max(link_value),0)+1 into l_link_value from hr_pump_batch_lines;

619: using l_user_table_user_key,l_user_table_user_key,l_user_table_user_key,l_user_table_name,p_business_group_name;
620: fetch ref_link_value into l_link_value;
621: if ref_link_value%notfound
622: then
623: select nvl(max(link_value),0)+1 into l_link_value from hr_pump_batch_lines;
624: end if;
625: close ref_link_value;
626: end if;
627: