APPS.PER_IE_ASG_EXT_INFO dependencies on DUAL

Line 26: FROM dual;

22: l_ppsn_number per_all_people_f.national_identifier%type;
23:
24: CURSOR cur_check_ppsn is
25: SELECT NVL(instr(substr(P_AEI_INFORMATION1,1,length(l_ppsn_number)),l_ppsn_number),0) check_ppsn
26: FROM dual;
27:
28: l_check_ppsn number;
29:
30: BEGIN

Line 71: FROM dual;

67: l_ppsn_number per_all_people_f.national_identifier%type;
68:
69: CURSOR cur_check_ppsn is
70: SELECT NVL(instr(substr(P_AEI_INFORMATION1,1,length(l_ppsn_number)),l_ppsn_number),0) check_ppsn
71: FROM dual;
72:
73: l_check_ppsn number;
74:
75: BEGIN