DBA Data[Home] [Help]

APPS.PQP_GB_PSI_EARNINGS_HISTORY dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 730: FROM per_assignment_extra_info

726: -- Cursor to get eei information
727: CURSOR csr_get_aei_info
728: IS
729: SELECT aei_information1
730: FROM per_assignment_extra_info
731: WHERE assignment_id = p_assignment_id
732: AND information_type = p_information_type;
733:
734: l_proc_name VARCHAR2(80) := g_proc_name || 'get_asg_eit_info';

Line 736: l_svpn_no per_assignment_extra_info.aei_information1%TYPE;

732: AND information_type = p_information_type;
733:
734: l_proc_name VARCHAR2(80) := g_proc_name || 'get_asg_eit_info';
735: l_proc_step PLS_INTEGER;
736: l_svpn_no per_assignment_extra_info.aei_information1%TYPE;
737: l_value NUMBER;
738: --
739: BEGIN
740: --