APPS.PAY_IN_TAX_DECLARATION dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 189: l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%TYPE;

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

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

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

Line 426: FROM per_assignment_extra_info

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

Line 5250: l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%TYPE;

5246: l_procedure VARCHAR(100);
5247: l_message VARCHAR2(250);
5248: l_approval_status VARCHAR2(2);
5249: l_object_version_number NUMBER;
5250: l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%TYPE;
5251: --
5252: CURSOR get_object_version(c_extra_info_id IN NUMBER)
5253: IS
5254: SELECT object_version_number

Line 5255: FROM per_assignment_extra_info

5251: --
5252: CURSOR get_object_version(c_extra_info_id IN NUMBER)
5253: IS
5254: SELECT object_version_number
5255: FROM per_assignment_extra_info
5256: WHERE assignment_extra_info_id = c_extra_info_id;
5257: --
5258: BEGIN
5259: --