APPS.PAY_DK_TC_DP_UPLOAD dependencies on HR_PUMP_BATCH_HEADERS

Line 118: l_batch_name hr_pump_batch_headers.batch_name%type;

114:
115:
116: --Flag variables
117: l_element_link_found VARCHAR2(30);
118: l_batch_name hr_pump_batch_headers.batch_name%type;
119:
120: cursor get_batch_name(p_batch_name hr_pump_batch_headers.batch_name%type) is
121: select batch_name from hr_pump_batch_headers where batch_name = p_batch_name;
122:

Line 120: cursor get_batch_name(p_batch_name hr_pump_batch_headers.batch_name%type) is

116: --Flag variables
117: l_element_link_found VARCHAR2(30);
118: l_batch_name hr_pump_batch_headers.batch_name%type;
119:
120: cursor get_batch_name(p_batch_name hr_pump_batch_headers.batch_name%type) is
121: select batch_name from hr_pump_batch_headers where batch_name = p_batch_name;
122:
123: CURSOR csr_leg (v_bg_id per_business_groups.business_group_id%TYPE)
124: IS

Line 121: select batch_name from hr_pump_batch_headers where batch_name = p_batch_name;

117: l_element_link_found VARCHAR2(30);
118: l_batch_name hr_pump_batch_headers.batch_name%type;
119:
120: cursor get_batch_name(p_batch_name hr_pump_batch_headers.batch_name%type) is
121: select batch_name from hr_pump_batch_headers where batch_name = p_batch_name;
122:
123: CURSOR csr_leg (v_bg_id per_business_groups.business_group_id%TYPE)
124: IS
125: SELECT legislation_code, name