APPS.PAY_IN_TAX_DECLARATION dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 190: l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%TYPE;

186: l_procedure VARCHAR(100);
187: l_message VARCHAR2(250);
188: l_effective_date DATE;
189: l_assignment_id per_assignments_f.assignment_id%TYPE;
190: l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%TYPE;
191: --
192: BEGIN
193: --
194: l_procedure := g_package || 'is_approved';

Line 419: ,p_extra_info_id OUT NOCOPY per_assignment_extra_info.assignment_extra_info_id%TYPE)

415: --------------------------------------------------------------------------
416: FUNCTION get_approval_status
417: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
418: ,p_tax_year IN VARCHAR2
419: ,p_extra_info_id OUT NOCOPY per_assignment_extra_info.assignment_extra_info_id%TYPE)
420: RETURN VARCHAR2
421: IS
422: --
423: CURSOR csr_approval_details

Line 427: FROM per_assignment_extra_info

423: CURSOR csr_approval_details
424: IS
425: SELECT assignment_extra_info_id
426: , aei_information2 flag
427: FROM per_assignment_extra_info
428: WHERE assignment_id = p_assignment_id
429: AND information_type = g_approval_info_type
430: AND aei_information1 = p_tax_year
431: AND aei_information_category = g_approval_info_type;

Line 6030: l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%TYPE;

6026: l_procedure VARCHAR(100);
6027: l_message VARCHAR2(250);
6028: l_approval_status VARCHAR2(2);
6029: l_object_version_number NUMBER;
6030: l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%TYPE;
6031: --
6032: CURSOR get_object_version(c_extra_info_id IN NUMBER)
6033: IS
6034: SELECT object_version_number

Line 6035: FROM per_assignment_extra_info

6031: --
6032: CURSOR get_object_version(c_extra_info_id IN NUMBER)
6033: IS
6034: SELECT object_version_number
6035: FROM per_assignment_extra_info
6036: WHERE assignment_extra_info_id = c_extra_info_id;
6037: --
6038: BEGIN
6039: fnd_msg_pub.initialize; -- Bug 13767307