APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on DUAL

Line 71: FROM dual;

67: end if;
68:
69: SELECT USERENV('sessionid') into
70: lsession
71: FROM dual;
72:
73: -- Set up effective Date
74: Select count(*) into l_cnt
75: from fnd_sessions

Line 3775: l_attribute_value_id from dual;

3771: End Loop;
3772:
3773: if (l_attr_dummy = 0) then
3774: select psb_attribute_values_s.nextval into
3775: l_attribute_value_id from dual;
3776: end if;
3777:
3778:
3779: INSERT INTO PSB_ATTRIBUTE_VALUES_I

Line 3849: l_attribute_value_id from dual;

3845: End Loop;
3846:
3847: if (l_attr_dummy = 0) then
3848: select psb_attribute_values_s.nextval into
3849: l_attribute_value_id from dual;
3850: end if;
3851:
3852: /* Bug 4075170 Start */
3853: l_debug_info := 'Inserting for Atrribute Id '

Line 3928: l_attribute_value_id from dual;

3924: End Loop;
3925:
3926: if (l_attr_dummy = 0) then
3927: select psb_attribute_values_s.nextval into
3928: l_attribute_value_id from dual;
3929: end if;
3930:
3931: /* Bug 4075170 Start */
3932: l_debug_info := 'Inserting for Atrribute Id '

Line 4068: l_attribute_value_id from dual;

4064: End Loop;
4065:
4066: if (l_attr_dummy = 0) then
4067: select psb_attribute_values_s.nextval into
4068: l_attribute_value_id from dual;
4069: end if;
4070:
4071: INSERT INTO PSB_ATTRIBUTE_VALUES_I
4072: (

Line 4149: l_attribute_value_id from dual;

4145: End Loop;
4146:
4147: if (l_attr_dummy = 0) then
4148: select psb_attribute_values_s.nextval into
4149: l_attribute_value_id from dual;
4150: end if;
4151:
4152: INSERT INTO PSB_ATTRIBUTE_VALUES_I
4153: (

Line 4196: l_attribute_value_id from dual;

4192: End Loop;
4193:
4194: if (l_attr_dummy = 0) then
4195: select psb_attribute_values_s.nextval into
4196: l_attribute_value_id from dual;
4197: end if;
4198:
4199: INSERT INTO PSB_ATTRIBUTE_VALUES_I
4200: (

Line 5147: from dual;

5143: Begin
5144: Select ltrim(rtrim(substr(Attr_type_rec.select_table,
5145: instr(Attr_type_rec.select_table,' ',1),
5146: length(Attr_type_rec.select_table) - instr(Attr_type_rec.select_table,' ',1) + 1))) into l_alias1
5147: from dual;
5148: end;
5149:
5150: if (Attr_type_rec.link_type = 'PER_ALL_ASSIGNMENTS') then
5151: l_emp_col := 'assignment_id';

Line 5319: from dual;

5315: Begin
5316: Select ltrim(rtrim(substr(Attr_type_rec.select_table,
5317: instr(Attr_type_rec.select_table,' ',1),
5318: length(Attr_type_rec.select_table) - instr(Attr_type_rec.select_table,' ',1) + 1))) into l_alias1
5319: from dual;
5320: end;
5321:
5322: --if (l_emp_val is not null) then
5323: v_qcursorid := dbms_sql.open_cursor;

Line 5474: from dual;

5470: Begin
5471: Select ltrim(rtrim(substr(Attr_type_rec.select_table,
5472: instr(Attr_type_rec.select_table,' ',1),
5473: length(Attr_type_rec.select_table) - instr(Attr_type_rec.select_table,' ',1) + 1))) into l_alias1
5474: from dual;
5475: End;
5476:
5477: if (Attr_type_rec.select_table = Attr_type_rec.link_type) then
5478: o_sql_stmt := 'Select '||

Line 7223: from dual;

7219: instr(C_Attribute_Types_Rec.select_table,' ',1),
7220: length(C_Attribute_Types_Rec.select_table)
7221: - instr(C_Attribute_Types_Rec.select_table,' ',1) + 1)))
7222: into l_alias1
7223: from dual;
7224: end;
7225:
7226: if (C_Attribute_Types_Rec.link_type = 'PER_ALL_ASSIGNMENTS') then
7227: l_emp_col := 'assignment_id';

Line 7367: where session_id = (select USERENV('sessionid') from dual);

7363: PROCEDURE Final_Process is
7364: Begin
7365:
7366: Delete fnd_sessions
7367: where session_id = (select USERENV('sessionid') from dual);
7368:
7369: End Final_Process;
7370:
7371: /* ----------------------------------------------------------------------- */