DBA Data[Home] [Help]

APPS.PER_BF_PROC_ASSIGNMENT_API dependencies on PER_BF_PROCESSED_ASSIGNMENTS

Line 17: FROM per_bf_processed_assignments

13: --
14: -- Cursors
15: CURSOR csr_find_row IS
16: SELECT 'Y'
17: FROM per_bf_processed_assignments
18: WHERE payroll_run_id = p_payroll_run_id
19: AND assignment_id = p_assignment_id;
20: --
21: l_exists varchar2(1);

Line 88: PER_BF_PROCESSED_ASSIGNMENTS.processed_assignment_id%TYPE;

84: --
85: -- Declare cursors and local variables
86: --
87: l_processed_assignment_id
88: PER_BF_PROCESSED_ASSIGNMENTS.processed_assignment_id%TYPE;
89: l_processed_assignment_ovn
90: PER_BF_PROCESSED_ASSIGNMENTS.object_version_number%TYPE;
91: --
92: l_proc varchar2(72) := g_package||'create_processed_assignment';

Line 90: PER_BF_PROCESSED_ASSIGNMENTS.object_version_number%TYPE;

86: --
87: l_processed_assignment_id
88: PER_BF_PROCESSED_ASSIGNMENTS.processed_assignment_id%TYPE;
89: l_processed_assignment_ovn
90: PER_BF_PROCESSED_ASSIGNMENTS.object_version_number%TYPE;
91: --
92: l_proc varchar2(72) := g_package||'create_processed_assignment';
93: --
94: begin

Line 342: PER_BF_PROCESSED_ASSIGNMENTS.object_version_number%TYPE;

338: --
339: l_processed_assignment_id NUMBER;
340: --
341: l_processed_assignment_ovn
342: PER_BF_PROCESSED_ASSIGNMENTS.object_version_number%TYPE;
343: --
344: l_proc varchar2(72) := g_package||'update_processed_assignment';
345: begin
346: hr_utility.set_location('Entering:'|| l_proc, 10);