APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on FND_COMMON_LOOKUPS

Line 3521: from fnd_common_lookups

3517: v_jdummy INTEGER;
3518:
3519: Cursor C6 is
3520: Select lookup_code,meaning,description
3521: from fnd_common_lookups
3522: where lookup_type = l_lookup_type;
3523:
3524: lsql_stmt varchar2(500);
3525: v_cursorid integer;

Line 3909: -- Get values for lookup_type from fnd_common_lookups

3905: Loop
3906: l_lookup_type := C_table_rec.name;
3907: End Loop;
3908:
3909: -- Get values for lookup_type from fnd_common_lookups
3910:
3911: Open C6;
3912: Loop
3913:

Line 5325: ' From Fnd_Common_lookups a , '||

5321:
5322: --if (l_emp_val is not null) then
5323: v_qcursorid := dbms_sql.open_cursor;
5324: q_sql_stmt := 'Select a.meaning '||
5325: ' From Fnd_Common_lookups a , '||
5326: Attr_type_rec.select_tab||' '||l_alias1||' ,'||
5327: Attr_type_rec.link_type||' '||Attr_type_rec.l_alias2||
5328: ' Where a.lookup_type = '||''''||
5329: l_lookup_type||''''||

Line 7303: ' From Fnd_Common_lookups a , '||

7299: -- table code
7300: elsif (C_Attribute_Types_Rec.attribute_type = 'QC') then
7301: v_qcursorid := dbms_sql.open_cursor;
7302: q_sql_stmt := 'Select a.meaning '||
7303: ' From Fnd_Common_lookups a , '||
7304: C_Attribute_Types_Rec.select_tab||' '||l_alias1||' ,'||
7305: C_Attribute_Types_Rec.link_type||' '||
7306: C_Attribute_Types_Rec.l_alias2||
7307: ' Where a.lookup_type = '||''''||