APPS.PSB_HR_POPULATE_DATA_PVT dependencies on PER_GRADES

Line 320: FROM PER_GRADES

316: where set_of_books_id = p_set_of_books_id;
317:
318: Cursor C_grade is
319: SELECT grade_id,name
320: FROM PER_GRADES
321: WHERE grade_id = p_entry_grade_id
322: AND business_group_id = p_business_group_id;
323:
324: Cursor C_pay_elements_step IS

Line 405: ' FROM PER_GRADES pg,PER_GRADE_DEFINITIONS_KFV pgv ' ||

401:
402: --+ grade name using dynamic sql
403: /* l_sql_stmt :=
404: 'SELECT pg.grade_id,pgv.concatenated_segments '||
405: ' FROM PER_GRADES pg,PER_GRADE_DEFINITIONS_KFV pgv ' ||
406: ' WHERE pg.grade_id = ' || p_entry_grade_id ||
407: ' AND pg.business_group_id = ' || p_business_group_id ||
408: ' AND pg.grade_definition_id = pgv.grade_definition_id ' ||
409: ' AND pgv.id_flex_num = ' || l_grade_id_flex_num ;

Line 1030: ' From Per_grades,per_grade_definitions '||

1026: dbms_sql.define_column(v_cursorid,1,v_segment,80);
1027:
1028: elsif (l_definition_structure = 'Grade Flexfield') then
1029: l_sql_stmt := 'Select '||l_application_column_name||
1030: ' From Per_grades,per_grade_definitions '||
1031: ' Where per_grades.grade_id = '||p_entry_grade_id||
1032: ' and per_grades.grade_definition_id = '||
1033: ' per_grade_definitions.grade_definition_id';
1034: dbms_sql.parse(v_cursorid,l_sql_stmt,dbms_sql.v7);

Line 1031: ' Where per_grades.grade_id = '||p_entry_grade_id||

1027:
1028: elsif (l_definition_structure = 'Grade Flexfield') then
1029: l_sql_stmt := 'Select '||l_application_column_name||
1030: ' From Per_grades,per_grade_definitions '||
1031: ' Where per_grades.grade_id = '||p_entry_grade_id||
1032: ' and per_grades.grade_definition_id = '||
1033: ' per_grade_definitions.grade_definition_id';
1034: dbms_sql.parse(v_cursorid,l_sql_stmt,dbms_sql.v7);
1035: dbms_sql.define_column(v_cursorid,1,v_segment,80);

Line 1032: ' and per_grades.grade_definition_id = '||

1028: elsif (l_definition_structure = 'Grade Flexfield') then
1029: l_sql_stmt := 'Select '||l_application_column_name||
1030: ' From Per_grades,per_grade_definitions '||
1031: ' Where per_grades.grade_id = '||p_entry_grade_id||
1032: ' and per_grades.grade_definition_id = '||
1033: ' per_grade_definitions.grade_definition_id';
1034: dbms_sql.parse(v_cursorid,l_sql_stmt,dbms_sql.v7);
1035: dbms_sql.define_column(v_cursorid,1,v_segment,80);
1036: end if;