APPS.PAY_BATCH_ELEMENT_ENTRY_API dependencies on PAY_BATCH_CONTROL_TOTALS

Line 1246: l_batch_control_id pay_batch_control_totals.batch_control_id%TYPE;

1242: --
1243: -- Declare cursors and local variables
1244: --
1245: l_proc varchar2(72) := g_package||'create_batch_total';
1246: l_batch_control_id pay_batch_control_totals.batch_control_id%TYPE;
1247: l_object_version_number pay_batch_control_totals.object_version_number%TYPE;
1248: l_session_date date;
1249: --
1250: begin

Line 1247: l_object_version_number pay_batch_control_totals.object_version_number%TYPE;

1243: -- Declare cursors and local variables
1244: --
1245: l_proc varchar2(72) := g_package||'create_batch_total';
1246: l_batch_control_id pay_batch_control_totals.batch_control_id%TYPE;
1247: l_object_version_number pay_batch_control_totals.object_version_number%TYPE;
1248: l_session_date date;
1249: --
1250: begin
1251: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2176: l_object_version_number pay_batch_control_totals.object_version_number%TYPE;

2172: --
2173: -- Declare cursors and local variables
2174: --
2175: l_proc varchar2(72) := g_package||'update_batch_total';
2176: l_object_version_number pay_batch_control_totals.object_version_number%TYPE;
2177: l_session_date date;
2178: --
2179: begin
2180: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2301: from pay_batch_control_totals bct

2297: where btl.batch_id = p_batch_id;
2298: --
2299: cursor csr_batch_ctl_totals is
2300: select bct.batch_control_id,bct.object_version_number
2301: from pay_batch_control_totals bct
2302: where bct.batch_id = p_batch_id;
2303: --
2304: begin
2305: hr_utility.set_location('Entering:'|| l_proc, 5);