DBA Data[Home] [Help]

APPS.PQP_GB_PSI_EARNINGS_HISTORY dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 650: FROM per_assignment_extra_info

646: -- Cursor to get eei information
647: CURSOR csr_get_aei_info
648: IS
649: SELECT aei_information1
650: FROM per_assignment_extra_info
651: WHERE assignment_id = p_assignment_id
652: AND information_type = p_information_type;
653:
654: l_proc_name VARCHAR2(80) := g_proc_name || 'get_asg_eit_info';

Line 656: l_svpn_no per_assignment_extra_info.aei_information1%TYPE;

652: AND information_type = p_information_type;
653:
654: l_proc_name VARCHAR2(80) := g_proc_name || 'get_asg_eit_info';
655: l_proc_step PLS_INTEGER;
656: l_svpn_no per_assignment_extra_info.aei_information1%TYPE;
657: l_value NUMBER;
658: --
659: BEGIN
660: --